清除mysql.slow_log表的内容

richwisd

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

1 K; h: z( [2 s0 ^7 S9 A% k, G# w

1. #配置慢查询
   
2. slow_query_log = ON
   1 C/ A) s% R- d; y
3. log_output=table
   ( _# @& E2 d# x2 C$ i# a( W& v
4. slow_query_log_file = /home/mysqlData/slow_query.log
   
5. long_query_time = 0.5
   
6. log_queries_not_using_indexes=ON

复制代码

使用以下命令

6 }" L2 d+ M8 a9 j( U

1. SET GLOBAL slow_query_log = 'OFF';
     C6 X; [3 E+ i1 x6 ?+ c6 \
2. ALTER TABLE mysql.slow_log RENAME mysql.slow_log_drop;
   
3. CREATE TABLE mysql.slow_log LIKE mysql.slow_log_drop;
   0 Q+ t- `5 G. E) C. j( U! C* w% t' A
4. SET GLOBAL slow_query_log = 'ON';
   * i2 x1 u, f: Q, `6 N$ L6 Y- N- Y
5. DROP TABLE mysql.slow_log_drop;

复制代码