File: //etc/my.cnf
[client-server]
!includedir /etc/my.cnf.d
[mysqld]
log-error = /var/lib/mysql/23-88-19-39.cprapid.com.err
performance-schema=1
innodb_buffer_pool_size=25956M
max_allowed_packet = 268435456
open_files_limit=80000
innodb_file_per_table = 1
plugin-load-add = auth_socket.so
unix_socket = OFF
sql_mode=NO_ENGINE_SUBSTITUTION
join_buffer_size=1M
key_buffer_size=1321M
max_heap_table_size=1282M
tmp_table_size=1282M
innodb_log_file_size=6489M
interactive_timeout=300
wait_timeout=300
max_connections=500
log_slow_query=1
log_slow_query_time=5