mysql> SHOW VARIABLES LIKE "general_log%"; +------------------+----------------------------+ | Variable_name | Value | +------------------+----------------------------+ | general_log | OFF | | general_log_file | /var/run/mysqld/mysqld.log | +------------------+----------------------------+ mysql> SET GLOBAL general_log = 'ON';
设置完之后可以看到/var/run/mysqld/mysqld.log有实时的sql。
不用之后记得设置成off 。
-
mysql> SET GLOBAL general_log = 'OFF';
原创文章,作者:章郎虫,如若转载,请注明出处:http://www.szl724.com/database/mysql/2769.html