Updated: 2017-05-03 04:12:20 CST +08

MySQL

Storage Engine

Storage engines are MySQL components that handle the SQL operations for different table types–MySQL 5.6 Reference Manual

Comparison

InnoDB vs. MyISAM

MySQL MyISAM InnoDB
Full Text Search Yes > 5.6.4
Design DBMS RDBMS
Referential integrity Yes
Transactions ACID Transaction
Foreign Key Yes
Locking Table Level Row Level
select better
insert, update better
Storage No ordering in storage of data Row data stored in pages in PK order

Reference