System Tables in 10.5 ES

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.

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

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