首页 > 代码库 > mysql报错Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage
mysql报错Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage
mysql报错Multi-statement transaction required more than ‘max_binlog_cache_size‘ bytes of storage
在执行create table xx as select xx的时候
或者在执行
tpcc-mysql的tpcc_load 的时候
都会遇到这个错误
1534, HY000, Writing one row to the row-based binary log failed
Retrying ...
1197, HY000, Multi-statement transaction required more than ‘max_binlog_cache_size‘ bytes of storage; increase this mysqld variable and try again
Retrying ...
因为使用的是腾讯云主机,1核1G内存,内存不足导致的binlog cache size不够不能写入binlog,导致语句无法执行
解决办法:
修改my.cnf,增大binlog_cache_size和max_binlog_cache_size参数的值
binlog_cache_size = 20M
max_binlog_cache_size = 100M
mysql报错Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。