MySQL storage engine InnoDB, MyISAM, and other storage engines _ MySQL

The MySQL storage engine InnoDB, MyISAM, and other storage engines introduce the constant updates and changes of MySQL. In fact, the most important thing is the change and upgrade of the storage engine, which also derive many different storage engines. When creating a MySQl database (or a schema), we will also ignore the storage engine selection, because the default storage engine we normally use directly.

MySQL 5.1 and earlier versions-MyISAM is the default storage engine

MySQL 5.5 and later-InnoDB is the default storage engine

MyISAM and InnoDB are the two most common storage engines in MySQL. In terms of development history, InnoDB is more powerful than MyISAM, but it cannot completely replace MyISAM, which affects its performance. Some people are pursuing performance and still choose MyISAM. of course, they will give up the unique features of InnoDB.

1. InnoDB storage engine

InnoDB is now the default transaction engine of MySQL and the most important and widely used storage engine. It is designed to handle a large number

. Oracle has also invested a lot of resources to modify InnoDB, which has also been greatly improved. I believe InnoDB will be improved in later versions. "InnoDB transaction model and lock" is the biggest feature, of course, the InnoDB behavior is very complicated.

(Transaction processing: Similar to inserting two tables, the first one succeeded, and the second one failed. It will implement "rollback" and delete the first successfully inserted data) 2. MyISAM storage engine

As one of the earliest storage engines, MyISAM has been developing for many years to meet users' actual needs. The simple design of the MyISAM engine stores data in a tight format, so the performance is good in a large number of cases.

3. Other built-in storage engines of MySQL

Archive engine, Blackhole engine, CSV engine, Memory engine, Merige engine, and NDB Cluster Engine. of course, each storage engine has its own unique features, otherwise it will not survive until now.

4. third-party storage engine

XtraDB Storage Engine, TokuDB storage engine, Aria storage engine (renamed Maria), Groonga storage engine, and SphinxSE engine. The above is just a list of common storage engines. to select a storage engine, you must first understand the basic requirements of references. InnoDB and MyISAM are not as good. if the logic is complex, InnoDB is the best choice, if the performance is highlighted, MyISAM should be better. If you want to tell the truth, you will have personal feelings when choosing the storage engine and database version. for example, what I choose isAria storage engineTo develop

The purpose of www.yi18.net is to replace MyISAM. Here is my personal sentiment "supporting MySQL branches and communities". when I heard that Aria has better performance than MyISAM, I can also use XtraDB to replace InnoDB. These choices are emotional.

Address: http://blog.yi18.net/articles/2014/05/05/1399270094003.html