High Performance MySQL: Reading Note (2) MySQL overview

1. MySQL Structure(3 layers).

Client <–> Service (core) <–> Storage (physical).

2. 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).