MySQL Architecture understanding and analysis

Contact MySQL for more than a year, but is always an occasional use of the State, on its principle of things research is not enough, in a lot of MySQL related summer vacation mentioned MySQL architecture, very clear analysis of the MySQL module layered and main features, after understanding this feature, Will just help us to learn MySQL database.

A MySQL Architecture overview

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/95/CA/wKiom1kZqfDgaCOQAALTKisud3Q045.jpg-wh_500x0-wm_ 3-wmp_4-s_3352212192.jpg "title=" MySQL architecture. jpg "alt=" wkiom1kzqfdgacoqaaltkisud3q045.jpg-wh_50 "/>

In the architecture diagram above, we can study it hierarchically, similar to the system architecture analysis, and understand the whole architecture by layer.

connectors: We can see that there are programming languages and related drivers that include Python, Perl, Ruby, PHP,. NET, JDBC, and database interaction, which mainly implement the interaction of different programming languages and SQL .

MySQL Server Section

Management serveices & Utilities: Managing services for tool components such as (mysqldump, mysqladmin)

Connection Pool: connection pooling component.

SQL Interface: SQL Interface Components

Parser: Query parser component.

OPtimizer: Optimizer components

Caches & Buffers: Caching components

pluagable storage Engines: plug-in storage engine

The MySQL database supports the plug-in storage engine, which is reflected when the current storage engine does not meet your current requirements. You can find the relevant storage engine files (usually. so files) to the specified path, then load them on the MySQL command line, and you can use the storage engine without reloading or restarting the database software. MySQL plug-in storage engine is a major feature of databases such as MySQL database SQL Server.

File System: A physical file that mainly contains the physical files stored by the database and the binary log files.

This article is from the "Keep Dreaming" blog, please be sure to keep this source http://dreamlinux.blog.51cto.com/9079323/1926038

MySQL Architecture understanding and analysis