# The mysql Database Tables - [mysql.column\_stats Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-column_stats-table.md): The mysql.column\_stats table stores engine-independent column statistics, such as histograms, used by the optimizer to improve query execution plans. - [mysql.columns\_priv Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-columns_priv-table.md): The mysql.columns\_priv table records column-level privileges granted to users, detailing specific access rights for individual columns. - [mysql.db Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-db-table.md): The mysql.db table stores database-level privileges, determining which users have access to specific databases and what actions they can perform. - [mysql.event Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-event-table.md): The mysql.event table contains the definitions and scheduling information for events created with the CREATE EVENT statement. - [mysql.func Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-func-table.md): The mysql.func table registers user-defined functions (UDFs), storing their names and the shared library files containing their code. - [mysql.general\_log Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysqlgeneral_log-table.md): The mysql.general\_log table captures a record of all SQL statements received by the server when general query logging is enabled and written to tables. - [mysql.global\_priv Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-global_priv-table.md): The mysql.global\_priv table stores global privileges and account properties for all users, replacing the older mysql.user table structure. - [mysql.gtid\_slave\_pos Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysqlgtid_slave_pos-table.md): The mysql.gtid\_slave\_pos table tracks the Global Transaction ID (GTID) of the last applied transaction on a replica to ensure replication consistency. - [mysql.help\_category Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_category-table.md): The mysql.help\_category table stores category information for the server-side help system, organizing help topics into a hierarchy. - [mysql.help\_keyword Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_keyword-table.md): The mysql.help\_keyword table maps keywords to help topics, facilitating keyword-based searches within the MariaDB help system. - [mysql.help\_relation Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_relation-table.md): The mysql.help\_relation table links help keywords to help topics, defining the structure of the server-side help system. - [mysql.help\_topic Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_topic-table.md): The mysql.help\_topic table stores the detailed content of help topics, including descriptions and examples displayed by the HELP command. - [mysql.index\_stats Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-index_stats-table.md): The mysql.index\_stats table stores engine-independent index statistics, such as cardinality, used by the optimizer to plan query execution. - [mysql.innodb\_index\_stats](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-innodb_index_stats.md): The mysql.innodb\_index\_stats table stores persistent index statistics for InnoDB, allowing optimizer plans to remain stable across restarts. - [mysql.innodb\_table\_stats](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-innodb_table_stats.md): The mysql.innodb\_table\_stats table holds persistent table-level statistics for InnoDB, such as row counts, used for query optimization. - [mysql.password\_reuse\_check\_history Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysqlpassword_reuse_check_history-table.md): This table stores a history of password hashes to enforce security policies regarding password reuse when the relevant plugin is enabled. - [mysql.plugin Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-plugin-table.md): The mysql.plugin table records information about installed server plugins, ensuring they are reloaded automatically upon server startup. - [mysql.proc Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-proc-table.md): The mysql.proc table stores the definitions, body, and metadata for stored procedures and functions created on the server. - [mysql.procs\_priv Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-procs_priv-table.md): The mysql.procs\_priv table records privileges granted to users specifically for executing or altering stored procedures and functions. - [mysql.proxies\_priv Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-proxies_priv-table.md): The mysql.proxies\_priv table manages proxy user privileges, defining which accounts are authorized to proxy as other users. - [mysql.roles\_mapping Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-roles_mapping-table.md): The mysql.roles\_mapping table manages role assignments, linking user accounts to the roles they have been granted. - [mysql.servers Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-servers-table.md): The mysql.servers table stores connection information for remote servers, used by the FEDERATED and Spider storage engines. - [mysql.slow\_log Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-slow_log-table.md): The mysql.slow\_log table records details of queries that exceed the long\_query\_time threshold when slow query logging to tables is enabled. - [mysql.table\_stats Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-table_stats-table.md): The mysql.table\_stats table stores engine-independent statistics about tables, such as row counts, to assist the optimizer. - [mysql.tables\_priv Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-tables_priv-table.md): The mysql.tables\_priv table records table-level privileges granted to users, specifying which actions they can perform on specific tables. - [mysql.time\_zone Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone-table.md): The mysql.time\_zone table assigns a unique ID to each time zone supported by the server, linking to other time zone system tables. - [mysql.time\_zone\_leap\_second Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_leap_second-table.md): The mysql.time\_zone\_leap\_second table lists leap second corrections to be applied to specific time zones. - [mysql.time\_zone\_name Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_name-table.md): The mysql.time\_zone\_name table maps human-readable time zone names (e.g., "Europe/Berlin") to their internal time zone IDs. - [mysql.time\_zone\_transition Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_transition-table.md): The mysql.time\_zone\_transition table defines the exact times at which daylight saving time or other time zone transitions occur. - [mysql.time\_zone\_transition\_type Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_transition_type-table.md): The mysql.time\_zone\_transition\_type table describes the properties of time zone transitions, such as the offset and abbreviation. - [mysql.transaction\_registry Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-transaction_registry-table.md): The mysql.transaction\_registry table is used by system-versioned tables to track transaction IDs and their commit timestamps. - [mysql.user Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-user-table.md): Complete mysql.user table reference: mysql.global\_priv view, Host/User identifiers, plugin/authentication\_string fields, and GRANT/CREATE USER integration. - [Spider mysql Database Tables](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables.md): Explore Spider-related tables within the mysql database. These system tables store crucial configuration and metadata for the Spider storage engine, essential for distributed deployments. - [mysql.spider\_link\_failed\_log Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_link_failed_log-table.md): This table logs failures when attempting to establish connections to remote Spider links, helping to diagnose network or configuration issues. - [mysql.spider\_link\_mon\_servers Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_link_mon_servers-table.md): This table defines the remote servers used for link monitoring in the Spider storage engine, ensuring high availability and failover handling. - [mysql.spider\_table\_crd Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_crd-table.md): The mysql.spider\_table\_crd table stores cardinality statistics for Spider tables, which the optimizer uses to create efficient query plans. - [mysql.spider\_table\_position\_for\_recovery Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_position_for_recovery-table.md): This table records XA transaction positions for Spider tables, essential for recovering distributed transactions after a crash. - [mysql.spider\_table\_sts Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_sts-table.md): The mysql.spider\_table\_sts table holds statistics such as row counts and data length for Spider tables, supporting the optimizer. - [mysql.spider\_tables Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_tables-table.md): This table stores specific parameters and metadata for Spider tables, defining how they map to remote backend tables. - [mysql.spider\_xa Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa-table.md): The mysql.spider\_xa table tracks the status of XA transactions involving Spider tables, ensuring atomicity across distributed nodes. - [mysql.spider\_xa\_failed\_log Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa_failed_log-table.md): This table logs details of failed XA transactions in the Spider storage engine, providing a record for troubleshooting distributed transaction errors. - [mysql.spider\_xa\_member Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa_member-table.md): The mysql.spider\_xa\_member table lists the member nodes participating in a distributed XA transaction managed by the Spider engine. - [Obsolete mysql Database Tables](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/obsolete-mysql-database-tables.md): Explore obsolete tables in the mysql database for MariaDB Server. This section provides information on deprecated system tables, useful for understanding historical contexts or migration planning. - [mysql.host Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/obsolete-mysql-database-tables/mysql-host-table.md) - [mysql.ndb\_binlog\_index Table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/obsolete-mysql-database-tables/mysqlndb_binlog_index-table.md) --- # 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/the-mysql-database-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.