Features of the MyISAM engine and the InnoDB engine

With the continuous update of MySQL, MySQL commonly used two storage engine MyISAM and InnoDB are also constantly changing, the following summarizes the characteristics of these two storage engines, friends can according to business needs, choose the right storage engine. ^.^

Features of the MyISAM engine:

1, heap organization table;

2, do not support business;

3, data files and index files are stored separately;

4, support full-text indexing;

5, the primary key index and the level two index are exactly the same as the data structure of B + tree, only if the unique difference (primary key and unique index has a unique property, other normal indexes do not have unique properties.) B + Tree leaf nodes are stored in row pointer that point to the rows of records;

6, there are special counters record the current number of records;

7, does not support crash recovery;

8, the index file is easily damaged;

Features of the InnoDB engine:

1, index organization table;

2, support business;

3. Data files and index files are stored in the same table space;

4, before 5.6, full-text indexing is not supported;

5, the primary key and the level two index data structure is the B + tree, but the leaf node stores the key value is different (the leaf node of the primary key stores the entire row of data, therefore also known as the clustered index; and the leaf node of the two-level index stores the key value of the primary key)

6, support crash recovery;

7, the same data volume, InnoDB table space file size is about MyISAM engine 1.5~2 times;

To learn more about the performance of MyISAM and InnoDB, refer to the Percona http://www.percona.com/blog/2007/01/08/ innodb-vs-myisam-vs-falcon-benchmarks-part-1/

Features of the MyISAM engine and the InnoDB engine