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%';

 

posted on 2019-04-16 19:30  Ruthless  阅读(297)  评论(0编辑  收藏  举报