mysql命令:set sql_log_bin=on/off
对于数据库的操作,经常需要暂时停止对bin-log日志的写入,那就需要这个命令:set sql_log_bin=on/off
参考:dev.mysql.com/doc/refman/5.5/en/set-sql-log-bin.html
13.4.1.3 SET sql_log_bin Syntax
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 theSUPER
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 settingsql_log_bin
globally.
Incorrect use of sql_log_bin
with a global scope means any changes made in an already running session are stillbeing 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.
Beginning with MySQL 5.5.5, it is no longer possible to set @@session.sql_log_bin
within a transaction or subquery. (Bug #53437)
相关文章
- 【MySQL从入门到精通】【高级篇】(十)MyISAM的索引方案&&索引的优缺点
- mysql-利润set变量模拟分组查询每组中的第N条数据
- mysql的分区:使用range分区
- MySQL数据类型优化—整数类型优化选择
- 查询mysql数据库启动时间抛异常
- Mysql 临时变量的 定义 和 赋值 Set 和 Into 赋值; Swith Mysql版本 Case When的用法
- Mysql如何避免全表扫描的方法
- mysql如何更改character-set-server默认为latin1
- MySQL中FIND_IN_SET函数
- MySQL索引问题、种类、使用方法
- mysql备份策略的制定
- Mysql外键设置中的CASCADE、NO ACTION、RESTRICT、SET NULL
- Mysql主从(主从不同步解决办法,常见问题及解决办法,在线对mysql做主从复制)
- MySQL:锁机制 |表级锁、行级锁 | 排它锁、共享锁 | 间隙锁