High-performance MySQL learning note--mysql architecture

1. mysql System architecture

The system structure that displays MySQL content, the entire system is divided three times:

1) network connection and thread processing layer, this layer handles client connection request, authentication and threading, using thread pool, each thread processes a connected query;

2) Query parsing and optimization layer, processing query parsing and optimization work, and provide built-in functions (such as date, time, etc.) and through the storage engine provided by the stored procedures, views, etc.;

3) storage engine, storage engine is responsible for the storage of data, through the Memory engine API to provide services;

High-performance MySQL learning note--mysql architecture