mysql配置

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); 
SET global sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); 
set global wait_timeout=100; 
set global interactive_timeout=300;
set global max_connections=600;

# 开启慢查询
set global slow_query_log='ON';
show variables like 'slow_query%';
原文地址:https://www.cnblogs.com/linjiqin/p/10719271.html