Common MySQL Database engine--myisam and InnoDB differences

Background:

Yesterday when the project, found that the use of transactions after the rollback, and later the database engine from the MyISAM replaced InnoDB after decisive good, such as:

Body:

MyISAM and InnoDB are common MySQL database engines, and their differences are as follows:

Database engine	Scope of application	Performance	Transaction	FOREIGN key	Data corruption recovery
MyISAM	Suitable for frequent queries	High	X	X	X
InnoDB	Suitable for frequent modifications	In	√	√	√

Note: MyISAM is MySQL's ISAM extended format and the default database engine

Resources:

In-depth analysis of the MySQL Database engine introduction, differentiation, creation, and performance testing

Http://www.jb51.net/article/38004.htm

Common MySQL Database engine--myisam and InnoDB differences