The total number of locks exceeds the lock table size，mysql update报错
mysql 报错 The of number Table update size
2023-09-11 14:21:08 时间
【1】mysql update报错 事情缘由
（1.1）前置信息
- mysql5.6 版本
- innodb_buffer_pool_size 只有 10M
- 被 update的表有 3kw+ 表数据库
- 被 update 表是 innodb，utf8 格式
The total number of locks exceeds the lock table size
【2】解决分析
（1）修改 innodb_buffer_pool_size （5.6不能在线改，坑啊）
（2）修改 tmp_table_size（试过，没什么用）
最终解决：
还是查出主键id，然后一个一个 update过去，所幸我需要更新的行之后 5000来行；
相关文章
- 安卓 android studio 报错 The specified Android SDK Build Tools version (27.0.3) is ignored, as it is below the minimum supported version (28.0.3) for Android Gradle
- Mysql远程连接数据库报错排查：pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '**.**.**.**' (timed out)")
- 磁盘爆满导致MySQL无法启动:Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space...
- MySQL server has gone away报错原因分析
- SQL SERVER 2005删除维护作业报错：The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id"
- 如何构建高性能MySQL索引
- mysql启动时报错：Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)--续
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)
- MySQL高可用性之Keepalived+Mysql（双主热备）
- CentOS下httpd下php 连接mysql 本机可以，外网报错Could not connect: Can't connect to MySQL server on '127.0.0.1' (13)2003 原因解析
- 【问题解决方案】MySQL安装后无法启动-net start mysql服务名无效
- MYSQL避免全表扫描__如何查看sql查询是否用到索引(mysql)
- 【收藏】windows下 Mysql 错误 Can‘t open and lock privilege tables: Table ‘mysql.user‘ doesn‘t exist
- AndroidStudio3.0 注解报错Annotation processors must be explicitly declared now. The following dependencies on the compile classpath are found to contain annotation processor.
- 【异常】MySQL Workbench 报错 Error changing account root@localhost : The MySQL server is running with
- mysql报错 1142 - SELECT command denied to user ‘dev‘@‘localhost‘ for table ‘user‘ (已解决)
- Mysql连接报错：1130-host ... is not allowed to connect to this MySql server如何处理
- MYSQL导入数据报错|MYSQL导入超大文件报错|MYSQL导入大数据库报错：2006 - MySQL server has gone away
- 编译webrtc报错：ERROR: The installation of the Chrome OS default fonts failed.
- Mysql报错`tablespace name can't find in DBA_FREE_SPACE`
- MySQL远程连接报错2003-cant connection to mysql server on ‘IP’（10061 unknown error）
- MySQL之自带四库之mysql库
- MySQL数据库篇之mysql的快速启动和停止
- SQL报错——check the manual that corresponds to your MySQL server version for the right syntax to use
- 【异常】MySQL提示MysqlDataTruncation: Data truncation: Data too long for column ‘name‘ at row 1
- 【高可用MySQL解决方案】centos7配置mysql主从复制
- MySQL 一文带你详解 mysql binlog