System Tables for MariaDB Enterprise Server 10.5

Overview

MariaDB Enterprise Server 10.5 stores general settings like user accounts in a series of system tables on the mysql schema.

Reference material is available for MariaDB Enterprise Server 10.5.

System Tables for MariaDB Enterprise Server 10.5

The following system tables are present in MariaDB Enterprise Server 10.5:

Table

Description

column_stats

Statistics on Columns

columns_priv

Column privileges

db

Database privileges

event

Events

func

User defined functions

general_log

General log

global_priv

Users and global privileges

gtid_slave_pos

Replication slave GTID position

help_category

help categories

help_keyword

help keywords

help_relation

keyword-topic relation

help_topic

help topics

index_stats

Statistics on Indexes

innodb_index_stats

Statistics collected on InnoDB table indexes.

innodb_table_stats

Statistics collected on InnoDB tables.

plugin

MySQL plugins

proc

Stored Procedures

procs_priv

Procedure privileges

proxies_priv

User proxy privileges

roles_mapping

Granted roles

server_audit_filters

Filter definitions for MariaDB Enterprise Audit

server_audit_users

Assignments of filter definition to database users.

servers

MySQL Foreign Servers table

slow_log

Slow log

table_stats

Statistics on Tables

tables_priv

Table privileges

time_zone

Time zones

time_zone_leap_second

Leap seconds information for time zones

time_zone_name

Time zone names

time_zone_transition

Time zone transitions

time_zone_transition_type

Time zone transition types

transaction_registry

Transaction-precise versioning for system-versioned tables.

user

VIEW

To see system tables present in other versions, see "System Tables by MariaDB Server Version".