14.14.2 Information Schema Tables about Transactions

14.14.2.1 Using the Transaction Information Schema Tables

Three InnoDB-related Information Schema tables make it easy to monitor transactions and diagnose possible locking problems. The three tables are INNODB_TRX, INNODB_LOCKS, and INNODB_LOCK_WAITS.