MySQL之慢查询日志分析

本站寻求有缘人接手，详细了解请联系站长QQ1493399855

在MySQL命令行中查看慢查询日志是否打开了：

mysql> show variables like '%slow_query%';
+---------------------------+-------------------------------------------+
| Variable_name             | Value                                     |
+---------------------------+-------------------------------------------+
| slow_query_log            | OFF                                       |
| slow_query_log_file       | /data/data_mysql/ip-172-31-22-29-slow.log |
+---------------------------+-------------------------------------------+