lyhabc 发表于 2015-10-06 22:27

@ipigzhu
可以         

love100 发表于 2015-10-08 17:40

sql_log_bin是暂时停止binlog的记录（可以动态关闭或开启），如果放在my.cnf就是停止binlog的记录（无法动态再开启）


如果在mysql的配置文件配置启动了二进制日志，mysql会一直记录二进制日志，修改配置文件，可以停止二进制日志，

但是需要重启mysql数据库。mysql提供了暂时停止二进制日志的功能。通过 SET SQL_LOG_BIN 语句可以使mysql暂停或者启动二进制日志

ipigzhu 发表于 2015-10-26 22:42

回复 2# love100



哥哥 ，概念我懂。但是做的实验结果，和我的有差异啊？？怎么回事？？

   

love100 发表于 2015-10-27 11:28

什么样的差异？

Shell_HAT 发表于 2015-10-30 16:29

回复 3# ipigzhu


    试验步骤和试验结果发出来，我也试试。

ipigzhu 发表于 2015-10-30 22:23

回复 4# love100



设置sql_log_bin=off 应该不记录sql，对吧，怎么还会记录？ ？？ 就这么简单问题！！
   

michaelsohu 发表于 2015-11-02 14:08

mysql> help sql_log_bin;
Name: 'SET SQL_LOG_BIN'
Description:
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 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.

*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.

In MySQL 5.6, it is not possible to set @@session.sql_log_bin within a
transaction or subquery. (Bug #53437)



首先是你要看是session级别还是global级别，同时看是不是同一个session
页: [1]
查看完整版本: sql_log_bin 的小问题