Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


MySQL Information Schema  /  INFORMATION_SCHEMA InnoDB Tables  /  INFORMATION_SCHEMA InnoDB Table Reference

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