Brief introduction to the architecture of in-depth mysql-mysql architecture

About MySQL Architecture

The MySQL server is comprised of the SQL layer and the storage engine layer. SQL layer functions include permission judgment, SQL parsing and query cache processing, and the storage engine layer is the completion of the underlying database data storage operations. Such as:

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/8B/D4/wKioL1haPWbDb90NAAAzcpVeDV4246.png-wh_500x0-wm_3 -wmp_4-s_3519715006.png "title=" 1.png "alt=" Wkiol1hapwbdb90naaazcpvedv4246.png-wh_50 "/>

The SQL layer can be divided into three tiers, namely the connection/threading layer, the query cache and the query parser layer, and the optimizer layer. The connection/threading layer is primarily used to handle client requests, authentication, and database security validation. The query cache and Query Analyzer layer is a core part of the SQL layer, responsible for parsing, optimizing, caching, and all of the built-in functions, stored procedures, triggers, views, and so on. The optimizer is primarily responsible for storing and retrieving all data stored in the database.

This article from "Mrlittle" blog, reproduced please contact the author!

Brief introduction to the architecture of in-depth mysql-mysql architecture