MYSQL慢查询

发表于 分类于 ， ， 阅读次数：

MYSQL慢查询

查看慢查询配置

1
2
show variables LIKE '%slow_query%'; 
show variables like 'long_query_time';

执行结果：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
+---------------------+----------------------------------------------+
| Variable_name       | Value                                        |
+---------------------+----------------------------------------------+
| slow_query_log      | OFF                                          |
| slow_query_log_file | /rdsdbdata/log/slowquery/mysql-slowquery.log |
+---------------------+----------------------------------------------+
2 rows in set (0.00 sec)

+-----------------+-----------+
| Variable_name   | Value     |
+-----------------+-----------+
| long_query_time | 10.000000 |
+-----------------+-----------+
1 row in set (0.00 sec)