Bug #26984 | ERROR 1206 (HY000): The total number of locks exceeds the lock table size | ||
---|---|---|---|
Submitted: | 9 Mar 2007 1:34 | Modified: | 13 May 2010 16:04 |
Reporter: | Roland Bouman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S4 (Feature request) |
Version: | 5.1.16 | OS: | Linux (linux) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | innodb, lock table |
[9 Mar 2007 1:34]
Roland Bouman
[9 Mar 2007 8:52]
Valeriy Kravchuk
Thank you for a problem report. I agree with your suggested fix, so this looks like a reasonable feature request for InnoDB team. If this feature can not be implemented any time soon, we need to document this problem explicitely, with some way to calculate how much memory in the buffer pool will be used for N locks.
[28 Mar 2007 12:26]
Heikki Tuuri
Hi! InnoDB could let the lock table overflow from the buffer pool to the OS memory allocation. Though, if you set innodb_buffer_pool_size to a reasonable value, you will probably never encounter this error. Regards, Heikki
[28 Mar 2007 13:05]
Roland Bouman
Thanks Heikki! How can I compute these values? I could not find any documentation regarding this. tia roland