# mysql的cpu占用高,求解决!
# linux as4 我的my.cnf文件如下  内存: 12G   服务器dell R710
[client]socket          = /tmp/mysql.sock
default-character-set=gbk[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
default-character-set=gbkmax_length_for_sort_data = 1024M
max_connections=2000
skip-name-resolve
skip-lockingquery_cache_size=64M
query_cache_type=1
query_cache_limit=32024024record_buffer=4M
back_log=500wait_timeout=7200
interactive_timeout=7200tmp_table_size=200Mkey_buffer = 384M    
max_allowed_packet = 4M  
table_cache = 512     
sort_buffer_size = 512M  
net_buffer_length = 4M  
read_buffer_size = 4M  
read_rnd_buffer_size =8M    
myisam_sort_buffer_size = 64M  log-bin=mysql-bin
server-id       = 1[mysqldump]
quick
max_allowed_packet = 16M[mysql]
no-auto-rehash[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M[mysqlhotcopy]
interactive-timeout