游客发表

MySQL慢查询日志总结

发帖时间:2025-11-05 04:51:44

MySQL慢查询日志总结
复制mysql> show variables  like %slow_query_log%;    +---------------------+-----------------------------------------------+    | Variable_name       | Value                                         |    +---------------------+-----------------------------------------------+    | slow_query_log      | OFF                                           |    | slow_query_log_file | /home/WDPM/MysqlData/mysql/DB-Server-slow.log |    +---------------------+-----------------------------------------------+    2 rows in set (0.00 sec)    mysql> set global slow_query_log=1;    Query OK,查询 0 rows affected (0.09 sec)    mysql> show variables like %slow_query_log%;    +---------------------+-----------------------------------------------+    | Variable_name       | Value                                         |    +---------------------+-----------------------------------------------+    | slow_query_log      | ON                                            |    | slow_query_log_file | /home/WDPM/MysqlData/mysql/DB-Server-slow.log |    +---------------------+-----------------------------------------------+    2 rows in set (0.00 sec)    mysql>   1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.

    热门排行

    友情链接