|
|
show VARIABLES like '%general_log%';
% z- i0 D2 w1 w& d" R$ i+ q9 Z) q& Y: p4 B6 O7 [4 y" W# ~$ {
set GLOBAL general_log = off;// on-打开; off-关闭' B$ p# P9 O/ {) n# B$ O
" q. k/ L& J2 X; \& ?9 V
general_log ON
3 ]3 g- `( l, q! U" U; b' Rgeneral_log_file /var/log/mysql/query.log
5 _& Z. `9 o! _) U
+ ?6 v9 u, V$ h) [% x/ ^ A8 v! w$ u8 K
( |5 Z& e4 c. `! \! s! R5 U# A- |mysql> show VARIABLES like '%general_log%';
& x& e3 V6 q) V( [! f+------------------+--------------------------+7 X7 O- M# }# g$ _4 K3 ~. R2 A
| Variable_name | Value |
% Z4 P8 I+ ~ b; P {, ^+------------------+--------------------------+
6 p/ m) @6 |" u N; M. Q: C: e| general_log | ON |2 H9 ]& w( a @9 X; ^4 n# ]2 X
| general_log_file | /var/log/mysql/mysql.log |
& j% ~; K" B& s" S5 L% {+------------------+--------------------------+5 @9 o6 J: M9 {' ^! b* D
2 rows in set (0.00 sec) |
|
发表于 2017-9-27 17:02:12