Explore tables in the mysql database in MariaDB Server. These system tables store essential information for server operation, including user privileges, security settings, and global configuration.
The mysql.column_stats table stores engine-independent column statistics, such as histograms, used by the optimizer to improve query execution plans.
The mysql.columns_priv table records column-level privileges granted to users, detailing specific access rights for individual columns.
The mysql.db table stores database-level privileges, determining which users have access to specific databases and what actions they can perform.
The mysql.event table contains the definitions and scheduling information for events created with the CREATE EVENT statement.
The mysql.func table registers user-defined functions (UDFs), storing their names and the shared library files containing their code.
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.
The mysql.global_priv table stores global privileges and account properties for all users, replacing the older mysql.user table structure.
The mysql.gtid_slave_pos table tracks the Global Transaction ID (GTID) of the last applied transaction on a replica to ensure replication consistency.
The mysql.help_category table stores category information for the server-side help system, organizing help topics into a hierarchy.
The mysql.help_keyword table maps keywords to help topics, facilitating keyword-based searches within the MariaDB help system.
The mysql.help_relation table links help keywords to help topics, defining the structure of the server-side help system.
The mysql.help_topic table stores the detailed content of help topics, including descriptions and examples displayed by the HELP command.
The mysql.index_stats table stores engine-independent index statistics, such as cardinality, used by the optimizer to plan query execution.
The mysql.innodb_index_stats table stores persistent index statistics for InnoDB, allowing optimizer plans to remain stable across restarts.
The mysql.innodb_table_stats table holds persistent table-level statistics for InnoDB, such as row counts, used for query optimization.
This table stores a history of password hashes to enforce security policies regarding password reuse when the relevant plugin is enabled.
The mysql.plugin table records information about installed server plugins, ensuring they are reloaded automatically upon server startup.
The mysql.proc table stores the definitions, body, and metadata for stored procedures and functions created on the server.
The mysql.procs_priv table records privileges granted to users specifically for executing or altering stored procedures and functions.
The mysql.proxies_priv table manages proxy user privileges, defining which accounts are authorized to proxy as other users.
The mysql.roles_mapping table manages role assignments, linking user accounts to the roles they have been granted.
The mysql.servers table stores connection information for remote servers, used by the FEDERATED and Spider storage engines.
The mysql.slow_log table records details of queries that exceed the long_query_time threshold when slow query logging to tables is enabled.
The mysql.table_stats table stores engine-independent statistics about tables, such as row counts, to assist the optimizer.
The mysql.tables_priv table records table-level privileges granted to users, specifying which actions they can perform on specific tables.
The mysql.time_zone table assigns a unique ID to each time zone supported by the server, linking to other time zone system tables.
The mysql.time_zone_leap_second table lists leap second corrections to be applied to specific time zones.
The mysql.time_zone_name table maps human-readable time zone names (e.g., "Europe/Berlin") to their internal time zone IDs.
The mysql.time_zone_transition table defines the exact times at which daylight saving time or other time zone transitions occur.
The mysql.time_zone_transition_type table describes the properties of time zone transitions, such as the offset and abbreviation.
The mysql.transaction_registry table is used by system-versioned tables to track transaction IDs and their commit timestamps.
Complete mysql.user table reference: mysql.global_priv view, Host/User identifiers, plugin/authentication_string fields, and GRANT/CREATE USER integration.
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.
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.
Last updated
Was this helpful?
Was this helpful?
