# # This group is read both by the client and the server # use it for options that affect everything # [client-server] # # include *.cnf from the config directory # !includedir /etc/my.cnf.d [mysqld] log_slow_query=1 log_slow_query_time=3 log_slow_query_file="/var/lib/mysql/slow.log" log-error=/var/lib/mysql/193-8-95-89.cprapid.com.err performance-schema=0 innodb_buffer_pool_size=4G max_allowed_packet=268435456 open_files_limit=65000 innodb_file_per_table=1 innodb_buffer_pool_instances=4 tmp_table_size=128M innodb_log_file_size=1G max_heap_table_size=128M key_buffer_size=318M table_open_cache=8000 table_definition_cache=8000 join_buffer_size=1M unix_socket=OFF