Troubleshoot MySQL transaction No commit causes lock waits lock wait timeout exceeded

Solution Ideas:

SELECT * FROM Information_schema.innodb_trx after a read-only transaction that has not been committed has been found,

Kill to the corresponding thread after OK.

Reprinted from: http://blog.sina.com.cn/s/blog_6bb63c9e0100s7cb.html

In Mysql5.5, the INFORMATION_SCHEMA Library has three additional tables on locks (memory engine);
Innodb_trx # # All the transactions currently running

Innodb_locks # # The currently appearing lock

Innodb_lock_waits # # Lock Wait Correspondence relationship

# # generates transactions, in Innodb_trx there is data;
Mysql> SELECT * from Information_schema.innodb_trx G;

If no lock waits are generated, there is no data in innodb_lock_waits and Innodb_locks

If the resulting waiting, query these three tables, find the corresponding thread, kill.

Troubleshoot MySQL transaction No commit causes lock waits lock wait timeout exceeded