CODEWITHSUNDEEP
mysqlserver-configurationmy.cnf
Alex
Alex

Reputation: 31

Optimal my.cnf recommendation

I'd like to ask anyone with a bit of experience on an opinion of my current my.cnf settings and what optimizations should be done.

Server specs are:

The current my.cnf file is:

[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

Upvotes: 3

Views: 5120

Answers (1)

Anatoly
Anatoly

Reputation: 15530

DBAs recommended to use the Percona Wizard first o all https://tools.percona.com/wizard

Secondly follow this guide: http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/

Upvotes: 0

Related Questions