Comparison of MySQL database engine MyISAM and InnoDB

Storage Engine
MyISAM InnoDB, most commonly used
can be configured
Default-storage-engine=innodb Configuring the default engine

MyISAM These 3 together structure, data, index (a table consisting of these 3)

Engine MyISAM
Engine InnoDB
1. Save the file in different ways
MYISAM:XXX.FRM structure
Xxx.myd data
Xxx.myi Index
InnoDB: A table one file
XXX.FRM structure
So the InnoDB table uses the same INNODB storage table space to save data and indexes

Type query speed, Advantage
MyISAM blocks (indexes and data are saved separately, so the index can be compressed, so the query block) is queried and inserted (table-level lock)
InnoDB Slow Update and delete (row-level lock) so, high concurrency

Comparison of MySQL database engine MyISAM and InnoDB