describe the SQL execution process? (Connection layer--sql layer--storage engine layer)
The user connects to MySQL via TCP/IP or socket request.
Through the connection layer to determine the legitimacy of the connection, assigned to connect the corresponding thread.
The connection layer thread sends the SQL statement that the user needs to execute to the SQL layer processing.
SQL layer through, statements, semantics, syntax, SQL type, permissions and other judgments.
Query the cache lookup and find it directly back to the user data.
If the cache is not found, send SQL to the parser, parse, and generate the execution plan.
The optimizer reads the execution plan, judging and selecting the least expensive execution plan.
Execute the plan execution, generate the method scheme to get the data, and leave it to the storage engine layer to continue processing.
The storage engine layer gets the disk data back to the user based on the method provided in the upper layer.
This query information is cached in the query cache.
Linux is now popular with internet companies and wants to stand out from the many IT workers, requiring advanced technology and learning to add value is essential. The way of learning is your insistence. Old boy Education Linux cloud Computing Operations course, 10 years of technical precipitation, put an end to paper, the whole enterprise real case combined with theoretical teaching, want to learn more about the Linux cloud computing operations knowledge, can pay attention to the old boy education.
Describe the SQL execution process? Linux Cloud Computing Operations