5.1 INFORMATION_SCHEMA InnoDB Table Reference

The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions.

Table 5.1 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