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