Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about the execution process of SQL statements in mysql. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

What parts does MySQL have? Connectors: manage connections, rights verification. Analyzer: lexical analysis, grammatical analysis. Optimizer: perform plan generation, index selection. Actuator: operates the storage engine and returns the results.

Storage engine: stores data and provides a read-write interface.

Connector

The first step is to connect to the MySQL database, which is to connect to the connector. Connectors are responsible for establishing connections with customers, obtaining permissions, maintaining and managing connections.

Mysql-h $ip-u root-p query cache

Once the connection is established, we can use the SELECT statement, and the execution logic comes to the second step: query caching. MySQL will now query the cache to see if this statement has been executed before, and if so, return it directly. After MySQL 8.0, this module has been removed.

Analyzer

If there is no query cache, from here MySQL will start to analyze what we are going to do, and we need to analyze our writing SQL statements. The analyzer will first do a lexical analysis to identify the string and the meaning it represents. Then we do syntax analysis to determine whether there are any errors in the SQL statement we wrote, and if there are any errors, we will throw an error.

Optimizer

After passing the parser, MySQL knows what you are going to do, and the optimizer will decide which scheme to use based on the table structure and the purpose of the statement.

Actuator

MySQL knows what we are going to do through the analyzer and the most efficient way to do it through the optimizer. So you can go to the executor and actually execute the SQL statement.

Select * from users where name = 'operator'

Assuming that there is no index on the name field in the users table, the executor calls the InnoDB engine API to take the first row to determine whether name is equal to operator. If not, skip it, and if so, put it in the result set. Then call the engine interface to fetch the next row, repeating the same logical judgment until the last row of the table is fetched. Finally, the result set is returned to the client.

After reading the above, do you have any further understanding of the execution process of the SQL statement in mysql? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.