[mysqld] #key_buffer_size+(read_buffer_size+sort_buffer_size)*max_connections #=384M+(2M+2M)*100=784M port = 3306 skip-external-locking #跳过外部锁定 key_buffer_size = 384M #256M(内存1G) 400M(内存2G) max_allowed_packet = 2M #2M(内存1G) 4M(内存2G) table_open_cache = 64 #small=4,medium=64,large=256,huge=512 sort_buffer_size = 2M #2M(内存1G) 4M(内存2G) 8M(内存4G) net_buffer_length = 512K read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M #64M(内存1G) 128M(内存2G) thread_cache_size = 8 #8(内存1G) 64(内存2G) query_cache_size = 32M #32M(内存1G) 64M(内存2G) # Try number of CPU‘s*2 for thread_concurrency thread_concurrency = 8 max_connections = 100 #允许的并行客户端连接数目。 wait_timeout = 60 #等待超时时间 connect_timeout = 3 #连接超时 interactive_timeout = 120 #活动连接超时 long_query_time = 1 #长查询时间 log-slow-queries = mysqlslowquery.log #记录慢查询 log-bin=mysql-bin binlog_format=mixed server-id = 20660 replicate-rewrite-db="96dt_radio->96dt_radio" replicate-do-db=96dt_radio
原文：http://www.cnblogs.com/firadio/p/3513022.html