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)
最新文章
- JPA入门
- MVC实用构架设计(三)——EF-Code First(6):数据更新最佳实践
- Css动画总结
- 后端学 Angular 2 —— 组件间通信
- oracle当前的连接数
- html5新增语义标签
- php odbc连接 查询显示不完整问题
- 《程序设计中的组合数学》——polya计数
- Hdu4742-Pinball Game 3D(cdq分治+树状数组)
- MultiROM for the XIAOMI MI2S/2C/2! (Kexec HardBoot Enabled with Kexec HardBoot Patch!)
- LoadRunner HTTP+Json 接口性能测试
- iOS聊天客服功能(Udesk)
- Visual Studio Installer 使用案例
- 利用Oracle分析函数row_number和sys_connect_by_path实现多行数据合并为一行
- SCP和Rsync远程拷贝的几个技巧
- 论文笔记系列-Efficient Neural Architecture Search via Parameter Sharing
- Ubuntu 16.04.3 LTS 部署 Cloud Torrent
- Silverlight样式定义
- VC设置视图背景颜色方法
- python处理图片验证码
热门文章
- 显示ACSII码字符表 Exercise05_15
- js创建json对象
- python语言实现阶乘的两种方法---递归和迭代
- Ubuntu 16.04屏幕阅读Screen Reader导致快捷键失灵的问题解决
- 重设Windows 7密码 z
- ASP.NET MVC生命周期介绍(转)
- JSON.parse(str),JSON.stringify(a)
- 本地DNS如何解析公网域名
- pip install py-stringsimjoin error: INCLUDE environment variable is empty
- C# 多线程控制 通讯