# Information Schema Tables - [Information Schema ALL\_PLUGINS Table](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](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. - [Information Schema MyRocks Tables](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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. --- # 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.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.