FAQ Home > Common Errors and Issues

I am receiving the following error in my logs: The total number of locks exceeds the lock table size on query. How can I fix this?
Article ID: #000142

This is due to the size limit of the memory buffer InnoDB uses to cache data and indexes of its tables. The larger you set this value, the less disk I/O is needed to access data in tables. On a dedicated database server, you may set this to up to 80% of the machine physical memory size. However, do not set it too large because competition for physical memory might cause paging in the operating system.

To edit this setting, you will need to increase the inno_buffer_pool_size variable in /etc/my.cnf. In most cases, the default size is 8M. Setting this to 64M or higher will resolve this issue:

[mysqld]
set-variable=innodb_buffer_pool_size=64M

Once the above line has been edited, be sure to restart MySQL for changes to take effect.

[ Search FAQ | FAQ Home ]