[client-server]
!includedir /etc/my.cnf.d

[mysqld]
log-error = /var/lib/mysql/sg01.asia.cpanel.serverhost.name.err
performance-schema = 0
innodb_buffer_pool_size=6400M
max_allowed_packet = 268435456
open_files_limit=50000
innodb_file_per_table = 1
plugin-load-add = auth_socket.so
unix_socket = OFF

read_rnd_buffer_size=512K
read_buffer_size=256K
log_slow_query_file="/var/log/mysql_slow_queries.log"
key_buffer_size=4294967295
wait_timeout=300
max_connections=256
query_cache_size=128M
general_log_file="/var/lib/mysql/sg01.asia.cpanel.serverhost.name.log"
innodb_log_file_size=1600M
join_buffer_size=512K
log_slow_query=1
innodb_log_buffer_size=32M
max_heap_table_size=637M
query_cache_type=1
tmp_table_size=637M
sort_buffer_size=4M
innodb_buffer_pool_chunk_size=134217728

# Custom settings
default_storage_engine=MyISAM
myisam_recover_options=FORCE

max_user_connections=64

local_infile=0
userstat=1

table_open_cache=2048
table_definition_cache=2048

thread_cache_size=8

query_cache_strip_comments=on
query_cache_limit=128K

innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
transaction_isolation=READ-COMMITTED

skip_external_locking
skip_symbolic_links
skip-secure-auth

sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
event_scheduler=ON

tmpdir=/tmp