mysql Error:The total number of locks exceeds the lock table size
来源:互联网 发布:python cgi环境搭建 编辑:程序博客网 时间:2024/05/17 06:11
今天在创建表的时候报错如下:
- ERROR 1206 (HY000): The total number of locks exceeds the lock table size
解决办法: innodb_buffer_pool_size=64M (默认是8M,这个可以根据数据库大小具体修改。)
service mysqld restart 修改后重启即可。
原因如下:
- If you're running an operation on a large number of rows within a table that uses the InnoDB storage engine, you might see this error:
- ERROR 1206 (HY000): The total number of locks exceeds the lock table size
- MySQL is trying to tell you that it doesn't have enough room to store all of the row locks that it would need to execute your query. The only way to fix it for sure is to adjust innodb_buffer_pool_size and restart MySQL. By default, this is set to only 8MB, which is too small for anyone who is using InnoDB to do anything.
- If you need a temporary workaround, reduce the amount of rows you're manipulating in one query. For example, if you need to delete a million rows from a table, try to delete the records in chunks of 50,000 or 100,000 rows. If you're inserting many rows, try to insert portions of the data at a single time.
原来是InnoDB表执行大批量数据的更新,插入,删除操作时会出现这个问题,需要调整InnoDB全局的innodb_buffer_pool_size的值来解决这个问题,并且重启mysql服务。
查看当前数据库存储引擎,在创建时使用 ENGINE=InnoDB类型。
默认的innodb_buffer_pool_size=8M
0 0
- mysql Error: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解决[Err] 1206 - The total number of locks exceeds the lock table size问题
- Mysql解决The total number of locks exceeds the lock table size错误
- Mysql解决The total number of locks exceeds the lock table size错误
- 异常:java.sql.SQLException: 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 exceeds the lock table 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
- Error: The number of filter groups does not divide the total number of filters.
- ..\OBJ\LCD.axf: error: L6047U: The size of this image (34984 bytes) exceeds,KEIL5破解方法
- error: L6047U: The size of this image (32868 bytes) exceeds the maximum allowed for this version of
- Dealing with the “Bitmap Size Exceeds VM Budget” error
- Android 滑动效果基础篇(四)—— Gallery + GridView
- LINUX总结第13篇:LINUX下动态库及版本号控制
- unix 环境高级编程 信号函数杂记一
- TableView异步加载
- android学习记录
- mysql Error:The total number of locks exceeds the lock table size
- maven入门
- linux启动过程详解
- Android 滑动效果进阶篇(五)—— 3D旋转
- 解决html5 / cocos2d-html5乱码的问题
- BTree,B-Tree,B+Tree,B*Tree的数据结构
- 驱动开发之 应用程序通过设备接口打开设备
- linux find 如何排除某些檔案 和 限制尋找層數
- http请求(get 和 post 请求)与响应