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

This article mainly explains "what is the basic framework of mysql database". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what is the basic framework of mysql database"?

Database is a warehouse that organizes, stores and manages data according to the data structure. It has many types, from the simplest table that stores all kinds of data to the large database system that can store massive data. It has been widely used in various aspects.

The database consists of two parts: the server and the storage engine.

The server includes a connector, an analyzer, an optimizer and an actuator. (mysql after version 8.0 does not have query cache, because when the data update is large, the cache hit drops, and the cache is also faced with frequent updates, so the whole module is removed directly. )

Connectors: responsible for establishing connections with clients, obtaining permissions, and then maintaining and managing connections.

It is worth noting that the process of establishing the connection of the connector is very complex. It is recommended to use long connections as much as possible. The connection takes up memory as temporary space during execution, and these resources are released after the connection is disconnected. Long connections accumulate and take up too much memory space, which will be forcibly killed by the system, resulting in an abnormal restart of the database.

There are two ways to solve this problem:

1. Disconnect the long connection regularly.

2. (later versions of mysql5.7) after performing a larger operation, you can reinitialize the connection by executing mysql_reset_connection.

Parser: parses the statement and determines whether the syntax is right or wrong.

Optimizer: before execution, analyze, determine how to use the index, and confirm the join order of each table.

Executor: judge the authority and execute it.

At this point, I believe you have a deeper understanding of "what is the basic framework of mysql database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.