Change mysql storage engine from Innodb to MyIsam: Max locks exceeded error
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