MySQL Comparison of different engines

The default engine supported by MySQL is InnoDB, and other commonly used engines include MyISAM and so on, so what's the difference between them?

First Execute

Show engines;

To view the currently supported engines for the database.

You can see that MySQL supports so many different engines, and it is obvious that the points of InnoDB deserve attention.

It supports transactions, xa,savepoints.

MyISAM is also more commonly used, although transactions are not supported, but it has higher performance for read operations.

For specific reasons, I refer to the blogs of other small partners on the Internet. (http://www.bcty365.com/content-35-5659-1.html)

InnoDB is a lot more to maintain than the MyISAM engine when making a select:

1) data block, InnoDB to cache, MyISAM only cache the index block, which also has the reduction of swap-out;
2) InnoDB addressing to map to the block, and then to the line, MyISAM record is directly the offset of the file, positioning is faster than InnoDB
3) InnoDB also need to maintain MVCC consistency; Although your scene is not, he still needs to check and maintain MVCC (multi-version Concurrency Control) multi-version concurrency control

MySQL Comparison of different engines