...
Also it is recommended to enable the mysql config innodb_file_per_table so that each Table is stored in an own file. This is very useful if you plan to import many huge projects.
You find Instructions for that in the MySQL documentation and in the cpanel forum.
Increase innodb_buffer_pool_size
Since some tables contain a lot of data, the innodb_buffer_pool_size should be increased to 64MB. Background are multiple issues. One is described below with the import of huge files.
Another issue could be migration scripts which affects tables containing a lot of data, like LEK_segment_data. Migration scripts working with that table can run into the following or similar error:
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size' in /webs/in cludes/ZendFramework-1.12.9-minimal/library/Zend/Db/Statement/Pdo.php:228
Solution is here:
- edit /etc/my.cnf
- add the line
innodb_buffer_pool_size=64MB - Restart the MySQL server
See also: https://stackoverflow.com/questions/6901108/the-total-number-of-locks-exceeds-the-lock-table-size
MySQL gone away errors on import
...