# Information Schema Tables

- [Information Schema ALL\_PLUGINS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/all-plugins-table-information-schema.md): The Information Schema ALL\_PLUGINS table contains information about server plugins, whether installed or not, providing a superset of SHOW PLUGINS SONAME.
- [Information Schema APPLICABLE\_ROLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-applicable_roles-table.md): The Information Schema APPLICABLE\_ROLES table shows the role authorizations that the current user may use, detailing grantable and default status.
- [Information Schema CATALOG Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-catalog-table.md): The Information Schema CATALOG table stores information about catalogs on the server, including default character sets and collations.
- [Information Schema CHARACTER\_SETS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-character_sets-table.md): The Information Schema CHARACTER\_SETS table contains a list of supported character sets, their default collations, and maximum lengths.
- [Information Schema CHECK\_CONSTRAINTS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-check_constraints-table.md): The Information Schema CHECK\_CONSTRAINTS table stores metadata about the constraints defined for tables in all databases, including the check clause.
- [Information Schema CLIENT\_STATISTICS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-client_statistics-table.md): The Information Schema CLIENT\_STATISTICS table holds statistics about client connections, such as total connections, bytes sent/received, and command counts.
- [Information Schema COLLATION\_CHARACTER\_SET\_APPLICABILITY Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-collation_character_set_applicability-table.md): The Information Schema COLLATION\_CHARACTER\_SET\_APPLICABILITY table maps which character sets are associated with which collations.
- [Information Schema COLLATIONS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-collations-table.md): The Information Schema COLLATIONS table contains a list of supported collations, indicating their associated character sets and compilation status.
- [Information Schema COLUMN\_PRIVILEGES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-column_privileges-table.md): The Information Schema COLUMN\_PRIVILEGES table contains column privilege information derived from the mysql.columns\_priv grant table.
- [Information Schema COLUMNS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-columns-table.md): The Information Schema COLUMNS table provides information about columns in each table on the server, including data types, defaults, and nullability.
- [Information Schema DISKS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-disks-table.md): The Information Schema DISKS table, created by the DISKS plugin, displays metadata such as total and available space for disks on the system.
- [Information Schema ENABLED\_ROLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-enabled_roles-table.md): The Information Schema ENABLED\_ROLES table lists all roles that are currently enabled for the current session, including nested roles.
- [Information Schema ENGINES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-engines-table.md): The Information Schema ENGINES table displays status information about the server's storage engines, including support level and transaction capabilities.
- [Information Schema EVENTS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-events-table.md): The Information Schema EVENTS table stores information about scheduled events on the server, including their timing, definition, and status.
- [Information Schema FEEDBACK Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-feedback-table.md): The Information Schema FEEDBACK table is created when the Feedback Plugin is enabled and contains the usage data collected for submission.
- [Information Schema FILE\_KEY\_MANAGEMENT\_KEYS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-file_key_management_keys.md): The Information Schema FILES table provides information about files stored in tablespaces, such as those used by the InnoDB storage engine.
- [Information Schema HASHICORP\_KEY\_MANAGEMENT\_CACHE Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-hashicorp_key_management_cache.md): The Information Schema HASHICORP\_KEY\_MANAGEMENT\_CACHE table provides information about keys managed by the HashiCorp Key Management plugin.
- [Information Schema GEOMETRY\_COLUMNS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-geometry_columns-table.md): The Information Schema GEOMETRY\_COLUMNS table describes the geometry columns in tables, providing details on spatial reference systems and geometry types.
- [Information Schema GLOBAL\_STATUS and SESSION\_STATUS Tables](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-global_status-and-session_status-tables.md): The GLOBAL\_STATUS and SESSION\_STATUS tables store the global and session values of server status variables, respectively.
- [Information Schema GLOBAL\_VARIABLES and SESSION\_VARIABLES Tables](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-global_variables-and-session_variables-tables.md): The GLOBAL\_VARIABLES and SESSION\_VARIABLES tables store the global and session values of all system variables, respectively.
- [Information Schema INDEX\_STATISTICS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-index_statistics-table.md): The Information Schema INDEX\_STATISTICS table provides statistics on index usage, helping to identify unused indexes and optimize performance.
- [Information Schema KEY\_CACHES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-key_caches-table.md): The Information Schema KEY\_CACHES table displays statistics about the segmented key cache, including block usage and read/write requests.
- [Information Schema KEY\_COLUMN\_USAGE Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-key_column_usage-table.md): The Information Schema KEY\_COLUMN\_USAGE table details which columns in a table are constrained by keys, such as primary or foreign keys.
- [Information Schema KEY\_PERIOD\_USAGE Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-key_period_usage-table.md): The Information Schema KEY\_PERIOD\_USAGE table describes how keys reference application-time periods, detailing constraints involving those periods.
- [Information Schema KEYWORDS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-keywords-table.md): The Information Schema KEYWORDS table contains a complete list of reserved and non-reserved keywords recognized by the MariaDB server.
- [Information Schema LOCALES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-locales-table.md): The Information Schema LOCALES table lists all compiled-in locales available to the server, providing their IDs, names, and descriptions.
- [Information Schema METADATA\_LOCK\_INFO Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-metadata_lock_info-table.md): The Information Schema METADATA\_LOCK\_INFO table shows active metadata locks and user locks, helping to diagnose locking conflicts.
- [Information Schema MROONGA\_STATS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-mroonga_stats-table.md): The Information Schema MROONGA\_STATS table provides statistical information specific to the Mroonga full-text search storage engine.
- [Information Schema OPTIMIZER\_TRACE Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-optimizer_trace-table.md): The Information Schema OPTIMIZER\_TRACE table contains details about the optimizer's decision-making process for the last executed query.
- [Information Schema PARAMETERS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-parameters-table.md): The Information Schema PARAMETERS table stores information about parameters for stored procedures and functions, including data types and modes.
- [Information Schema PARTITIONS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-partitions-table.md): The Information Schema PARTITIONS table provides detailed metadata about table partitions, including partition methods and data distribution.
- [Information Schema PERIODS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-periods-table.md): The Information Schema PERIODS table provides information about Application-Time Periods, detailing the start and end columns for system versioning.
- [Information Schema PLUGINS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/plugins-table-information-schema.md): The Information Schema PLUGINS table contains information about server plugins, including their status, type, and library paths.
- [Information Schema PROCESSLIST Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-processlist-table.md): The Information Schema PROCESSLIST table contains detailed information about running threads, including their current state and execution time.
- [Information Schema PROFILING Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-profiling-table.md): The Information Schema PROFILING table provides statement resource usage details, such as CPU time and block operations, when profiling is enabled.
- [Information Schema QUERY\_CACHE\_INFO Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-query_cache_info-table.md): The Information Schema QUERY\_CACHE\_INFO table shows all queries currently stored in the query cache, aiding in cache performance analysis.
- [Information Schema QUERY\_RESPONSE\_TIME Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-query_response_time-table.md): The Information Schema QUERY\_RESPONSE\_TIME table displays the distribution of query execution times, helping to identify performance bottlenecks.
- [Information Schema REFERENTIAL\_CONSTRAINTS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-referential_constraints-table.md): The Information Schema REFERENTIAL\_CONSTRAINTS table contains metadata about foreign keys, including update and delete rules.
- [Information Schema ROUTINES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-routines-table.md): The Information Schema ROUTINES table stores information about stored procedures and stored functions, including their definitions and properties.
- [Information Schema SCHEMA\_PRIVILEGES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-schema_privileges-table.md): The Information Schema SCHEMA\_PRIVILEGES table contains information about database-level privileges granted to accounts.
- [Information Schema SCHEMATA Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-schemata-table.md): The Information Schema SCHEMATA table stores information about databases on the server, including default character sets and collations.
- [Information Schema SEQUENCES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-sequences-table.md): The Information Schema SEQUENCES table provides metadata about sequence objects, including their minimum, maximum, and current values.
- [Information Schema SLAVE\_STATUS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-slave_status-table.md): The Information Schema SLAVE\_STATUS table displays status information for the replication slave threads, similar to SHOW SLAVE STATUS.
- [Information Schema SPATIAL\_REF\_SYS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-spatial_ref_sys-table.md): The Information Schema SPATIAL\_REF\_SYS table stores information about available Spatial Reference Systems (SRS) for geometry data.
- [Information Schema SPIDER\_ALLOC\_MEM Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-spider_alloc_mem-table.md): The Information Schema SPIDER\_ALLOC\_MEM table tracks memory allocation for the Spider storage engine, aiding in resource monitoring.
- [Information Schema SQL\_FUNCTIONS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-sql_functions-table.md): The Information Schema SQL\_FUNCTIONS table lists all available SQL functions, including built-in functions and user-defined functions.
- [Information Schema STATISTICS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-statistics-table.md): The Information Schema STATISTICS table provides information about table indexes, serving as a standard-compliant alternative to SHOW INDEX.
- [Information Schema SYSTEM\_VARIABLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-system_variables-table.md): The Information Schema SYSTEM\_VARIABLES table contains all system variables and their current global or session values.
- [Information Schema TABLE\_CONSTRAINTS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-table_constraints-table.md): The Information Schema TABLE\_CONSTRAINTS table describes constraints on tables, such as PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints.
- [Information Schema TABLE\_PRIVILEGES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-table_privileges-table.md): The Information Schema TABLE\_PRIVILEGES table lists privileges granted specifically at the table level.
- [Information Schema TABLE\_STATISTICS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-table_statistics-table.md): The Information Schema TABLE\_STATISTICS table provides usage statistics for tables, such as the number of rows read or changed.
- [Information Schema TABLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-tables-table.md): Complete Information Schema TABLES reference: TABLE\_ROWS, DATA\_LENGTH/INDEX\_LENGTH, CREATE\_TIME/UPDATE\_TIME columns, TEMPORARY='Y', and WHERE clause queries.
- [Information Schema TABLESPACES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-tablespaces-table.md): The Information Schema TABLESPACES table provides information about active tablespaces, specifically for the InnoDB storage engine.
- [Information Schema THREAD\_POOL\_GROUPS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-thread_pool_groups-table.md): The Information Schema THREAD\_POOL\_GROUPS table provides details about the thread groups in the thread pool, including active thread counts.
- [Information Schema THREAD\_POOL\_QUEUES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-thread_pool_queues-table.md): The Information Schema THREAD\_POOL\_QUEUES table shows the status of the queues within the thread pool, detailing pending connections.
- [Information Schema THREAD\_POOL\_STATS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-thread_pool_stats-table.md): The Information Schema THREAD\_POOL\_STATS table provides performance statistics for the thread pool, such as thread creation and efficiency.
- [Information Schema THREAD\_POOL\_WAITS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-thread_pool_waits-table.md): The Information Schema THREAD\_POOL\_WAITS table lists the number of times threads in the thread pool have waited for various events.
- [Information Schema TRIGGERED\_UPDATE\_COLUMNS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-triggered_update_columns.md): The Information Schema TRIGGERED\_UPDATE\_COLUMNS table identifies which columns are modified by the SET clause of a specific trigger.
- [Information Schema TRIGGERS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-triggers-table.md): The Information Schema TRIGGERS table contains detailed information about triggers, including the event, timing, and action statement.
- [Information Schema USER\_PRIVILEGES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-user_privileges-table.md): The Information Schema USER\_PRIVILEGES table lists global privileges granted to user accounts, derived from the mysql.user table.
- [Information Schema USER\_STATISTICS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-user_statistics-table.md): The Information Schema USER\_STATISTICS table provides activity statistics for users, such as bytes sent and rows read, aiding in auditing.
- [Information Schema USER\_VARIABLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-user_variables-table.md): The Information Schema USERS\_VARIABLES table lists user accounts, including whether they are global or local, and details about their password expiration.
- [Information Schema USERS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-users-table.md): The Information Schema USERS table lists user accounts, including whether they are global or local, and details about their password expiration.
- [Information Schema WSREP\_BF\_ABORTS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_bf_aborts.md): The Information Schema WSREP\_BF\_ABORTS table provides statistics on Galera Cluster brute force aborts, detailing the victim and transaction IDs.
- [Information Schema WSREP\_CERT\_KEYS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_cert_keys.md): The Information Schema WSREP\_CERT\_KEYS table displays the certification keys for transactions currently being processed by the Galera Cluster.
- [Information Schema WSREP\_CERT\_KEYS\_HISTORY](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_cert_keys_history.md): The Information Schema WSREP\_CERT\_KEYS\_HISTORY table logs a history of certification keys for recently processed Galera transactions.
- [Information Schema WSREP\_CONNECTIONS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_connections.md): The Information Schema WSREP\_CONNECTIONS table shows active connections to the Galera Cluster, primarily used for debugging cluster membership.
- [Information Schema WSREP\_MEMBERSHIP Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_membership-table.md): The Information Schema WSREP\_MEMBERSHIP table lists the current members of the Galera Cluster, including their node UUIDs, names, and IP addresses.
- [Information Schema WSREP\_STATUS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_status-table.md): The Information Schema WSREP\_STATUS table provides a comprehensive view of the Galera Cluster status variables, similar to SHOW STATUS LIKE 'wsrep%'
- [Information Schema WSREP\_THD\_STATE](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_thd_state.md): The Information Schema WSREP\_THD\_STATE table displays the internal state of Galera threads, helping to monitor replication progress and locking.
- [Information Schema WSREP\_THD\_STATE\_HISTORY](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_thd_state_history.md): The Information Schema WSREP\_THD\_STATE\_HISTORY table maintains a history of thread states for Galera replication, aiding in post-incident analysis.
- [Information Schema InnoDB Tables](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables.md): 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](/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.
- [Information Schema MyRocks Tables](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables.md): Query INFORMATION\_SCHEMA.MYROCKS\_TABLES. These system tables provide metadata about MyRocks tables, including their storage, compression, and other properties for performance analysis.
- [Information Schema ROCKSDB\_CF\_OPTIONS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_cf_options-table.md): The Information Schema ROCKSDB\_CF\_OPTIONS table contains information about MyRocks column families, such as the column family name and option type.
- [Information Schema ROCKSDB\_CFSTATS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_cfstats-table.md): The Information Schema ROCKSDB\_CFSTATS table provides statistics for each column family in the MyRocks storage engine.
- [Information Schema ROCKSDB\_COMPACTION\_STATS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_compaction_stats-table.md): The Information Schema ROCKSDB\_COMPACTION\_STATS table contains statistics about compaction operations performed by the RocksDB engine.
- [Information Schema ROCKSDB\_DBSTATS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_dbstats-table.md): The Information Schema ROCKSDB\_DBSTATS table displays database-level statistics for the MyRocks storage engine.
- [Information Schema ROCKSDB\_DDL Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_ddl-table.md): The Information Schema ROCKSDB\_DDL table contains information about Data Definition Language (DDL) operations in MyRocks, including table and index names.
- [Information Schema ROCKSDB\_DEADLOCK Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_deadlock-table.md): The Information Schema ROCKSDB\_DEADLOCK table provides information about deadlocks that have occurred within the MyRocks storage engine.
- [Information Schema ROCKSDB\_GLOBAL\_INFO Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_global_info-table.md): The Information Schema ROCKSDB\_GLOBAL\_INFO table contains global configuration information for the MyRocks storage engine.
- [Information Schema ROCKSDB\_INDEX\_FILE\_MAP Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_index_file_map-table.md): The Information Schema ROCKSDB\_INDEX\_FILE\_MAP table maps MyRocks indexes to their corresponding SST files, useful for understanding data storage.
- [Information Schema ROCKSDB\_LOCKS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_locks-table.md): The Information Schema ROCKSDB\_LOCKS table displays information about locks currently held or requested by MyRocks transactions.
- [Information Schema ROCKSDB\_PERF\_CONTEXT Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_perf_context-table.md): The Information Schema ROCKSDB\_PERF\_CONTEXT table contains performance counters for the current session, providing granular metrics on RocksDB operations.
- [Information Schema ROCKSDB\_PERF\_CONTEXT\_GLOBAL Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_perf_context_global-table.md): The Information Schema ROCKSDB\_PERF\_CONTEXT\_GLOBAL table aggregates performance counters from all sessions, offering a global view of MyRocks performance.
- [Information Schema ROCKSDB\_SST\_PROPS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_sst_props-table.md): The Information Schema ROCKSDB\_SST\_PROPS table displays properties of SST files, such as data size and compression ratios, for MyRocks tables.
- [Information Schema ROCKSDB\_TRX Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_trx-table.md): The Information Schema ROCKSDB\_TRX table provides information about active transactions in MyRocks, including transaction IDs and states.
- [Information Schema XtraDB Tables](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-xtradb-tables.md): These system tables provide metadata about XtraDB tables, including their storage, statistics, and other properties for advanced analysis and management.
- [Information Schema CHANGED\_PAGE\_BITMAPS Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-xtradb-tables/information-schema-changed_page_bitmaps-table.md): The XTRADB\_INTERNAL\_HASH\_TABLES table provides memory usage statistics for internal hash tables used by the XtraDB/InnoDB storage engine.
- [Information Schema XTRADB\_INTERNAL\_HASH\_TABLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-xtradb-tables/information-schema-xtradb_internal_hash_tables-table.md): The XTRADB\_INTERNAL\_HASH\_TABLES table provides memory usage statistics for internal hash tables used by the XtraDB/InnoDB storage engine.
- [Information Schema XTRADB\_READ\_VIEW Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-xtradb-tables/information-schema-xtradb_read_view-table.md): The XTRADB\_READ\_VIEW table displays the current MVCC read views, showing which transactions are visible to active queries.
- [Information Schema XTRADB\_RSEG Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-xtradb-tables/information-schema-xtradb_rseg-table.md): The XTRADB\_RSEG table contains detailed information about the rollback segments used by XtraDB for undo logging and MVCC.