tags:

views:

355

answers:

1

Can I disable general logging completely without restarting the server?

Because, per the documentation:

SET sql_log_bin = {0|1}

Disables or enables binary logging for the current connection (sql_log_bin is a session variable) if the client has the SUPER privilege. The statement is refused with an error if the client does not have that privilege.

Can I enable/disable general log without restarting MySQL?

A: 

For MySQL 5.0 "The session sql_log_off variable can be set to ON or OFF to disable or enable general query logging for the current connection." [MySQL Doc, Log file]

tuergeist