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 Tables

• Information Schema INNODB_BUFFER_PAGE Table

• Information Schema INNODB_BUFFER_PAGE_LRU Table

• Information Schema INNODB_BUFFER_POOL_PAGES Table

• Information Schema INNODB_BUFFER_POOL_PAGES_BLOB Table

• Information Schema INNODB_BUFFER_POOL_PAGES_INDEX Table

• Information Schema INNODB_BUFFER_POOL_STATS Table

• Information Schema INNODB_CHANGED_PAGES Table

• Information Schema INNODB_CMP and INNODB_CMP_RESET Tables

• Information Schema INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables

• Information Schema INNODB_FT_BEING_DELETED Table

• Information Schema INNODB_FT_CONFIG Table

• Information Schema INNODB_FT_DEFAULT_STOPWORD Table

• Information Schema INNODB_FT_DELETED Table

• Information Schema INNODB_FT_INDEX_CACHE Table

• Information Schema INNODB_FT_INDEX_TABLE Table

• Information Schema INNODB_LOCK_WAITS Table

• Information Schema INNODB_LOCKS Table

• Information Schema INNODB_METRICS Table

• Information Schema INNODB_MUTEXES Table

• Information Schema INNODB_SYS_COLUMNS Table

• Information Schema INNODB_SYS_DATAFILES Table

• Information Schema INNODB_SYS_FIELDS Table

• Information Schema INNODB_SYS_FOREIGN Table

• Information Schema INNODB_SYS_FOREIGN_COLS Table

• Information Schema INNODB_SYS_INDEXES Table

• Information Schema INNODB_SYS_SEMAPHORE_WAITS Table

• Information Schema INNODB_SYS_TABLES Table

• Information Schema INNODB_SYS_TABLESPACES Table

• Information Schema INNODB_SYS_TABLESTATS Table

• Information Schema INNODB_SYS_VIRTUAL Table

• Information Schema INNODB_TABLESPACES_ENCRYPTION Table

• Information Schema INNODB_TABLESPACES_SCRUBBING Table

• Information Schema INNODB_TRX Table

• Information Schema TEMP_TABLES_INFO Table

• Information Schema INNODB_UNDO_LOGS Table

_{This page is licensed: CC BY-SA / Gnu FDL}