Overview of MySQL Logical Architecture
MySQL follows a Client/Server (C/S) architecture where the server process is mysqld. The system is logically divided into three primary layers:
- Connection Layer: Handles TCP connections, user authentication, permission verification, and connection management via a thread pool.
- Service Layer (SQL Layer): Provides core services including the SQL Interface, Parser, Optimizer, and Caches/Buffers. It is independent of the underlying storage format.
- Engine Layer (Storage Engines): A pluggable layer responsible for the actual storage and retrieval of data from the physical server. It communicates with the Service Layer via APIs.