Development
Diagnosing MySQL ERROR 1205 Lock wait timeout: Distinguishing Lock Waits from Deadlocks
How to tell MySQL ERROR 1205 (lock wait timeout) from 1213 (deadlock) by SQLSTATE, plus copy-paste SQL to find blocking transactions in under five minutes using performance_schema.data_locks, INNODB_TRX, and SHOW ENGINE INNODB STATUS.