System Tables for MariaDB Enterprise Server 10.4

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.4.

System Tables for MariaDB Enterprise Server 10.4

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

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".