详解mysql数据库如何开启慢查询日志

log-slow-queries = C:\xampp\mysql_slow_query.log
long_query_time=3

//查看慢查询时间，单位：s
show variables like "long_query_time";

//查看慢查询配置情况
show status like "%slow_queries%";

//查看慢查询日志路径
 show variables like "%slow%";
 

SELECT SLEEP(10)，name from user where userid=1;

 

show global status like '%slow%';