Optimizing MySQL Using my.cnf
Snippet Menu
8
Mon. Oct. 23rd, 2006 7:59 PM
When ByteMyCode was crashing because of the traffic load, we started optimizing MySQL. The server had a load of >50 but the processor was all tied up in IOWAIT. We realized that the database was the source of the bottleneck so we increased all of the cache sizes. Now, it is really fast.
query_cache_type=1
query_cache_limit=5M
query_cache_size=100M
key_buffer=200M
join_buffer=4M
sort_buffer=4M
read_buffer=4M
read_rnd_buffer=4M
record_buffer=4M
wait_timeout=15
table_cache=128
thread_cache=32
max_connections=300
thread_concurrency=10
innodb_buffer_pool_size=40M
innodb_additional_mem_pool_size=40M
key_buffer=128M
Comments
Voting
Votes Up
Votes Down
There are currently no comments for this snippet.