Sunday, August 10, 2025

MySQL architecture

There are 3 layers. 

The layer handles connection, authentication and security 

The second layer is the optimizer, execution engine and cache. 

The bottom layer is the storage engines. The storage engine API make it transparent to the query. Transaction is implemented in this layer. 

No comments: