problem
With migration scripts affecting large tables like LEK_segment_data it can happen that the script fails with:
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
- edit /etc/my.cnf
- add the line
innodb_buffer_pool_size=64MB - Restart the MySQL server
See: https://stackoverflow.com/questions/6901108/the-total-number-of-locks-exceeds-the-lock-table-size