查看mysql 死锁的sql

SHOW ENGINE INNODB STATUS;

------------------------
LATEST DETECTED DEADLOCK
------------------------
2023-04-01 12:34:56 0x7f8d9a0c1700
*** (1) TRANSACTION:
TRANSACTION 12345678, ACTIVE 0.5 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 376 bytes, 1 row lock(s)
MySQL thread id 123, OS thread handle 0x7f8d9a0c1700, query id 1234 localhost root updating
UPDATE table_name SET column = 'value' WHERE id = 1
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 123 page no 4 n bits 72 index `index_name` of table `database_name`.`table_name` trx id 12345678 lock_mode X waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 3; compact format; info bits 0
...
*** (2) TRANSACTION:
TRANSACTION 12345679, ACTIVE 0.5 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376 bytes, 1 row lock(s)
MySQL thread id 124, OS thread handle 0x7f8d9a0c1701, query id 1235 localhost root updating
UPDATE table_name SET column = 'value' WHERE id = 2
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 123 page no 4 n bits 72 index `index_name` of table `database_name`.`table_name` trx id 12345679 lock_mode X locks rec but not gap
Record lock, heap no 1 PHYSICAL RECORD: n_fields 3; compact format; info bits 0
...
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 123 page no 4 n bits 72 index `index_name` of table `database_name`.`table_name` trx id 12345679 lock_mode X waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 3; compact format; info bits 0
...