MySQL Bugs: #14600: Ability to enable/disable the general query log with SET LOG

Bug #14600	Ability to enable/disable the general query log with SET LOG
Submitted:	3 Nov 2005 10:52	Modified:	15 Jun 2006 17:31
Reporter:	Andrew Stribblehill	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	any	OS:
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
I can query whether or not a host is logging with:
mysql> select @@log;

but I can't alter it. I'd like to turn the log off when the host is running smoothly, but be able to turn it on when I'm about to make some tuning tweaks. Also, it is currently filling up my copy-on-write filesystem snapshot when I take a backup. If I could disable it for the duration, that would be excellent.

How to repeat:
.

This bug is a duplicate of bug #4351.