MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: The total number of locks exceeds the lock table size  (Read 3458 times)

0 Members and 1 Guest are viewing this topic.

Offline Administrator

  • Chinmay Dingore
  • Administrator
  • Full Member
  • *****
  • Posts: 135
  • Karma: +1/-0
    • View Profile
    • MilesWeb Internet Services Pvt Ltd
The total number of locks exceeds the lock table size
« on: April 30, 2015, 03:50:37 PM »
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.

Quote
innodb_buffer_pool_size=2048M

Restart MySQL service & try running the query.
MilesWeb.com - Your Hosting, Our Responsibility!
Unlimited Hosting Plans | Managed VPS with 20% Discount

MilesWeb Hosting Forum

The total number of locks exceeds the lock table size
« on: April 30, 2015, 03:50:37 PM »