root@database01 my.cnf.d]# cat server.cnf
[server]
skip-name-resolve
max_allowed_packet=50M
character_set_server   = utf8
collation_server       = utf8_unicode_ci
character-set-server=utf8
init-connect='SET NAMES utf8'
port=3306
# Fix connection Limit
open_files_limit = 8192
# Amount of Nodes x Requests x 2 for NFS
max_connections=1000
# "Tuning MySQL for eZ Publish" on share.ez.no
table_cache=4000
# Amount of Nodes x Requests x 2 for NFS
max_connections=800
# "Tuning MySQL for eZ Publish" on share.ez.no
key_buffer=3G
# "Tuning MySQL for eZ Publish" on share.ez.no
sort_buffer_size=2M
# Harmless, only allocated if needed
max_allowed_packet=16M
# Value for 64 BIT Systems
thread_stack=256KB
# Higher value for site with many connections
thread_cache_size=400
# Full safty
myisam-recover=BACKUP
# "Tuning MySQL for eZ Publish" on share.ez.no
query_cache_type=1
# Unsure, if this settings is optimal
query_cache_limit=4M
# Abe, 2010-07-30, following mysqltuner.pl recommendations (updated 2010-12-28 following tuning-primer.sh)
query_cache_size=64M
# was 128K? (Recommendation: > 128.0K, or always use indexes with joins)
join_buffer_size=8M
tmp_table_size=800M
wait_timeout=50
innodb_lock_wait_timeout=50
max_heap_table_size=800M
#http://dba.stackexchange.com/questions/2918/about-single-threaded-versus-multithreaded-databases-performance/2948#2948
innodb_thread_concurrency=0
#innodb_log_file_size = 32M #Small log files, more page flush
#innodb_log_files_in_group=2
#innodb_log_buffer_size=8M
#innodb_read_io_threads=4
#innodb_write_io_threads=8
#http://dimitrik.free.fr/blog/archives/2012/10/mysql-performance-innodb-buffer-pool-instances-in-56.html
innodb_buffer_pool_instances=20
#http://dba.stackexchange.com/questions/27328/how-large-should-be-mysql-innodb-buffer-pool-size
innodb_buffer_pool_size=20G
innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
innodb_file_per_table=1#to reset password
#skip-grant-tables
tmpdir=/var/mysql.tmp