Overview of MySQL Architecture

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.