【Mysql】查看慢查询日志
作者:zhanhailiang 日期:2012-12-19
首先需要知道慢查询日志存放在路径,可以通过如下方法获取:
1. 进入mysql命令行模式
zhanhailiang@linux-06bq:/usr/local/services/mysql/bin> ./mysql mysql> show variables like | Variable_name | Value |+---------------------+----------------------------------------+| slow_launch_time | 2 || slow_query_log || slow_query_log_file |+---------------------+----------------------------------------+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: 94SET 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: 94SET timestamp=1355918268;SHOW TABLE STATUS FROM `hwtrip2`;
入门文档:Mysql慢查询日志查看