mysql线程异常中断事务_清理MySQL死锁事务线程

方式一

查看事务ID：mysql> show engine innodb status;

从状态日志TRANSACTIONS信息中找出事务id：------------

TRANSACTIONS

------------

Trx id counter 383404

Purge done for trx's n:o < 383334 undo n:o < 0 state: running but idle

History list length 35

LIST OF TRANSACTIONS FOR EACH SESSION:

---TRANSACTION 422076598101416, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 422076598102288, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 422076598099672, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 422076598094440, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 422076598104904, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 422076598105776, not start