mysql慢查询日志记录

SET global slow_query_log = ON;
SET global long_query_time=0.5;
SET long_query_time=0.5;
SET GLOBAL log_queries_not_using_indexes = 0;
SET GLOBAL slow_query_log_file='/tmp/slowquery.log';
SET GLOBAL log_output = 'FILE'

show variables like 'long_query_time%';
show global variables like 'long_query_time';
show variables like 'log_output%';

转载于:https://www.cnblogs.com/wujunnan/p/8484468.html