今天在去重的时候报了
The total number of locks exceeds the lock table size’的错
在网上查了一下是因为缓存内存不够， 解决方法如下： 找到mysql的文件目录 如下图：
mysql The total number of locks exceeds the lock table size The total number of locks exceeds the lock table size’的错 打开cmd
mysql The total number of locks exceeds the lock table size The total number of locks exceeds the lock table size’的错 进入到这个文件中
mysql The total number of locks exceeds the lock table size The total number of locks exceeds the lock table size’的错 之后执行mysql语句（此处借鉴了百度经验）
mysql The total number of locks exceeds the lock table size The total number of locks exceeds the lock table size’的错 输入密码后就是下图界面
mysql The total number of locks exceeds the lock table size The total number of locks exceeds the lock table size’的错 接下来查看池的大小
mysql The total number of locks exceeds the lock table size The total number of locks exceeds the lock table size’的错 因为我这已经修改过了所以是256M之前默认的应该是8M
以后修改语句是 SET GLOBAL innodb_buffer_pool_size= 268435456 ;
OK了。
