Information Schema InnoDB Tables
These system tables provide detailed metadata about InnoDB tables, including their structure, storage, and other crucial properties for analysis.
Information Schema INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET TablesInformation Schema INNODB_BUFFER_PAGE TableInformation Schema INNODB_BUFFER_PAGE_LRU TableInformation Schema INNODB_BUFFER_POOL_PAGES TableInformation Schema INNODB_BUFFER_POOL_PAGES_BLOB TableInformation Schema INNODB_BUFFER_POOL_PAGES_INDEX TableInformation Schema INNODB_BUFFER_POOL_STATS TableInformation Schema INNODB_CHANGED_PAGES TableInformation Schema INNODB_CMP and INNODB_CMP_RESET TablesInformation Schema INNODB_CMPMEM and INNODB_CMPMEM_RESET TablesInformation Schema INNODB_FT_BEING_DELETED TableInformation Schema INNODB_FT_CONFIG TableInformation Schema INNODB_FT_DEFAULT_STOPWORD TableInformation Schema INNODB_FT_DELETED TableInformation Schema INNODB_FT_INDEX_CACHE TableInformation Schema INNODB_FT_INDEX_TABLE TableInformation Schema INNODB_LOCK_WAITS TableInformation Schema INNODB_LOCKS TableInformation Schema INNODB_METRICS TableInformation Schema INNODB_MUTEXES TableInformation Schema INNODB_SYS_COLUMNS TableInformation Schema INNODB_SYS_DATAFILES TableInformation Schema INNODB_SYS_FIELDS TableInformation Schema INNODB_SYS_FOREIGN TableInformation Schema INNODB_SYS_FOREIGN_COLS TableInformation Schema INNODB_SYS_INDEXES TableInformation Schema INNODB_SYS_SEMAPHORE_WAITS TableInformation Schema INNODB_SYS_TABLES TableInformation Schema INNODB_SYS_TABLESPACES TableInformation Schema INNODB_SYS_TABLESTATS TableInformation Schema INNODB_SYS_VIRTUAL TableInformation Schema INNODB_TABLESPACES_ENCRYPTION TableInformation Schema INNODB_TABLESPACES_SCRUBBING TableInformation Schema INNODB_TRX TableInformation Schema TEMP_TABLES_INFO TableInformation Schema INNODB_UNDO_LOGS Table
PreviousInformation Schema WSREP_THD_STATE_HISTORYNextInformation Schema INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
Last updated
Was this helpful?