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

The InnoDB tables related to the InnoDB storage engine help you to monitor ongoing InnoDB activity, to detect inefficiencies before they turn into issues, or to troubleshoot performance and capacity issues that do occur. 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. The monitoring information deals with: