The mysql Database Tables
MariaDB comes pre-installed with a system database called mysql containing many important tables storing, in particular, grant and privilege information. Before MariaDB 10.4, system tables used the MyISAM storage engine. From MariaDB 10.4, they use Aria.
-
mysql.column_stats Table
Column stats for engine-independent statistics. -
mysql.columns_priv Table
Column-level privileges -
mysql.db Table
Database-level access and privileges. -
mysql.event Table
Information about MariaDB events. -
mysql.func Table
User-defined function information -
mysql.general_log Table
Contents of the general query log if written to table -
mysql.global_priv Table
Global privileges. -
mysql.gtid_slave_pos Table
For replicas to keep track of the GTID. -
mysql.help_category Table
Help categories. -
mysql.help_keyword Table
Help keywords. -
mysql.help_relation Table
HELP command relations -
mysql.help_topic Table
Help topics. -
mysql.index_stats Table
Index stats for engine-independent statistics. -
mysql.innodb_index_stats
Data related to particular persistent index statistics, multiple rows for each index. -
mysql.innodb_table_stats
Data related to persistent indexes, one row per table. -
mysql.password_reuse_check_history Table
Contains old passwords for purposes of preventing password reuse. -
mysql.plugin Table
Plugins loaded with INSTALL SONAME, INSTALL PLUGIN or the mariadb-plugin utility. -
mysql.proc Table
Information about stored routines. -
mysql.procs_priv Table
Stored procedure and stored function privileges -
mysql.proxies_priv Table
Proxy privileges. -
mysql.roles_mapping Table
MariaDB roles information. -
mysql.servers Table
MariaDB servers. -
mysql.slow_log Table
Contents of the slow query log if written to table. -
mysql.tables_priv Table
Table-level privileges -
mysql.table_stats Table
Table stats for engine-independent statistics. -
mysql.time_zone Table
Time zone table in the mysql database. -
mysql.time_zone_leap_second Table
Time zone leap second. -
mysql.time_zone_name Table
Time zone name. -
mysql.time_zone_transition Table
Time zone transition table. -
mysql.time_zone_transition_type Table
Time zone transition type table. -
mysql.transaction_registry Table
Used for transaction-precise versioning. -
mysql.user Table
User access and global privileges. -
Obsolete mysql Database Tables
Tables no longer present in the mysql system database. -
Spider mysql Database Tables
System tables related to the Spider storage engine.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
