# The mysql Database Tables

- [mysql.column\_stats Table](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/docs/server/reference/system-tables/the-mysql-database-tables/obsolete-mysql-database-tables/mysql-host-table.md)
- [mysql.ndb\_binlog\_index Table](/docs/server/reference/system-tables/the-mysql-database-tables/obsolete-mysql-database-tables/mysqlndb_binlog_index-table.md)