Mysql:Changes in MySQL 5.6.22 (2014-12-01, General Availability):【sql-log-bin】
2023-09-27 14:24:27 时间
Changes in MySQL 5.6.22 (2014-12-01, General Availability)
-
Replication: The global scope for the
sql_log_bin
system variable has been deprecated, and this variable can now be set with session scope only. The statementSET GLOBAL SQL_LOG_BIN
now produces an error. It remains possible to read the global value ofsql_log_bin
, but doing so produces a warning. You should act now to remove from your applications any dependencies on reading this value; the global scopesql_log_bin
is removed in MySQL 8.0. (Bug #67433, Bug #15868071)
-
Replication: The variable
binlogging_impossible_mode
now has an alias namedbinlog_error_action
, which is the preferred name.binlogging_impossible_mode
is now deprecated. (Bug #19507567)
相关文章
- strace追踪mysql执行语句
- MySQL的redo log重做日志都懂了吗?
- MySQL事务隔离与undo log、MVCC的亲密关系
- mysql general log日志
- mysql Bin-log二进制日志三种模式的日志格式介绍及区别
- 关于mysql备份说明
- MYSQL企业常用架构与调优经验分享
- 不可不知的 MySQL 升级利器及 5.7 升级到 8.0 的注意事项
- MySQL Sniffer
- MySQL 慢查询日志(Slow Query Log)
- Entity Framework with MySQL 学习笔记一(insert,update,delete)
- Mysql:mysqldumpslow 技巧:如何不截断 slow.log 文件,直接指定开始starttime时间、stoptime结束时间,进行分析?
- Mysql:DoubleWrite Buffer:类似于redo-log:提高data写性能,间接提高data写安全性!
- [MySQL]innodb_flush_log_at_trx_commit与sync_binlog
- MySQL 慢查询日志(Slow Query Log)
- centos7安装jdk+tomcat+nginx+mysql
- mysql查询锁表语句
- Linux下查看MySQL的安装路径
- 2022-11-23 mysql列存储引擎-ESCAPE处理错误-问题记录
- MySQL必知必会:简介undo log、truncate、以及undo log如何帮你回滚事务(一)
- mysql之参数binlog_rows_query_log_events
- mysql命令:set sql_log_bin=on/off
- MySQL STR_TO_DATE函数
- mysql 5.7*8.0/percona server/mariadb 10.x安装与服务器参数优化
- 追查连接mysql的客户端
- MySQL参数: innodb_flush_log_at_trx_commit和sync_binlog
- django写网站遇到的时区问题及mysql汉字存储问题
- MySQL 重要参数 innodb_flush_log_at_trx_commit 和 sync_binlog
- 【mysql我能讲两小时033】什么是undo log 有什么作用?