MySQL Database Source Code Analysis And Design Of The Storage Engine

MySQL is a relation database and currently one of the most rapid database when compared with other databases. The biggest advantage of MySQL lies on its open source codes, so anyone can download it under the permission of GPL and modify it according to personalized requirements. Plug-in storage engine is the most obvious character of MySQL database system. As the component of database server, it is responsible for the I/O operation of database, so that it solve the issue of relation database optimization on physical layer. Database professionals select a specialized storage engine according to specific application's requirements on database read mode, different storage engines separated from the application have different capabilities.This article will open a research based on MySQL open source codes and analyze the design and realization of MySQL kernel deeply. Firstly, our research focus on database foundation of knowledge and MySQL system framework, secondly, it studies MySQL kernel method and analyzes the key classes and algorithm, then further research the entire construction of plug-in storage engine, introduced two classic storage engines: MyISAM and InnoDB. Finally, customized storage engine Nanjupt is designed.