Mysql architecture Arrangement
MySQL is composed of data files and database instances. It is a single-process, multi-thread architecture.
Database Files: a collection of physical operating system files or other files. In mysql, database files can be files ending with frm, myd, myi, or ibd. When using the ndb storage engine, it is not an OS file, it is a file stored in the memory;
Database instance: A memory structure composed of background processes/threads and a shared memory zone. The shared memory can be shared by running background processes/threads. When the database is closed, the data instance does not exist and the database files are stored on the disk.
Main components:
1. Connectors refers to SQL interface programs in different development languages;
2. Management Serveices & Utilities: interfaces for service and tool Management;
3. Connection Pool: Connection Pool;
4. SQL Interface: SQL Interface;
5. Parser: SQL Parser;
6. Optimizer: Query Optimizer;
7. Cache and Buffer: Query Cache;
8. Engine: storage Engine
Not complete, To be continued...