Mysql解决The total number of locks exceeds the lock table size错误
来源:互联网 发布:java调用kettle 编辑:程序博客网 时间:2024/05/16 15:37
InnoDB表执行大批量数据的更新,插入,删除操作时会出现这个问题,需要调整InnoDB全局的innodb_buffer_pool_size的值来解决这个问题,并且重启mysql服务。
windows cmd:
mysql -u root -p
密码:root
进入mysql命令
show variables like "%_buffer%";(不要忘记带;号,没有;号表示一条语句没有结束)
默认的innodb_buffer_pool_size=8M
显示的格式是 1M*1024*1024,设置的时候也要这样设置,例如
修改 innodb_buffer_pool_size的值为3G:
SET GLOBAL innodb_buffer_pool_size=67108864;(3*1024*1024*1024,不要忘记;号)
0 0
- Mysql解决The total number of locks exceeds the lock table size错误
- Mysql解决The total number of locks exceeds the lock table size错误
- MySQL解决[Err] 1206 - The total number of locks exceeds the lock table size问题
- The total number of locks exceeds the lock table size错误(已纠正)
- The total number of locks exceeds the lock table size错误
- mysql Error:The total number of locks exceeds the lock table size
- 异常:java.sql.SQLException: The total number of locks exceeds the lock table size
- ERROR 1206 (HY000): The total number of locks exceeds the lock table size
- mysql报错"ERROR 1206 (HY000): The total number of locks exceeds the lock table size"的解决方法
- mysql报错-ERROR 1206 (HY000)- The total number of locks exceeds the lock table size-的解决方法
- mysql报错"ERROR 1206 (HY000): The total number of locks exceeds the lock table size"的解决方法
- 解决:Mysql exceeds the lock table size 不指定
- The size of the object heap + VM data exceeds the maximum representable size问题解决办法
- .\ethercat.axf: error: L6047U: The size of this image (33488 bytes) exceeds the maximum allowed for
- error: L6050U: The code size of this image exceeds the maximum allowed for this versio
- The specified size exceeds the maximum representable size.
- Error: The number of filter groups does not divide the total number of filters.
- [MySQL 错误]ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not
- iOS关于枚举的使用
- BZOJ 1131: [POI2008]Sta 树形DP
- dumpbin的使用
- 40个Java多线程问题总结
- 网站的分布式架构
- Mysql解决The total number of locks exceeds the lock table size错误
- Win7 pySpark安装
- AtCoder Grant Contest 10 F - Tree Game 博弈 dfs
- Scala函数字面量
- 创建带表头结点的单向链表,并实现各种功能
- 知识点总结之学习方式
- Gossip算法
- loadrunner 之 Web services 脚本例子
- QT——label