mysql> SHOW VARIABLES LIKE "general_log%";

+------------------+----------------------------+
| Variable_name | Value |
+------------------+----------------------------+
| general_log | OFF |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+

SRE实战 互联网时代守护先锋,助力企业售后服务体系运筹帷幄!一键直达领取阿里云限量特价优惠。

mysql> SET GLOBAL general_log = 'ON';

Then don't forget to

mysql> SET GLOBAL general_log = 'OFF';

 

from: https://stackoverflow.com/a/7470567/8025086

 

扫码关注我们
微信号:SRE实战
拒绝背锅 运筹帷幄