【MySQL】联机清空slow log
1:查看slow query log的状态
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
## 启动状态,且清晰的看到文件的位置及名称 mysql> show variables like '%slow%'; +---------------------------+------------------------------------+ | Variable_name | Value | +---------------------------+------------------------------------+ | log_slow_admin_statements | OFF | | log_slow_slave_statements | OFF | | slow_launch_time | 2 | | slow_query_log | ON | | slow_query_log_file | /data/db/mysql/3306/mysql-slow.log | +---------------------------+------------------------------------+ 5 rows in set (0.00 sec) mysql> |
2:停用 slow query log
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
## 修改参数,停用slow query log mysql> set global slow_query_log = 0; Query OK, 0 rows affected (1.67 sec) mysql> ## 确认已停用 mysql> show variables like '%slow%'; +---------------------------+------------------------------------+ | Variable_name | Value | +---------------------------+------------------------------------+ | log_slow_admin_statements | OFF | | log_slow_slave_statements | OFF | | slow_launch_time | 2 | | slow_query_log | OFF | | slow_query_log_file | /data/db/mysql/3306/mysql-slow.log | +---------------------------+------------------------------------+ 5 rows in set (0.00 sec) mysql> |
3:处理slow query log(可以有两种方案,如果文件较大,且需要分析的话,那么建议用第一种)
1)重命名slow_query_log_file
1 |
set global slow_query_log_file=/data/db/mysql/3306/mysql-slow-2.log; |
或者
2)清空mysql-slow.log文件
1 |
[root@ndb1 ~]# > /data/db/mysql/3306/mysql-slow.log |
4:启用slow query log
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
## 修改参数,启动slow query log mysql> set global slow_query_log = 1; Query OK, 0 rows affected (0.00 sec) mysql> ## 确认slow query log 状态 mysql> show variables like '%slow%'; +---------------------------+------------------------------------+ | Variable_name | Value | +---------------------------+------------------------------------+ | log_slow_admin_statements | OFF | | log_slow_slave_statements | OFF | | slow_launch_time | 2 | | slow_query_log | ON | | slow_query_log_file | /data/db/mysql/3306/mysql-slow.log | +---------------------------+------------------------------------+ 5 rows in set (0.01 sec) mysql> |