# 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
# 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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货