14.17.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Tables

14.17.2.1 Usage Examples for InnoDB Transaction and Locking Tables
14.17.2.2 INNODB_LOCKS and INNODB_LOCK_WAITS Data
14.17.2.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.