14.14.1 INFORMATION_SCHEMA Tables about InnoDB Transactions and Locking

14.14.1.1 Usage Examples for InnoDB Transaction and Locking Tables
14.14.1.2 INNODB_LOCKS and INNODB_LOCK_WAITS Data
14.14.1.3 Data Persistence and Consistency for InnoDB Transaction and Locking 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.