[MySQL] my.cnf 优化设定

主机记忆体2G的my.cnf优化设定，仅供参考：

[mysqld] 
set-variable = key_buffer=512M 
set-variable = max_allowed_packet=4M 
set-variable = table_cache=1024 
set-variable = thread_cache=64 
set-variable = join_buffer_size=32M 
set-variable = sort_buffer=32M 
set-variable = record_buffer=32M 
set-variable = max_connections=32000 
set-variable = wait_timeout=120 
set-variable = interactive_timeout=120 
set-variable = max_connect_errors=30000 
set-variable = long_query_time =1 
set-variable = max_heap_table_size=256M 
set-variable = tmp_table_size=128M
set-variable = thread_concurrency=8 
set-variable = myisam_sort_buffer_size=128M 

[isamchk] 
set-variable = key_buffer=128M 
set-variable = sort_buffer=128M 
set-variable = read_buffer=2M 
set-variable = write_buffer=2M 

[myisamchk] 
set- variable = key_buffer=128M 
set-variable = sort_buffer=128M 
set-variable = read_buffer=2M 
set-variable = write_buffer=2M