作者: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 |
+---------------------+----------------------------------------+