INFORMATION_SCHEMA Table Reference Table Name Description Introduced Deprecated 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 KEY_COLUMN_USAGE Which key columns have constraints KEYWORDS MySQL keywords MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles 8.0.26 MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists 8.0.26 ndb_transid_mysql_connection_map NDB transaction information OPTIMIZER_TRACE Information produced by optimizer trace activity 4774