14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→ERROR 1206: The total number of locks exceeds the lock table size
| Line 176: | Line 176: | ||
Message: Error Code: 1206. The total number of locks exceeds the lock table size | Message: Error Code: 1206. The total number of locks exceeds the lock table size | ||
Solution: Increase {{kbd | key = innodb_buffer_pool_size}} e.g. {{kbd | key =<nowiki>SET GLOBAL innodb_buffer_pool_size=402653184;</nowiki>}} (402653184 bytes ~ 400MB. Default value is 8MB.) | Solution: | ||
* Increase {{kbd | key = innodb_buffer_pool_size}} e.g. {{kbd | key =<nowiki>SET GLOBAL innodb_buffer_pool_size=402653184;</nowiki>}} (402653184 bytes ~ 400MB. Default value is 8MB.) | |||
* Reduce the size of query data | |||
Further reading: | Further reading: | ||