Do DBA more than three years, contacted many mainstream database products, but only had no chance to touch MySQL, today began to decide to self-study MySQL, to their own Chong Chong, first from the MySQL architecture began to learn.
The MySQL database architecture is shown in the following illustration:
As can be seen from the above figure, MySQL is divided into the following components:
Connection Pooling Components
Managing Services and Tool components
SQL Interface Components
Analyzer component
Optimizer component
Buffering components
Plug-in storage engine
Physical files
People with other database basics can immediately discover that MySQL's biggest feature is its pluggable plug-in storage engine, which is the implementation of the underlying physical architecture, and that each storage engine developer can develop as it wishes.
Note: The storage engine is based on the table, not the entire database.