MySQL报错提示“The total number of locks exceeds the lock table size”

MySQL执行语句报错,提示“The total number of locks exceeds the lock table size”解决办法InnoDB表执行大批量数据的更新,插入,删除操作时会出现这个问题,需要调整InnoDB全局的innodb_buffer_pool_size的值来解决这个问题,并且重启MySQL服务执行MySQL语句show variables like &quo...
阅读全文