How to find out / locate MySQL dead lock
. ;(run it as root)
| Warning | 1681 | 'INFORMATION_SCHEMA.INNODB_LOCKS' is deprecated and will be removed in a future release. |
For every blocked transaction,
INNODB_LOCKScontains one row that describes each lock the transaction has requested, and for which it is waiting.
INNODB_LOCKSalso contains one row for each lock that is blocking another transaction, whatever the state of the transaction that holds the lock (
'COMMITTING'). The lock that is blocking a transaction is always held in a mode (read vs. write, shared vs. exclusive) incompatible with the mode of requested lock.
Mode of the lock. One of
'AUTO_INC'for shared, exclusive, intention shared, intention exclusive row locks, shared and exclusive gap locks, intention shared and intention exclusive gap locks, and auto-increment table level lock, respectively.
InnoDB Lock Modes