Describe the SQL execution process? Linux Cloud Computing Operations

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.