MySQL consists of a data file and a database instance, which is a single-process multithreaded architecture.
Database files: A collection of physical operating system files or other files, in MySQL, the database file can be frm, myd, Myi, IBD and other end of the file, when using the NDB storage engine, is not an OS file, is stored in memory files;
DB instance: A memory structure consisting of a database background process/thread and a shared memory area that can be shared by a running background process/thread. The database shuts down, the data instance does not exist, and the database file is saved on disk.
The main components are:
1.Connectors refers to the interface program with SQL in different development languages;
2.Management serveices & Utilities: Service and tool management interface;
3.Connection Pool: Connection pooling;
4 SQL Interface:sql interface;
5.parser:sql parser;
6.Optimizer: Query optimizer;
7.Cache and buffer: query cache;
8.Engine: Storage Engine
Not finished, to be continued ...
MySQL Architecture Organization