|
配置文件必须是数据库形式的存储
- d6 o# B( E# Q J* d# }# W' S3 Y u6 o) [* T' P+ U
- #配置慢查询 a) X( p% X$ {$ @1 W/ \& X6 U& o
- slow_query_log = ON
/ y. a1 }; _4 s4 w5 N- P - log_output=table+ b8 B& C( w. N R% b
- slow_query_log_file = /home/mysqlData/slow_query.log4 o3 H( o1 o! G" h8 i' d$ q
- long_query_time = 0.5
( W7 K' z% u3 T4 ]8 M( E - log_queries_not_using_indexes=ON
复制代码 使用以下命令
6 P- O9 a: s k. _* G3 Z; Q9 u. J9 p. u. w+ h, B" s
- SET GLOBAL slow_query_log = 'OFF';; W# T* y8 Z+ t4 t( M: e
- ALTER TABLE mysql.slow_log RENAME mysql.slow_log_drop;
! x' C3 V5 n4 t, G! y - CREATE TABLE mysql.slow_log LIKE mysql.slow_log_drop;4 {9 Z& Y; X1 U) {8 b
- SET GLOBAL slow_query_log = 'ON';, V1 X1 t* {/ G& X( ]2 l
- DROP TABLE mysql.slow_log_drop;
复制代码 |
|