# Information Schema InnoDB Tables

- [Information Schema INNODB\_CMP\_PER\_INDEX and INNODB\_CMP\_PER\_INDEX\_RESET Tables](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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.