1、检查数据库慢查询是否开启
mysql> show variables like 'slow%';
+---------------------+-------------------------------------------------------------+
| Variable_name | Value |
+---------------------+-------------------------------------------------------------+
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | E:\wamp\bin\mysql\mysql5.7.23\data\PC-20170918DYTS-slow.log |
+---------------------+-------------------------------------------------------------+
3 rows in set, 1 warning (0.00 sec)
slow_launch_time:执行2秒为慢查询
slow_query_log:开启状态 ON-开启 OFF-关闭
slow_query_log_file:保存的慢查询日志地址
2、打开my.ini文件
比如:E:/wamp/bin/mysql/mysql5.7.23/my.ini
3、开启慢查询,需要在mysqld下面添加如下配置
[mysqld]
long_query_time = 2
slow_query_log = ON
4、重启数据库
5、运行结果:
mysql> show variables like 'slow%';
+---------------------+-------------------------------------------------------------+
| Variable_name | Value |
+---------------------+-------------------------------------------------------------+
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | E:\wamp\bin\mysql\mysql5.7.23\data\PC-20170918DYTS-slow.log |
+---------------------+-------------------------------------------------------------+
3 rows in set, 1 warning (0.00 sec)
mysql> show global status like 'slow%';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
+---------------------+-------+
2 rows in set (0.00 sec)
Slow_queries:慢查询的数量
216

被折叠的 条评论
为什么被折叠?



