Quite frequently I see people confused what table locks reported by SHOW INNODB STATUS really mean. Check this out for example: —TRANSACTION 0 4872, ACTIVE 32 sec, process no 7142, OS thread id 1141287232 2 lock struct(s), heap size 368 MySQL thread id 8, query id 164 localhost root TABLE LOCK table `test/t1` trx id [...]