What are the components of mysql

The components of mysql are:

(Recommended learning: mysql tutorial)

• Connection Pool Component

• Management Services and Tools Component

• SQL Interface Component

• Query Analyzer Component

• Optimizer component

• Buffer component

• Plug-in storage engine

• Physical File

The most important feature that distinguishes MySQL database from other databases is its plug-in table storage engine.

MySQL plug-in storage engine architecture provides a series of standard management and service support, these standards have nothing to do with the storage engine itself, such as SQL analyzer and optimizer, and the storage engine is the implementation of the underlying physical structure. Each storage engine developer can develop according to his own wishes.

It is important to note that the storage engine is based on tables, not databases.

The above is the detailed content of What are the components of mysql. For more information, please follow other related articles on the PHP Chinese website!