Shulou(Shulou.com)05/31 Report--

This article shows you what the role of MySQL default database is, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

1. Mysql library. The database is the core database of mysql. The tables under this database mainly store the information needed by mysql itself, such as database users and permissions, and mainly include the following tables:

Columns_priv: column-level fully new table

Db: library-level permissions table

User: user account

Tables_priv: table-level permission

Procs_priv: stored procedures and function permissions

Proxies_priv: permissions of the proxy user

Event: event and task scheduling table

Gtid: tables related to GTID master-slave replication

Innodb_index_stats:innodb Index Statistics

Innodb_table_stats:innodb statistics

Plugin: plug-in table

Second, sys library. All data in the library comes from performancce_schema. The main thing is to quickly understand the operation of the database.

Third, performancce_ schema library. Used to collect database server performance data in order to analyze problems. Useful information such as which SQL is executed the most, which takes the most time, and which SQL is locked.

4. Information_ schema library. Providing database metadata, such as database name, table name, index, etc., is actually the function of a dictionary table. Bronze drum this library queries information such as which database a table belongs to and which table a field belongs to.

The above is what is the function of MySQL default database. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.