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. Until MariaDB 10.4, system tables used the MyISAM storage engine. From MariaDB 10.4, they use Aria.
| Title | Description |
|---|---|
| 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.plugin Table | Plugins loaded with INSTALL SONAME, INSTALL PLUGIN or the mysql_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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/the-mysql-database-tables/
