I used orthomcl to classify proteome from several non-model species to into orthogroups. After all-to-all blast, I got a ~6GB blast tabular file and loaded it to mysql database as instruction. However, when I tried to run orthomclPair step, it kept reporting 'DBD::mysql::st execute failed: The total number of locks exceeds the lock table size'.
I changed default innodb_buffer_pool_size to 2GB and restarted mysql (https://major.io/2010/02/16/mysql-the-total-number-of-locks-exceeds-the-lock-table-size-2/), but it did not work and still reported same error. Did anyone have same problem when using orthomcl? How did you solve it?