[MySQL复制异常]'Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.'
MySQL复制错误]Last_Errno: 1666 Last_Error: Error executing row event: 'Cannot execute statement: imposs
收到email报警, Last_Error: Error executing row event: 'Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.'
mysql> show slave status;
看到貌似是statement模式不足以应付应用,换成mixed试试看吧:
mysql> STOP SLAVE;
Query OK, 0 rows affected (0.02 sec)
mysql> SET GLOBAL binlog_format=MIXED;
Query OK, 0 rows affected (0.00 sec)
mysql> START SLAVE;
Query OK, 0 rows affected (0.00 sec)
但是这样只会一次性
为了永久生效,需要修改my.ini
# Remove leading
# to turn on a very important data integrity option: logging
# changes to the binary log between backups.
log_bin = E:/mysql56/log_bin/log_bin.log
#relay_log = E:/mysql56/log_bin/relay_log.log
#read_only = 1
# binary logging format - mixed recommended
binlog_format=mixed
相关文章
- Mysql net start mysql启动,提示发生系统错误 5 拒绝訪问 解决之道
- MySQL 当记录不存在时插入(insert if not exists)
- MySQL 数据类型
- idea提示Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is
- MySQL使用初步—mysql数据库的基本命令
- 【MySQL进阶-06】深入理解mysql的内核查询成本计算
- 【MySQL进阶-03】深入理解mysql的索引分类,覆盖索引,覆盖索引失效,回表,MRR
- 【MySQL进阶-10】mysql语句的执行流程以及集群的高可用
- mysql基础
- 项目访问mysql时报: Failed to obtain JDBC Connection...:Host ‘X‘is not allowed to connect to this MySQL ser
- Java连接MYSQL【转载】
- 基于Java(SpringBoot)+Vue+MySQL 实现(Web)的网络课程平台【100010329】
- 基于Java+MySQL实现(WinForm)客户管理系统【100010236】
- MySQL运维之---mysqldump备份、select...into outfile、mysql -e 等工具的使用
- 基于 mysql 异步驱动的非阻塞 Mybatis【待验证】
- mysql—MySQL数据库中10位时间戳转换为标准时间后,如何对标准时间进行加减X天处理
- 【转】Mysql学习---MySQL悲观锁中的排它锁
- 【MySQL】mysql更换root密码,全网唯一有用!
- mysql主从同步某个表不一致,单表恢复
- mysql常用压测工具
- Mac - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- centos 7 mysql启动失败--学会看错误日志
- Mysql启动时提示:Another MySQL daemon already running with the same unix socket.