Bug #52956 RFE: Allow binlog to be turned on/off dynamically (in running server).
Submitted: 19 Apr 2010 22:21 Modified: 28 Oct 2010 12:30
Reporter: Kevin Benton Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1.43 OS:Any
Assigned to: CPU Architecture:Any

[19 Apr 2010 22:21] Kevin Benton
Description:
Please add the ability to turn on binary logging in a running server.  This would help those who need to avoid downtime when all they want to do is start binary logging.  There are also times when things should not be logged and it may not be appropriate to shut down a running server just so a statement can be executed without being logged.

How to repeat:
See description.

Suggested fix:
See description.
[20 Apr 2010 5:38] MySQL Verification Team
if you want to skip a single statement, then this will help you:

set sql_log_bin=0;
alter table t1 engine=innodb;
set sql_log_bin=1;
[28 Oct 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".