W3cubDocs

/MariaDB

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.

Title	Description
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 XtraDB/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_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 INNODB_UNDO_LOGS Table	XtraDB undo log segments.
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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-innodb-tables/