【Mysql】查看慢查询日志

  作者:zhanhailiang 日期:2012-12-19

首先需要知道慢查询日志存放在路径，可以通过如下方法获取：

1. 进入mysql命令行模式

zhanhailiang@linux-06bq:/usr/local/services/mysql/bin> ./mysql -u username -p
Enter password: 

2.查看慢查询日志是否打开及存放路径

mysql> show variables like 'slow%';
+---------------------+----------------------------------------+
| Variable_name       | Value                                  |
+---------------------+----------------------------------------+
| slow_launch_time    | 2                                      |
| slow_query_log      | ON                                     |
| slow_query_log_file | /data/logs/servers/mysql/slowquery.log |
+---------------------+----------------------------------------+
3 rows in set (0.00 sec)

3.这样我们就获取mysql的慢查询日志路径

4.接下来打开该文件，查看相应的慢查询日志记录，就可以定位到一些常规则的sql语句问题了。

# Time: 121219 19:57:48
# User@Host: sl[sl] @ localhost []
# Query_time: 4.238980  Lock_time: 0.000044 Rows_sent: 94  Rows_examined: 94
SET timestamp=1355918268;
SHOW TABLE STATUS FROM `hwtrip2`;
# User@Host: sl[sl] @ localhost []
# Query_time: 4.269814  Lock_time: 0.000046 Rows_sent: 94  Rows_examined: 94
SET timestamp=1355918268;
SHOW TABLE STATUS FROM `hwtrip2`;

入门文档：Mysql慢查询日志查看