MySQL 5.5 Release Notes
SET sql_log_bin = {0|1}
The sql_log_bin variable
controls whether logging to the binary log is done. The default
value is 1 (do logging). To change logging for the current
session, change the session value of this variable. The session
user must have the SUPER
privilege to set this variable. Set this variable to 0 for a
session to temporarily disable binary logging while making
changes to the master which you do not want to replicate to the
slave.
As of MySQL 5.5.41, the global
sql_log_bin variable is read
only and cannot be modified. The global scope is deprecated and
will be removed in a future MySQL release. Prior to 5.5.41,
sql_log_bin can be set as a
global or session variable. Setting
sql_log_bin globally is only
detected when a new session is started. Any sessions previously
running are not impacted when setting
sql_log_bin globally.
Warning
Incorrect use of sql_log_bin
with a global scope means any changes made in an already
running session are still being recorded
to the binary log and therefore replicated. Exercise extreme
caution using sql_log_bin
with a global scope as the above situation could cause
unexpected results including replication failure.
It is not possible to set
@@session.sql_log_bin within a transaction or
subquery.