Mysql 批量更新操作的时候出错 “Multi-statement transaction required more than 'max_binlog_cache_size' bytes of s
来源:互联网 发布:淘宝同款排除工具 编辑:程序博客网 时间:2024/05/22 02:29
使用mysql批量更新的时候出现以下错误:
Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
可以看出这个是mysql的缓存不够,
解决方法如下:
进入 vi /etc/my.cnf
将max_binlog_cache_size调整相应大小即可。
0 0
- Mysql 批量更新操作的时候出错 “Multi-statement transaction required more than 'max_binlog_cache_size' bytes of s
- Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage
- statement transaction required more than 'max_binlog_cache_size' bytes of storage
- MySql [Err] 1197 - Multi-statement transaction required more than 'max_binlog_cache_size' bytes 解决方法
- update语句报错 statement transaction required more than 'max_binlog_cache_size' bytes of storage
- MySQL创建索引抛出“required more than 'innodb_online_alter_log_max_size' bytes of modification log”异常的解决方案
- springboot druid 数据库批量更新错误 multi-statement not allow
- springboot druid 数据库批量更新错误 multi-statement not allow
- Sort operation used more than the maximum 33554432 bytes of RAM
- mongo添加索引以及解决Sort operation used more than the maximum 33554432 bytes of RAM
- MYSQL存储过程出现Result consisted of more than one row 错误的解决方法
- Mysql报错:Result consisted of more than one row
- 遇到错误----Mongodb----导出数据报错 Sort operation used more than the maximum 33554432 bytes of RAM
- Result consisted of more than one row 错误的解决
- Result consisted of more than one row错误的修正
- 1153 - Got a packet bigger than 'max_allowed_packet' bytes With statement
- MyBatis(7)--spring boot集成MyBatis,集成Druid批量更新报错multi-statement not allow
- mysql数据库批量更新操作
- 多备份:带领站长冲上“云端”
- 下推栈的数组实现
- hdu 2159 FATE
- ucos-ii学习笔记——消息邮箱的原理及使用
- UVa10527 - Persistent Numbers(数论)
- Mysql 批量更新操作的时候出错 “Multi-statement transaction required more than 'max_binlog_cache_size' bytes of s
- 为什么Java byte 类型的…
- 短信远程开机
- sizeof用法总结(个人感觉非常好的…
- 逻辑运算符<<和>>的详细分析
- C符号之逻辑运算符、左移与右移、…
- 利用union判断系统的大小端
- 易错的优先级
- 在vm9中安装linux VMtools的注意