[mysqld] skip-networking port=3306 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock max_connections=200 max_user_connections=20 interactive_timeout=100 wait_timeout=100 query_cache_limit=1M query_cache_size=32M query_cache_type=1 key_buffer=124M record_buffer=12M max_allowed_packet=1M table_cache=1024 sort_buffer_size=1M read_buffer_size=1M read_rnd_buffer_size=768K myisam_sort_buffer_size=64M thread_cache_size=80 # Try number of CPU's*2 for thread_concurrency thread_concurrency=4