MySQL服务器参数调优

8核16G

SET PERSIST sync_binlog = 0;
set PERSIST innodb_flush_log_at_trx_commit = 2;
set PERSIST innodb_buffer_pool_size = 4294967296;
set PERSIST sort_buffer_size = 4194304;
set PERSIST join_buffer_size = 4194304;
set PERSIST read_buffer_size = 2097152;
set PERSIST binlog_cache_size = 1048576;
set PERSIST binlog_stmt_cache_size = 1048576;
set PERSIST wait_timeout = 14400;
set PERSIST interactive_timeout = 14400;