MySQL 8.3 Release Notes
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 |
|---|---|
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 |
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 |