Wamp 数据库优化之慢查询配置

最新推荐文章于 2022-09-23 16:01:05 发布

原创最新推荐文章于 2022-09-23 16:01:05 发布 · 486 阅读

0 ·

CC 4.0 BY-SA版权

MYSQL 专栏收录该内容

9 篇文章

订阅专栏

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：慢查询的数量