Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA InnoDB Tables  /  INFORMATION_SCHEMA InnoDB Table Reference

24.4.1 INFORMATION_SCHEMA InnoDB Table Reference

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

Table 24.3 INFORMATION_SCHEMA InnoDB Tables

Table NameDescriptionDeprecated
INNODB_BUFFER_PAGEPages in InnoDB buffer pool
INNODB_BUFFER_PAGE_LRULRU ordering of pages in InnoDB buffer pool
INNODB_BUFFER_POOL_STATSInnoDB buffer pool statistics
INNODB_CMPStatus for operations related to compressed InnoDB tables
INNODB_CMP_PER_INDEXStatus for operations related to compressed InnoDB tables and indexes
INNODB_CMP_PER_INDEX_RESETStatus for operations related to compressed InnoDB tables and indexes
INNODB_CMP_RESETStatus for operations related to compressed InnoDB tables
INNODB_CMPMEMStatus for compressed pages within InnoDB buffer pool
INNODB_CMPMEM_RESETStatus for compressed pages within InnoDB buffer pool
INNODB_FT_BEING_DELETEDSnapshot of INNODB_FT_DELETED table
INNODB_FT_CONFIGMetadata for InnoDB table FULLTEXT index and associated processing
INNODB_FT_DEFAULT_STOPWORDDefault list of stopwords for InnoDB FULLTEXT indexes
INNODB_FT_DELETEDRows deleted from InnoDB table FULLTEXT index
INNODB_FT_INDEX_CACHEToken information for newly inserted rows in InnoDB FULLTEXT index
INNODB_FT_INDEX_TABLEInverted index information for processing text searches against InnoDB table FULLTEXT index
INNODB_LOCK_WAITSInnoDB transaction lock-wait information5.7.14
INNODB_LOCKSInnoDB transaction lock information5.7.14
INNODB_METRICSInnoDB performance information
INNODB_SYS_COLUMNSColumns in each InnoDB table
INNODB_SYS_DATAFILESData file path information for InnoDB file-per-table and general tablespaces
INNODB_SYS_FIELDSKey columns of InnoDB indexes
INNODB_SYS_FOREIGNInnoDB foreign-key metadata
INNODB_SYS_FOREIGN_COLSInnoDB foreign-key column status information
INNODB_SYS_INDEXESInnoDB index metadata
INNODB_SYS_TABLESInnoDB table metadata
INNODB_SYS_TABLESPACESInnoDB file-per-table, general, and undo tablespace metadata
INNODB_SYS_TABLESTATSInnoDB table low-level status information
INNODB_SYS_VIRTUALInnoDB virtual generated column metadata
INNODB_TEMP_TABLE_INFOInformation about active user-created InnoDB temporary tables
INNODB_TRXActive InnoDB transaction information