关于服务器mysql的my.cnf配置问题，进来看看

Question

----------------------目前的配置----------------------------
[mysqld]
port = 3306
socket = /tmp/mysql.sock
#skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
user=mysql

local-infile=0
#skip-networking

default-character-set=utf8

myisam-recover = backup,force
myisam_sort_buffer_size = 128M
#skip-locking is deprecated, use skip-external-locking
skip-external-locking
skip-name-resolve
connect_timeout = 15
ft_min_word_len = 1
wait_timeout = 28800
#log-error = /data/mysql/error.log

thread_cache = 8
query_cache_size = 32M
old_passwords=1
max_connections = 3000
max_user_connections = 3000
max_connect_errors = 10000
#set-variable =log_bin_trust_function_creators=1
log_bin_trust_function_creators=1

thread_concurrency = 4
ft_min_word_len = 1
server-id = 1
expire_logs_day = 30
[mysqldump]
quick
max_allowed_packet = 16M
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

[mysql]
default-character-set=utf8

end

大神们看下哪里可以优化的地方，谢谢

Answer 1

关于key_buffer，当前的key_buffer设置为384M，这决定了MyISAM存储引擎使用的索引缓存区的大小。如果你的数据库主要使用InnoDB引擎，可以将key_buffer大小减小或设置为0，因为InnoDB不使用这个缓存区。