[mysqld] #5.6 conf wait_timeout = 86400 interactive_timeout = 86400 connect_timeout = 60 net_read_timeout = 120 net_write_timeout = 120 key_buffer_size = 512M myisam_sort_buffer_size = 64M read_buffer_size = 4M sort_buffer_size = 4M table_open_cache = 4000 table_definition_cache = 2000 max_connections = 500 # (default: 151) max_connect_errors = 1000000 # (default: 100) skip-name-resolve = 1 # (default: 0) sql_mode = NO_ENGINE_SUBSTITUTION