|
|
show VARIABLES like '%general_log%';6 d% M g+ M! c$ r2 Q6 X8 S* ?
5 N7 H, @7 Y0 ~) ]' m4 p
set GLOBAL general_log = off;// on-打开; off-关闭* D" J* T1 X# I5 t
/ j8 f& ^( s2 n1 c7 Z
general_log ON7 I% N/ {3 U/ `4 Q4 j
general_log_file /var/log/mysql/query.log
6 i# q! f: q# i; r/ Y H& O
# ?4 g, S. F( P- u- \+ a" y
) M5 `9 V6 O$ J& Y. {$ U( G' b' ]; B* l$ S1 ]; _) ~
mysql> show VARIABLES like '%general_log%';
/ N/ l) d6 v" ?/ a4 O* R+------------------+--------------------------+: S5 x' D' v0 b9 m
| Variable_name | Value |
* W1 P2 s$ l5 m0 M+------------------+--------------------------+
# C. o( g6 u/ K0 r! i| general_log | ON |
# ^, Y: _ } T$ A| general_log_file | /var/log/mysql/mysql.log |& ]5 O- |, z( b$ w* f
+------------------+--------------------------+. ~: ?* Y# d. h& f6 _
2 rows in set (0.00 sec) |
|
发表于 2017-9-27 17:02:12