> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables.md).

# The mysql Database Tables

{% columns %}
{% column %}
{% content-ref url="/pages/J2eaDyDC33HkmVR5CW8r" %}
[mysql.column\_stats Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-column_stats-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.column\_stats table stores engine-independent column statistics, such as histograms, used by the optimizer to improve query execution plans.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TEKdijZBNJAOeWqVKU4x" %}
[mysql.columns\_priv Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-columns_priv-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.columns\_priv table records column-level privileges granted to users, detailing specific access rights for individual columns.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/MXc6OFsk71Rhhj8IITTJ" %}
[mysql.db Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-db-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.db table stores database-level privileges, determining which users have access to specific databases and what actions they can perform.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/k4MweOkKetHMuB5KUxK0" %}
[mysql.event Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-event-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.event table contains the definitions and scheduling information for events created with the CREATE EVENT statement.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/PKgj5y1IPmo5272vZnOM" %}
[mysql.func Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-func-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.func table registers user-defined functions (UDFs), storing their names and the shared library files containing their code.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Cb6mDFeNhwBKqwIck2ya" %}
[mysql.general\_log Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysqlgeneral_log-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/dzlPuWj8vvhrXP1CMIkF" %}
[mysql.global\_priv Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-global_priv-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.global\_priv table stores global privileges and account properties for all users, replacing the older mysql.user table structure.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/6XbxMsSCnAq5NQBbHoIn" %}
[mysql.gtid\_slave\_pos Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysqlgtid_slave_pos-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.gtid\_slave\_pos table tracks the Global Transaction ID (GTID) of the last applied transaction on a replica to ensure replication consistency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ZxjWUmy78vlOsFOBs0fL" %}
[mysql.help\_category Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_category-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.help\_category table stores category information for the server-side help system, organizing help topics into a hierarchy.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/lOsA7tUSbZYO92YIDJUR" %}
[mysql.help\_keyword Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_keyword-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.help\_keyword table maps keywords to help topics, facilitating keyword-based searches within the MariaDB help system.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/WwLjZXXWYnZOwTgefdf0" %}
[mysql.help\_relation Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_relation-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.help\_relation table links help keywords to help topics, defining the structure of the server-side help system.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Pyw2PUQWBIjQ5uC8Yh7b" %}
[mysql.help\_topic Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-help_topic-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.help\_topic table stores the detailed content of help topics, including descriptions and examples displayed by the HELP command.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ygzSSFvMDMefRjQmRfpJ" %}
[mysql.index\_stats Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-index_stats-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.index\_stats table stores engine-independent index statistics, such as cardinality, used by the optimizer to plan query execution.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/WpXFuYfi8MMFJOvbim8g" %}
[mysql.innodb\_index\_stats](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-innodb_index_stats.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.innodb\_index\_stats table stores persistent index statistics for InnoDB, allowing optimizer plans to remain stable across restarts.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/glGzkY29wMo1WiOUbGom" %}
[mysql.innodb\_table\_stats](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-innodb_table_stats.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.innodb\_table\_stats table holds persistent table-level statistics for InnoDB, such as row counts, used for query optimization.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/4463dwianezqt7oWrgwS" %}
[mysql.password\_reuse\_check\_history Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysqlpassword_reuse_check_history-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This table stores a history of password hashes to enforce security policies regarding password reuse when the relevant plugin is enabled.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/nBMcxS9u7IMKhWxoEnvm" %}
[mysql.plugin Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-plugin-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.plugin table records information about installed server plugins, ensuring they are reloaded automatically upon server startup.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/gEa82A5FPCL8xgC5W13T" %}
[mysql.proc Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-proc-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.proc table stores the definitions, body, and metadata for stored procedures and functions created on the server.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/xKBc2cP2olqqXR3EuXHe" %}
[mysql.procs\_priv Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-procs_priv-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.procs\_priv table records privileges granted to users specifically for executing or altering stored procedures and functions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/eKWrMyveQ06BKNIGM9U9" %}
[mysql.proxies\_priv Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-proxies_priv-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.proxies\_priv table manages proxy user privileges, defining which accounts are authorized to proxy as other users.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/HHZUHXWxf8H7gJtNcocC" %}
[mysql.roles\_mapping Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-roles_mapping-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.roles\_mapping table manages role assignments, linking user accounts to the roles they have been granted.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/fCRiMey5aXrVpkOLtmuR" %}
[mysql.servers Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-servers-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.servers table stores connection information for remote servers, used by the FEDERATED and Spider storage engines.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/PMz0msZYghF14r6lu1uQ" %}
[mysql.slow\_log Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-slow_log-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.slow\_log table records details of queries that exceed the long\_query\_time threshold when slow query logging to tables is enabled.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/DbEzlFwcuKGwuOzHvnZY" %}
[mysql.table\_stats Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-table_stats-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.table\_stats table stores engine-independent statistics about tables, such as row counts, to assist the optimizer.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/efFSMOOJ8QTcf5lBFDt9" %}
[mysql.tables\_priv Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-tables_priv-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.tables\_priv table records table-level privileges granted to users, specifying which actions they can perform on specific tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/fxiwjNlfKIXXb0qvuliY" %}
[mysql.time\_zone Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.time\_zone table assigns a unique ID to each time zone supported by the server, linking to other time zone system tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/sjHdOfIt6upP99Zpp325" %}
[mysql.time\_zone\_leap\_second Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_leap_second-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.time\_zone\_leap\_second table lists leap second corrections to be applied to specific time zones.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TpylHzplk5tEzxDn9lxM" %}
[mysql.time\_zone\_name Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_name-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.time\_zone\_name table maps human-readable time zone names (e.g., "Europe/Berlin") to their internal time zone IDs.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/qo5cxOjYmOSlTurVTJ75" %}
[mysql.time\_zone\_transition Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_transition-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.time\_zone\_transition table defines the exact times at which daylight saving time or other time zone transitions occur.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/9TJ1i18F5RCcNWXGc79a" %}
[mysql.time\_zone\_transition\_type Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-time_zone_transition_type-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.time\_zone\_transition\_type table describes the properties of time zone transitions, such as the offset and abbreviation.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TZVZv14iiEQlKT69YWtS" %}
[mysql.transaction\_registry Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-transaction_registry-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.transaction\_registry table is used by system-versioned tables to track transaction IDs and their commit timestamps.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/7XMPmGQgP35CLFASR9fi" %}
[mysql.user Table](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-user-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete mysql.user table reference: mysql.global\_priv view, Host/User identifiers, plugin/authentication\_string fields, and GRANT/CREATE USER integration.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/o398CcRIVZzcVYRzqhdX" %}
[Spider mysql Database Tables](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/cUNVzpYqKCgY3jatesTy" %}
[Obsolete mysql Database Tables](/docs/server/reference/system-tables/the-mysql-database-tables/obsolete-mysql-database-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}