|
配置文件必须是数据库形式的存储
, S4 a& I) ` I9 K+ t: ]7 f$ K! v
- k) A+ W+ o1 f" f( _, \ o- #配置慢查询, r }9 v/ A$ h* u
- slow_query_log = ON' x8 k* K: _% L. x
- log_output=table
6 c! i+ A k" B P* Y - slow_query_log_file = /home/mysqlData/slow_query.log
8 @4 W; w) m* ` - long_query_time = 0.5
8 A: c! o% M' |; u0 o2 i5 g6 w% E - log_queries_not_using_indexes=ON
复制代码 使用以下命令' {/ n4 n" {' e n" `! P. S
' m7 ?, z* U% h* R
- SET GLOBAL slow_query_log = 'OFF';
" v- ?& A1 s) s% @$ J - ALTER TABLE mysql.slow_log RENAME mysql.slow_log_drop;
' O1 [" h5 j2 A& Z - CREATE TABLE mysql.slow_log LIKE mysql.slow_log_drop;
1 [- [8 v7 h* A# M6 v - SET GLOBAL slow_query_log = 'ON';6 H2 j& a" b0 X* r
- DROP TABLE mysql.slow_log_drop;
复制代码 |
|