当前位置：网站首页>The logical architecture of MySQL

The logical architecture of MySQL

2022-07-19 01:05:00 【Put the stars by the bed】

That we use a lot mysql It's a little different , Its architecture can play a good role in different scenarios . It is mainly reflected in the architecture of the storage engine

The plug-in storage engine architecture separates query processing from other system tasks and data storage

Logical architecture ：

Insert picture description here

It is divided into four layers in total ：
Insert picture description here

How to use commands to view our storage engine ：
Insert picture description here
Now? mysql The main engines used are ：MyIsam,InnoDB
The difference between them ：