INFORMATION_SCHEMA InnoDB Tables 26.4 INFORMATION_SCHEMA InnoDB Tables 26.4.1 INFORMATION_SCHEMA InnoDB Table Reference This section provides table definitions for  INFORMATION_SCHEMA InnoDB  tables. For related information and examples, see Section 15.15, “InnoDB INFORMATION_SCHEMA Tables” . INFORMATION_SCHEMA InnoDB  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. The following table summarizes  INFORMATION_SCHEMA  InnoDB tables. For greater detail, see the individual table descriptions. Table 26.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Introduced INNODB_BUFFER_PAGE Pages in InnoDB buffer pool INNODB_BUFFER_PAGE_LRU LRU ordering of pages in InnoDB buffer pool INNODB_BUFFER_POOL_STATS InnoDB buffer pool statistics INNODB_CACHED_INDEXES Number of index pages cached per index in InnoDB buffer pool INNODB_CMP Status for operations related to compressed InnoDB tables INNODB_CMP_PER_INDEX Status for operations related to compressed InnoDB tables and indexes INNODB_CMP_PER_INDEX_RESET Status for operations related to compressed InnoDB tables and indexes INNODB_CMP_RESET Status for operations related to compressed InnoDB tables INNODB_CMPMEM Status for compressed pages within InnoDB buffer pool INNODB_CMPMEM_RESET Status for compressed pages within InnoDB buffer pool INNODB_COLUMNS Columns in each InnoDB table INNODB_DATAFILES Data file path information for InnoDB file-per-table and general tablespaces INNODB_FIELDS Key columns of InnoDB indexes INNODB_FOREIGN InnoDB foreign-key metadata INNODB_FOREIGN_COLS InnoDB foreign-key column status information INNODB_FT_BEING_DELETED Snapshot of INNODB_FT_DELETED table 4840