lua mysql 死锁_使用 mysqladmin debug 查看死锁信息

使用 mysqladmin debug 查看死锁信息

mysqladmin -S /mysql/data/mysql.sock debug

然后在error日志中，会看到：

11 lock struct(s), heap size 1136, 3 row lock(s)

MySQL thread id 118, OS thread handle 139642778605312, query id 8319501 10.244.112.57 selffabu updating

UPDATE T_QUICK_AUTHENTICATE_2

SET BANK_AUTH_ID = '375979145974259712'

WHERE ACCOUNT_NO = '0000000001118278650'

AND RCS_CODE = 'SNB_DEBIT_QUICKPAYMENT_SNB'

AND E_ACCOUNT_NO = '73A95146EFEC060C00BE87C9A0F8475A04F2587F77F8765A15FACDF017516B26'

AND STATUS = '1'

2018-04-17T14:20:43.609234+08:00 118 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):

RECORD LOCKS space id 531 page no 12 n bits 112 index PRIMARY of table `eppsmfcspst3`.`t_quick_authenticate_2` trx id 3346118 lock_mode X locks rec but not gap

2018-04-17T14:20: