|
配置文件必须是数据库形式的存储8 L" Q9 v. J( x4 r6 k* P& O. J# i
2 ~2 K: l/ |4 D2 i
- #配置慢查询. v+ o/ C4 ]- x
- slow_query_log = ON
5 q; k( ]) M7 K0 s6 T+ n - log_output=table9 B' Y* _: E5 n$ |0 b# Y! y3 V
- slow_query_log_file = /home/mysqlData/slow_query.log0 E7 O+ j( Z- z6 k1 r8 l
- long_query_time = 0.56 j T1 ~+ T$ S6 I L- z
- log_queries_not_using_indexes=ON
复制代码 使用以下命令( p$ k% i0 H" m3 y, z* K
2 S0 C, f+ x: G! a, P- SET GLOBAL slow_query_log = 'OFF';# d- C' \5 F- f5 f n! H
- ALTER TABLE mysql.slow_log RENAME mysql.slow_log_drop;' Q) `* m& F( \2 s
- CREATE TABLE mysql.slow_log LIKE mysql.slow_log_drop;
8 [( w, e# c, ~ - SET GLOBAL slow_query_log = 'ON';
8 h9 c; K$ ?" K2 ^ - DROP TABLE mysql.slow_log_drop;
复制代码 |
|