System Tables for MariaDB Enterprise Server 10.5

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB Enterprise Server 10.5

Topics on this page:

Overview
System Tables for MariaDB Enterprise Server 10.5

Overview

MariaDB Enterprise Server stores general settings like user accounts, MariaDB Enterprise Audit filters, and plugin configuration in a series of system tables on the mysql schema.

MariaDB Enterprise Server 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
password_reuse_check_history	Hashed password history data for the password_reuse_check plugin
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
spider_link_failed_log
spider_link_mon_servers
spider_table_crd
spider_table_position_for_recovery
spider_table_sts
spider_tables
spider_xa
spider_xa_failed_log
spider_xa_member
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".