mysql慢查询日志切换

mysql> show variables like '%slow%';

mysql> set global slow_query_log=0;

mysql> show variables like '%slow%'; -- check slow log status

mysql> set global slow_query_log_file='/mysqllog/slow_log/slow_queries_3306_new.log';

mysql> set global slow_query_log=1;

mysql> show variables like '%slow%';

转载于:https://www.cnblogs.com/wdrain/p/11527520.html