Study and Optimization Based on MySQL Storage Engine

MySQL is an open database of the most common. One of the important characteristics of MySQL is that it provides rich storage engines. In the structure of Web applications, it is very important for the performance of database that the system must choose different storage engines based on different needs. But the default settings performance of MySQL is very not good, so it is necessary to optimize when the system uses MySQL. This paper discusses the most two important storage engines in MySQL, and raises the performance of MySQL by optimize MySQL based on different storage engines.