一个MySQL的优化配置:

Master 使用了 Innodb ， Slave 使用了 MyISAM

master:
 
max_connections=300
max_user_connections = 290
long_query_time=3
wait_timeout    = 120
interactive_timeout = 120
table_open_cache = 512
read_buffer_size = 128K 
thread_cache_size=32 
 
innodb_buffer_pool_size=5G
 
slave:
 
max_connections = 300
max_user_connections = 290
long_query_time = 3
wait_timeout        =  120
interactive_timeout = 120
table_open_cache = 512
read_buffer_size = 128K
thread_cache_size=32 
 
key_buffer_size = 4G

参考:

http://kb.discuz.net/index.php?title=MySQL%E4%BC%98%E5%8C%96%E7%BB%8F%E9%AA%8C

http://www.mysqlperformanceblog.com/