MySQL log file disable
If you would like to dynamically stop logging, login as root@localhost
and run this:
SET GLOBAL general_log = 'OFF';
That's it. No restart of mysql needed.
If you are not root@localhost
, you will need to be logged in as a user with SUPER privilege.
In MySQL 5.1.12+ add/change this in your my.cnf
general-log = 0
In MySQL 5.1.11- remove this in your my.cnf
log
or
log =
Source:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_general_log
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_log