MySQL 5.7 Release Notes
The following table summarizes
INFORMATION_SCHEMA InnoDB tables. For greater
detail, see the individual table descriptions.
Table 24.3 INFORMATION_SCHEMA InnoDB Tables
| Table Name | Description | Deprecated |
|---|---|---|
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_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_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_LOCK_WAITS |
InnoDB transaction lock-wait information | 5.7.14 |
INNODB_LOCKS |
InnoDB transaction lock information | 5.7.14 |
INNODB_METRICS |
InnoDB performance information | |
INNODB_SYS_COLUMNS |
Columns in each InnoDB table | |
INNODB_SYS_DATAFILES |
Data file path information for InnoDB file-per-table and general tablespaces | |
INNODB_SYS_FIELDS |
Key columns of InnoDB indexes | |
INNODB_SYS_FOREIGN |
InnoDB foreign-key metadata | |
INNODB_SYS_FOREIGN_COLS |
InnoDB foreign-key column status information | |
INNODB_SYS_INDEXES |
InnoDB index metadata | |
INNODB_SYS_TABLES |
InnoDB table metadata | |
INNODB_SYS_TABLESPACES |
InnoDB file-per-table, general, and undo tablespace metadata | |
INNODB_SYS_TABLESTATS |
InnoDB table low-level status information | |
INNODB_SYS_VIRTUAL |
InnoDB virtual generated column metadata | |
INNODB_TEMP_TABLE_INFO |
Information about active user-created InnoDB temporary tables | |
INNODB_TRX |
Active InnoDB transaction information |