# Information Schema InnoDB Tables - [Information Schema INNODB\_CMP\_PER\_INDEX and INNODB\_CMP\_PER\_INDEX\_RESET Tables](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb-tables-information-schema-innodb_cmp_per_index-an.md): These tables provide status information on compression operations for XtraDB/InnoDB tables, grouped by individual indexes. - [Information Schema INNODB\_BUFFER\_PAGE Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_buffer_page-table.md): The Information Schema INNODB\_BUFFER\_PAGE table contains detailed information about each page currently in the InnoDB buffer pool. - [Information Schema INNODB\_BUFFER\_PAGE\_LRU Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_buffer_page_lru-table.md): The Information Schema INNODB\_BUFFER\_PAGE\_LRU table details pages in the buffer pool and their position in the LRU eviction list. - [Information Schema INNODB\_BUFFER\_POOL\_PAGES Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_buffer_pool_pages-table.md): The Information Schema INNODB\_BUFFER\_POOL\_PAGES table provides a record for each page in the buffer pool, specific to the XtraDB engine. - [Information Schema INNODB\_BUFFER\_POOL\_PAGES\_BLOB Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_buffer_pool_pages_blob-table.md): The INNODB\_BUFFER\_POOL\_PAGES\_BLOB table contains information about blob pages in the buffer pool, only available for XtraDB. - [Information Schema INNODB\_BUFFER\_POOL\_PAGES\_INDEX Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_buffer_pool_pages_index-table.md): The INNODB\_BUFFER\_POOL\_PAGES\_INDEX table provides information about index pages in the buffer pool, specific to the XtraDB engine. - [Information Schema INNODB\_BUFFER\_POOL\_STATS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_buffer_pool_stats-table.md): The Information Schema INNODB\_BUFFER\_POOL\_STATS table displays high-level statistics about the InnoDB buffer pool's activity. - [Information Schema INNODB\_CHANGED\_PAGES Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_changed_pages-table.md): The Information Schema INNODB\_CHANGED\_PAGES table lists pages that have been modified since a specific checkpoint. - [Information Schema INNODB\_CMP and INNODB\_CMP\_RESET Tables](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_cmp-and-innodb_cmp_reset-tables.md): These tables contain status information on compression operations for compressed XtraDB/InnoDB tables, detailing compress and uncompress ops. - [Information Schema INNODB\_CMPMEM and INNODB\_CMPMEM\_RESET Tables](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_cmpmem-and-innodb_cmpmem_reset-tables.md): These tables provide status statistics on compressed pages within the buffer pool, useful for analyzing compression efficiency. - [Information Schema INNODB\_FT\_BEING\_DELETED Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_being_deleted-table.md): This table is used only during an OPTIMIZE TABLE operation to store the document IDs of rows currently being deleted from an InnoDB FULLTEXT index. - [Information Schema INNODB\_FT\_CONFIG Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_config-table.md): The Information Schema INNODB\_FT\_CONFIG table displays metadata about the configuration of an InnoDB FULLTEXT index, such as the internal cache size. - [Information Schema INNODB\_FT\_DEFAULT\_STOPWORD Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_default_stopword-table.md): The INNODB\_FT\_DEFAULT\_STOPWORD table lists the default stop words used by InnoDB FULLTEXT indexes when no custom stopword list is defined. - [Information Schema INNODB\_FT\_DELETED Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_deleted-table.md): The INNODB\_FT\_DELETED table lists document IDs of rows that have been deleted from an InnoDB FULLTEXT index but not yet removed from the index files. - [Information Schema INNODB\_FT\_INDEX\_CACHE Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_index_cache-table.md): The INNODB\_FT\_INDEX\_CACHE table displays token information from newly inserted rows in a FULLTEXT index before the data is flushed to disk. - [Information Schema INNODB\_FT\_INDEX\_TABLE Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_index_table-table.md): The INNODB\_FT\_INDEX\_TABLE table provides information about the inverted index (tokens and positions) for an InnoDB FULLTEXT index currently in use. - [Information Schema INNODB\_LOCK\_WAITS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_lock_waits-table.md): The Information Schema INNODB\_LOCK\_WAITS table maps blocked transactions to the transactions that are blocking them, aiding in deadlock analysis. - [Information Schema INNODB\_LOCKS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_locks-table.md): The INNODB\_LOCKS table provides information about locks that a transaction has requested but not yet obtained, or locks that are blocking another transaction. - [Information Schema INNODB\_METRICS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_metrics-table.md): The Information Schema INNODB\_METRICS table contains a wide range of low-level performance metrics and counters for the InnoDB storage engine. - [Information Schema INNODB\_MUTEXES Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_mutexes-table.md): The Information Schema INNODB\_MUTEXES table displays statistics about InnoDB mutex and read-write lock waits, helping to identify internal contention. - [Information Schema INNODB\_SYS\_COLUMNS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_columns-table.md): The INNODB\_SYS\_COLUMNS table contains metadata about InnoDB table columns, derived directly from the internal InnoDB data dictionary. - [Information Schema INNODB\_SYS\_DATAFILES Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_datafiles-table.md): The INNODB\_SYS\_DATAFILES table, now deprecated and removed, was intended to provide metadata for InnoDB tablespace paths. - [Information Schema INNODB\_SYS\_FIELDS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_fields-table.md): The INNODB\_SYS\_FIELDS table lists the fields that comprise InnoDB indexes, detailing their position within the index structure. - [Information Schema INNODB\_SYS\_FOREIGN Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_foreign-table.md): The INNODB\_SYS\_FOREIGN table provides metadata about foreign key constraints defined on InnoDB tables, including reference details. - [Information Schema INNODB\_SYS\_FOREIGN\_COLS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_foreign_cols-table.md): The INNODB\_SYS\_FOREIGN\_COLS table maps columns to their respective foreign key constraints within the InnoDB storage engine. - [Information Schema INNODB\_SYS\_INDEXES Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_indexes-table.md): The INNODB\_SYS\_INDEXES table provides metadata about InnoDB indexes, including the table they belong to, unique IDs, and type. - [Information Schema INNODB\_SYS\_SEMAPHORE\_WAITS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_semaphore_waits-table.md): The INNODB\_SYS\_SEMAPHORE\_WAITS table displays threads currently waiting for semaphores, which is useful for debugging high-concurrency contention. - [Information Schema INNODB\_SYS\_TABLES Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_tables-table.md): The INNODB\_SYS\_TABLES table exposes the internal InnoDB data dictionary metadata for tables, including row formats and space IDs. - [Information Schema INNODB\_SYS\_TABLESPACES Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_tablespaces-table.md): The INNODB\_SYS\_TABLESPACES table provides metadata about the tablespaces used by InnoDB, including space ID, page size, and filename. - [Information Schema INNODB\_SYS\_TABLESTATS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_tablestats-table.md): The INNODB\_SYS\_TABLESTATS table offers low-level performance statistics for InnoDB tables, such as row counts and modification counters. - [Information Schema INNODB\_SYS\_VIRTUAL Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_virtual-table.md): The INNODB\_SYS\_VIRTUAL table contains metadata about the base columns of virtual generated columns in InnoDB tables. - [Information Schema INNODB\_TABLESPACES\_ENCRYPTION Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_tablespaces_encryption-table.md): The INNODB\_TABLESPACES\_ENCRYPTION table provides metadata about encrypted InnoDB tablespaces, including key versions and rotation status. - [Information Schema INNODB\_TABLESPACES\_SCRUBBING Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_tablespaces_scrubbing-table.md): The INNODB\_TABLESPACES\_SCRUBBING table contains statistics about background data scrubbing processes for InnoDB tablespaces. - [Information Schema INNODB\_TRX Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_trx-table.md): The INNODB\_TRX table stores information about currently executing InnoDB transactions, including transaction state, start time, and locks. - [Information Schema TEMP\_TABLES\_INFO Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-temp_tables_info-table.md): The TEMP\_TABLES\_INFO table lists active InnoDB temporary tables, including their column counts and tablespace identifiers. - [Information Schema INNODB\_UNDO\_LOGS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_undo_logs-table.md): The INNODB\_UNDO\_LOGS table, an XtraDB enhancement, contains information about undo log segments, including transaction IDs and states. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.