Information Schema InnoDB Tables
List of Information Schema tables specifically related to InnoDB. Tables that are specific to XtraDB shares with InnoDB are listed in Information Schema XtraDB Tables.
-
Information Schema INNODB_BUFFER_PAGE Table
Buffer pool page information. -
Information Schema INNODB_BUFFER_PAGE_LRU Table
Buffer pool pages and their eviction order. -
Information Schema INNODB_BUFFER_POOL_PAGES Table
XtraDB buffer pool page information. -
Information Schema INNODB_BUFFER_POOL_PAGES_BLOB Table
XtraDB buffer pool blob pages. -
Information Schema INNODB_BUFFER_POOL_PAGES_INDEX Table
XtraDB buffer pool index pages. -
Information Schema INNODB_BUFFER_POOL_STATS Table
InnoDB buffer pool information. -
Information Schema INNODB_CHANGED_PAGES Table
Modified pages from the bitmap file data. -
Information Schema INNODB_CMP and INNODB_CMP_RESET Tables
XtraDB/InnoDB compression performances with different page sizes. -
Information Schema INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
Number of InnoDB compressed pages of different page sizes. -
Information Schema INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
XtraDB/InnoDB compression performances for different indexes and tables. -
Information Schema INNODB_FT_BEING_DELETED Table
Fulltext being deleted. -
Information Schema INNODB_FT_CONFIG Table
InnoDB fulltext metadata. -
Information Schema INNODB_FT_DEFAULT_STOPWORD Table
Default InnoDB stopwords. -
Information Schema INNODB_FT_DELETED Table
Deleted InnoDB fulltext rows. -
Information Schema INNODB_FT_INDEX_CACHE Table
Newly added fulltext row information. -
Information Schema INNODB_FT_INDEX_TABLE Table
InnoDB fulltext information. -
Information Schema INNODB_LOCK_WAITS Table
Blocked InnoDB transactions. -
Information Schema INNODB_LOCKS Table
InnoDB lock information. -
Information Schema INNODB_METRICS Table
InnoDB performance metrics. -
Information Schema INNODB_MUTEXES Table
Monitor mutex waits. -
Information Schema INNODB_SYS_COLUMNS Table
InnoDB column information. -
Information Schema INNODB_SYS_DATAFILES Table
InnoDB tablespace paths. -
Information Schema INNODB_SYS_FIELDS Table
Fields part of an InnoDB index. -
Information Schema INNODB_SYS_FOREIGN Table
InnoDB foreign key information. -
Information Schema INNODB_SYS_FOREIGN_COLS Table
Foreign key column information. -
Information Schema INNODB_SYS_INDEXES Table
InnoDB index information. -
Information Schema INNODB_SYS_SEMAPHORE_WAITS Table
Information about current semaphore waits. -
Information Schema INNODB_SYS_TABLES Table
InnoDB table information. -
Information Schema INNODB_SYS_TABLESPACES Table
InnoDB tablespace information. -
Information Schema INNODB_SYS_TABLESTATS Table
InnoDB status for high-level performance monitoring. -
Information Schema INNODB_SYS_VIRTUAL Table
Information about base columns of virtual columns. -
Information Schema INNODB_TABLESPACES_ENCRYPTION Table
Encryption metadata for InnoDB tablespaces. -
Information Schema INNODB_TABLESPACES_SCRUBBING Table
Data scrubbing information. -
Information Schema INNODB_TRX Table
Currently-executing InnoDB locks. -
Information Schema TEMP_TABLES_INFO Table
Information about active InnoDB temporary tables.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.