FAQ: Error with MySQL: "The total number of locks exceeds the lock table size"
When I try to build a database, or view reports, I get an error, "The total number of locks exceeds the lock table size". How can I fix this?
innodb_buffer_pool_size in my.cnf (my.ini), to 256M.
This occurs when MySQL runs out of locks, which for an InnoDB database occurs when the buffer pool
is full. You can fix this by increasing the size of the buffer pool, by editng the
option in my.cnf (my.ini), to set
innodb_buffer_pool_size to a number higher than the default
(which is typically 8M); for instance:
innodb_buffer_pool_size = 256M
Then, restart MySQL, and try the Sawmill operation again.