File: //etc/my.cnf
[mysqld]
performance-schema = ON
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
symbolic-links = 0
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/lib/mysql/server25.dn-server.com.err
local-infile = 0
max_connections = 256
wait_timeout = 28800
interactive_timeout = 28800
query_cache_size = 128M
query_cache_limit = 128M
join_buffer_size = 2G
tmp_table_size = 256M
max_heap_table_size = 256M
thread_cache_size = 4
innodb_buffer_pool_size = 3G
innodb_buffer_pool_instances = 5
key_buffer_size = 2G
table_open_cache = 1024
max_allowed_packet = 536870912
open_files_limit = 66000
default-storage-engine = MyISAM
innodb_file_per_table = 1
sql_mode = ""
[mysqldump]
max_allowed_packet = 500M