开启慢查询日志
show variables like '%slow%';
set global slow_query_log = 1;
set global slow_query_log_file = 'D:/mysql/data/slow.log';
set global long_query_time = 1;
set global log_queries_not_using_indexes = 1;
show variables like '%slow%';
set global slow_query_log = 1;
set global slow_query_log_file = 'D:/mysql/data/slow.log';
set global long_query_time = 1;
set global log_queries_not_using_indexes = 1;