在从mysql一个表导入另一个表大量数据的时候提示
The total number of locks exceeds the lock table size
出现这个出错可以修改/etc/my.cnf
修改
innodb_buffer_pool_size数据 默认为16M
现在改成64M
重启mysql服务
Mysql解决The total number of locks exceeds the lock table size错误
Posted by
By
No Comments
By
No Comments
Post navigation
Previous Post
CentOS7 lnmp平台简单部署Next Post
mac zabbix 客户端安装 