14.17.1 INFORMATION_SCHEMA Tables about InnoDB Transactions and Locking

14.17.1.1 Usage Examples for InnoDB Transaction and Locking Tables
14.17.1.2 INNODB_LOCKS and INNODB_LOCK_WAITS Data
14.17.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.