14,953
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Resource and Environmental Errors
| Line 505: | Line 505: | ||
solution: Using the naive mysqldump command to generate the backup file. And import the backup by using mysql command. | solution: Using the naive mysqldump command to generate the backup file. And import the backup by using mysql command. | ||
=== ERROR 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 | |||
Current condition<ref>[https://dev.mysql.com/doc/refman/8.0/en/show-variables.html MySQL :: MySQL 8.0 Reference Manual :: 13.7.6.39 SHOW VARIABLES Syntax]</ref>: | |||
* Keywin {{kbd | key = <nowiki>SHOW VARIABLES LIKE 'innodb_buffer_pool_size';</nowiki>}}. If it returns {{kbd | key=8388608}}, it means {{kbd | key=8388608}} bytes ≅ 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: | |||
* [http://stackoverflow.com/questions/5696857/how-to-change-value-for-innodb-buffer-pool-size-in-mysql-on-mac-os innodb - How to change value for innodb_buffer_pool_size in MySQL on Mac OS? - Stack Overflow]. | |||
* [https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html MySQL :: MySQL 5.7 Reference Manual :: 14.6.3.2 Configuring InnoDB Buffer Pool Size] | |||
== Miscellaneous Tool-Specific Errors == | == Miscellaneous Tool-Specific Errors == | ||