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

mysql慢查询日志记录

标签：nbsp   body   like   class   variables   pos   ble   exe   sql