I always thought mySQL INSERT statements were only prone to timeouts if you are using auto increment primary keys.
So I set the auto inc lock mode to interleaved to allow multiple concurrent inserts. innodb_autoinc_lock_mode = 2 (interleaved)
Any ideas or strategies that you can suggest to troubleshoot the cause and resolution of the ER_LOCK_WAIT_TIMEOUT would be greatly appreciated.