今天在去重的時候報了
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了。
