The total number of locks exceeds the lock table size

[Administrator]

You receive this error when you build a database, view reports OR when running operation on a large number of rows within a table that uses the InnoDB storage engine.

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 innodb_buffer_pool_size option in my.cnf, to set innodb_buffer_pool_size to a number higher than the default.

Simply, edit the file /etc/my.cnf and find for innodb_buffer_pool_size. Set the value to 1024M OR 2048M. It should look like below.

innodb_buffer_pool_size=2048M

Restart MySQL service & try running the query.