A brief understanding of MySQL getting started Architectur

This article mainly gives you a brief introduction to the MySQL entry architecture. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on the introduction to MySQL architecture can bring you some practical help.

The logical architecture of MySQL is mainly divided into three layers:

The first layer: the client connection processing, security authentication, authorization, etc., each client connection will have a thread on the server, and the query initiated by each connection will be executed in the corresponding separate thread. The second layer: the core service function layer of MySQL, including query parsing, analysis, query caching, built-in functions, stored procedures, triggers, views, etc. Select operation will first check whether it hits the query cache, and then directly return the cached data, otherwise, parse the query and create the corresponding parsing tree. Layer 3: storage engine, which is responsible for data storage and extraction. MySQL CVM communicates with storage engine through API, shielding the differences between various engines. Common storage engines are: InnoDB and MyISAM.

MySQL entry framework will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.