Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have about 5 million records in a table which uses Innodb as storage engine. I have about 6000 users who use (do transactions) the same table. It sometimes becomes very slow or hangs. I decided to manually change to MyIsam. When I try to copy to another table and change the storage engine in phpmyadmin, it gives me Max Locks Exceeded Error. What should I do?

share|improve this question
IT's not quite clear whether you try to change the engine of the original table or that of the copy. However, I think you should first disconnect all the other connections (and don't let users reconnect until you finish). – dezso Nov 9 '12 at 12:07

The solution is simply to edit my.cnf, and add or edit the following line:

innodb_buffer_pool_size = 16M

To make it work, I set the size in bytes, so if I wanted 256 megabytes for my buffer pool, I would write 268435456. It would look like like this thus:

innodb_buffer_pool_size = 268435456
share|improve this answer
Thanks for this Obama—your edit is great. – Jack Douglas Nov 11 '12 at 7:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.