System Tables for MariaDB Community Server 10.2

Overview

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

Reference material is available for MariaDB Community Server 10.2.

System Tables for MariaDB Community Server 10.2

The following system tables are present in MariaDB Community Server 10.2:

Table

Description

column_stats

Statistics on Columns

columns_priv

Column privileges

db

Database privileges

event

Events

func

User defined functions

general_log

General log

gtid_slave_pos

Replication slave GTID position

help_category

help categories

help_keyword

help keywords

help_relation

keyword-topic relation

help_topic

help topics

host

Host privileges; Merged with database privileges

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

servers

MySQL Foreign Servers table

slow_log

Slow log

spider_link_failed_log

spider_link_mon_servers

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

user

Users and global privileges

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