Optimize MySQL From my-large.cnf

Copy the my-large.cnf which usually comes with mysql-server , usually inside the /usr/share/mysql directory

Note: you might want to backup your existing my.cnf before doing this.

cp -p /usr/share/mysql/my-large.cnf /etc/my.cnf

Note: All values are in seconds for time and bytes for size unless otherwise specified.

Now Adjust the variables.

wait_timeout = 60

connect_timeout=10

interactive_timeout=120

join_buffer_size=1M

query_cache_size = 128M

query_cache_limit = 2M

max_allowed_packet=16M

table_cache=1024

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size=4M

sort_buffer_size = 8M

key_buffer = 256M

key_buffer_size = 64M

Note : If a query has any of the following functions, it cannot be cached: