How to better understand the mysql architecture
This article mainly introduces the mysql architecture, the content of the article is carefully selected and edited by the author, with a certain pertinence, the reference significance for you is still relatively great, the following with the author to understand the v bar.
Overview of Mysql Architecture
In the architecture diagram above, we can study it in layers, similar to the system architecture analysis, and understand the whole architecture exactly by layer.
Connectors: we can see from the figure that it contains programming languages and related drivers that interact with databases, such as Python, Perl, Ruby, PHP, .NET, JDBC, and so on. This layer mainly implements the interaction between different programming languages and SQL.
MySQL Server part
Management Serveices & Utilities: management services for tool components, such as (mysqldump, mysqladmin)
Connection Pool: connection pool component.
SQL interface:SQL interface component
Parser: query Analyzer component.
OPtimizer: optimizer component
Caches & Buffers: cache component
Pluagable storage Engines: plug-in storage engine
Mysql database supports plug-in storage engine, specifically reflected in that when the current storage engine can not meet your current needs, you can find the relevant storage engine files (usually .so files) to copy to the specified path, and then load them in the mysql command line, and do not need to reinstall or restart the database software, you can use the storage engine. Mysql plug-in storage engine is a major feature of mysql database SQLServer and other databases.
File system: physical files, mainly containing physical files stored in the database and binary log files.
After reading the above about the mysql architecture, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information column.
