MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
The following table summarizes
INFORMATION_SCHEMA InnoDB tables. For greater
detail, see the individual table descriptions.
Table 28.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 | |
INNODB_FT_CONFIG |
Metadata for InnoDB table FULLTEXT index and associated processing | |
INNODB_FT_DEFAULT_STOPWORD |
Default list of stopwords for InnoDB FULLTEXT indexes | |
INNODB_FT_DELETED |
Rows deleted from InnoDB table FULLTEXT index | |
INNODB_FT_INDEX_CACHE |
Token information for newly inserted rows in InnoDB FULLTEXT index | |
INNODB_FT_INDEX_TABLE |
Inverted index information for processing text searches against InnoDB table FULLTEXT index | |
INNODB_INDEXES |
InnoDB index metadata | |
INNODB_METRICS |
InnoDB performance information | |
INNODB_SESSION_TEMP_TABLESPACES |
Session temporary-tablespace metadata | 8.0.13 |
INNODB_TABLES |
InnoDB table metadata | |
INNODB_TABLESPACES |
InnoDB file-per-table, general, and undo tablespace metadata | |
INNODB_TABLESPACES_BRIEF |
Brief file-per-table, general, undo, and system tablespace metadata | |
INNODB_TABLESTATS |
InnoDB table low-level status information | |
INNODB_TEMP_TABLE_INFO |
Information about active user-created InnoDB temporary tables | |
INNODB_TRX |
Active InnoDB transaction information | |
INNODB_VIRTUAL |
InnoDB virtual generated column metadata |