开启慢查询日志
set persist slow_query_log = 'ON';
set persist slow_query_log_file = '/path/to/your/log/file';
set persist long_query_time = 10.000000;
查询有没有开启
SHOW VARIABLES LIKE 'slow_query_log';
SHOW VARIABLES LIKE 'slow_query_log_file';
SHOW VARIABLES LIKE 'long_query_time';