UnixServerAdmin

Server Administration & Management

MySQL Optimization Tips

Sample values for each variables

max_connections=400
max_user_connections=30
key_buffer=256M (128MB for every 1GB of RAM)
myisam_sort_buffer_size=64M
join_buffer_size=1M
read_buffer_size=1M (1MB for every 1GB of RAM)
sort_buffer_size=1M (1MB for every 1GB of RAM)
table_cache=1500
thread_concurrency=2 (Number of CPUs x 2)
thread_cache_size=128
wait_timeout=10
connect_timeout=5
max_allowed_packet=16M
max_connect_errors=10
query_cache_limit=1M
query_cache_size=32M (32MB for every 1GB of RAM)
query_cache_type=1

June 25, 2012 Posted by | MySQL | | Leave a comment