21.28 INFORMATION_SCHEMA Tables for InnoDB

21.28.1 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
21.28.2 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
21.28.3 The INFORMATION_SCHEMA INNODB_TRX Table
21.28.4 The INFORMATION_SCHEMA INNODB_LOCKS Table
21.28.5 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
21.28.6 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
21.28.7 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
21.28.8 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table

This section provides table definitions for InnoDB INFORMATION_SCHEMA tables. For related information and examples, see Section 14.17, “InnoDB INFORMATION_SCHEMA Tables”.

InnoDB INFORMATION_SCHEMA tables can be used to monitor ongoing InnoDB activity, to detect inefficiencies before they turn into issues, or to troubleshoot performance and capacity issues. As your database becomes bigger and busier, running up against the limits of your hardware capacity, you monitor and tune these aspects to keep the database running smoothly.