我想问一下对我目前的 my.cnf
设置有什么经验以及应该做什么优化的人 .
服务器规格是:
-
CPU:AMD Opteron™3280,8核,8x 2.4 GHz
-
RAM:16 GB DDR3
-
2x 2,000 GB SATA II-HDD,7.2k - RAID 1软件
-
安装了Cloudlinux Cpanel
-
Apache Mysql 5.5 NginxCP eAccelerator
当前的 my.cnf
文件是:
[client]
port=3306
socket="/var/lib/mysql/mysql.sock"
[mysqld]
innodb_additional_mem_pool_size=16M
innodb_buffer_pool_size=10G
innodb_file_per_table=1
innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=2
log-bin=mysql-bin
myisam_sort_buffer_size=64M
expire_logs_days=7
query_cache_size=128M
thread_cache_size=12
max_allowed_packet=15M
skip-federated
table_definition_cache=2048
local-infile=0
table_cache=8192
max_connections=60
read_buffer_size=2M
slow_query_log=1
slow_query_log_file="/var/log/slow_queries.log"
thread_concurrency=16
sort_buffer_size=2M
port=3306
join_buffer_size=16M
key_buffer_size=600M
query_cache_limit=10M
socket="/var/lib/mysql/mysql.sock"
skip-external-locking
query-cache-type=1
long_query_time=5
default-storage-engine=InnoDB
tmp_table_size=384M
max_heap_table_size=384M
[myisamchk]
read_buffer=2M
key_buffer=256M
sort_buffer_size=256M
write_buffer=2M
[mysqldump]
max_allowed_packet=16M
1 回答
DBA建议首先使用Percona向导https://tools.percona.com/wizard
其次按照本指南:http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/