[mysqld]
slow_query_log = 1
#日志写入文件
log-slow-queries = "D:/app/phpstudy/MySQL/log/log-slow-queries.log"
#执行时间超过 1 秒记录
long_query_time = 1
#无索引查询
log-queries-not-using-indexes
[mysqld]
slow_query_log = 1
#日志写入文件
log-slow-queries = "D:/app/phpstudy/MySQL/log/log-slow-queries.log"
#执行时间超过 1 秒记录
long_query_time = 1
#无索引查询
log-queries-not-using-indexes
转载于:https://my.oschina.net/famoustone/blog/832448