|
配置文件必须是数据库形式的存储7 O+ i: t0 G7 K
5 u) b- Y# C d
- #配置慢查询
9 W' h) X* Y" z5 n& E% t - slow_query_log = ON- y: t8 u! E* w! N) h
- log_output=table: c1 R# @8 c2 n$ _8 O' e
- slow_query_log_file = /home/mysqlData/slow_query.log
5 q, A2 y0 D1 a' x5 j - long_query_time = 0.5
( C3 {- ~# E2 r0 ? - log_queries_not_using_indexes=ON
复制代码 使用以下命令- m1 u r* m* j- E( ?) E9 e: N
( ^5 T% y, b' H% r( \. |3 ?- q
- SET GLOBAL slow_query_log = 'OFF';
- X# ?/ j* T* |( I0 ~' U, Z - ALTER TABLE mysql.slow_log RENAME mysql.slow_log_drop;
4 ?! w: U* }2 P$ } - CREATE TABLE mysql.slow_log LIKE mysql.slow_log_drop;
`9 Z* i5 i7 r* E5 ?3 G - SET GLOBAL slow_query_log = 'ON';
4 I8 @ I3 c' M' s" f% j$ G: \ - DROP TABLE mysql.slow_log_drop;
复制代码 |
|