File: //etc/my.cnf
[client-server]
!includedir /etc/my.cnf.d
[mysqld]
log-error = /var/lib/mysql/linux1gbr.centraldnserver.com.err
bind-address = 127.0.0.1
performance-schema = 0
innodb_buffer_pool_size = 16G
local-infile = 0
max_allowed_packet = 1G
open_files_limit = 80000
innodb_file_per_table = 1
default-storage-engine = MyISAM
query_cache_size = 1M
query_cache_type=1
query_cache_limit = 1G
performance_schema = ON
innodb_log_file_size = 4G
max_connections = 1200
wait_timeout = 180
interactive_timeout = 180
join_buffer_size = 8G
max_heap_table_size=1283M
key_buffer_size = 3G
sql_mode = ''
tmp_table_size=1283M
innodb_buffer_pool_instances = 16
[mysqldump]
max_allowed_packet = 1G