1.14 MySQL Architecture

1. MySQL Logical Architecture Diagram

• 
• 

1. The client requests the server.
2. The server’s connection manager handles connections.
3. The server’s query optimizer handles SQL.
   • After a query statement is parsed, it is handed to the query optimizer for optimization. The result of optimization is a so-called execution plan.
   • This execution plan indicates which indexes should be used for the query and what the join order between tables should be.
4. Finally, according to the steps in the execution plan, methods provided by the storage engine are called to actually execute the query and return the query result to the user.

2. MySQL Components

2.1. Server Layer

• Responsible for components related to MySQL functionality.

2.1.1. Connector

• MySQL Connector.md

2.1.2. Parser

• MySQL Parser.md

2.1.3. Optimizer

• MySQL Query Optimizer.md

2.1.4. Executor

• MySQL Executor.md

2.2. Storage Engine

• MySQL Storage Engines.md

3. References

• 10,000-Word Summary: One Article Is Enough to Learn MySQL Optimization Principles! - SQL Optimization - dbaplus Community
• Introduction to MySQL Logical Architecture