14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→ERROR 1206: The total number of locks exceeds the lock table size
(ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option) |
|||
| Line 247: | Line 247: | ||
== ERROR 1206: The total number of locks exceeds the lock table size == | == 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 | Message: Error Code: 1206. The total number of locks exceeds the lock table size | ||
Understand the 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: | Solution: | ||