清除mysql.slow_log表的内容

richwisd

配置文件必须是数据库形式的存储

1. #配置慢查询
   ' R. S2 f# n( A+ j: n; }4 m
2. slow_query_log = ON
   % b8 J1 [" Z+ v6 G
3. log_output=table
   / O" b, x( `- v, a+ J- J4 ~
4. slow_query_log_file = /home/mysqlData/slow_query.log
   
5. long_query_time = 0.5
   - t5 E* ^5 e, [9 D
6. log_queries_not_using_indexes=ON

复制代码

使用以下命令

! h/ o8 u! P/ b, m1 b$ t

1. SET GLOBAL slow_query_log = 'OFF';
   . H9 s" l9 n- c' V
2. ALTER TABLE mysql.slow_log RENAME mysql.slow_log_drop;
   6 |4 Q* H! }( [* H1 i2 q
3. CREATE TABLE mysql.slow_log LIKE mysql.slow_log_drop;
   0 D6 H% @% h% R& E7 m/ s6 J
4. SET GLOBAL slow_query_log = 'ON';
   
5. DROP TABLE mysql.slow_log_drop;

复制代码