MySQL Tuning

7.5.2. Tuning Server Parameters

14.2.11. InnoDB Performance Tuning Tips

7.5.9.8 Performance Tuning Tips

MySQL InnoDB Performance Tuning for the Solaris 10 OS

Some helpful tips

This is taken from http://www.gossamer-threads.com/lists/mythtv/users/91034:

key_buffer = 48M
max_allowed_packet = 8M
table_cache = 128
sort_buffer_size = 48M
net_buffer_length = 8M
thread_cache_size = 4
query_cache_type = 1
query_cache_size = 4M

query_cache - this caches repeated SQL queries.

key_buffer - used for caching primary key indexes.

table_cache - tells mysql how many table files handles to keep open simultaneously.

thread_cache_size - this tells mysql to keep worker threads around which are expensive to start up, but cheap to maintain

sort_buffer_size - this value is used during queries to hold results in memory otherwise it creates temporary result tables on disk

net_buffer_length - should help on larger network based queries to improve throughput