- MySQL Structure(3 layers).
Client <–> Service (core) <–> Storage (physical).
- Description
Client: connection, authentication, security.
Service: the core part, including components
(1) connection processor (for threads from clients).
(2) query cache (improve performance of query before parser).
(3) SQL parser (parse SQL and optimize).
Storage: that is different engines (transparent for service layer, react and response to service requirements via API).