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, 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.
此参数设置的目的一般在主从复制场景,禁用主库的一些操作,比如修改表,权限等,
set sql_log_bin=0;
alter table mytable engine=innodb row_format=compressed;
create user u1 identified by 'china';
set sql_log_bin=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, 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.
此参数设置的目的一般在主从复制场景,禁用主库的一些操作,比如修改表,权限等,
set sql_log_bin=0;
alter table mytable engine=innodb row_format=compressed;
create user u1 identified by 'china';
set sql_log_bin=1;