|
配置文件必须是数据库形式的存储
0 L: A) h; v ], K t$ P5 X: n6 ?2 d) W& `0 |
- #配置慢查询
4 v6 O( u8 e& r9 a - slow_query_log = ON/ G' s! f6 w) b3 f
- log_output=table1 S9 c& v7 B, E$ K8 O) z8 g2 t' _
- slow_query_log_file = /home/mysqlData/slow_query.log; C* M$ S! `0 _" b: X
- long_query_time = 0.5$ n' @2 j+ Q' ^
- log_queries_not_using_indexes=ON
复制代码 使用以下命令
* y' ~7 k+ i& M+ ^, N; x
* C! d; U3 w0 [" p6 c) T8 A3 b- SET GLOBAL slow_query_log = 'OFF';
! h) ?2 y8 e* W7 I5 ~2 T - ALTER TABLE mysql.slow_log RENAME mysql.slow_log_drop;+ t: ?* q) W2 Y2 q9 A. N
- CREATE TABLE mysql.slow_log LIKE mysql.slow_log_drop;
# E' K- N" `8 {, B8 D3 S: K- }# a. L - SET GLOBAL slow_query_log = 'ON';
; N7 N1 p& \' C6 Y$ T - DROP TABLE mysql.slow_log_drop;
复制代码 |
|