Home >Database >Mysql Tutorial >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!