linux启用MySQL慢查询

vim /etc/my.cnf[mysqld]slow-query-log = on slow_query_log_file = /var/log/slow_query.log long_query_time = 3 log-queries-not-using-indexes = on # 列出没有使用索引的查询语句

　　

Windows下开启MySQL慢查询

log-slow-queries = D:＼log＼mysql_low_query.loglong_query_time = 2

　　

慢查询日志工具mysqlsla

mysqlsla -lt slow /var/log/slow_query.log