MySQL Storage engine Introduction, index

Difference:

MyISAM types do not support advanced processing such as transaction processing, and InnoDB type support. The MyISAM type of table emphasizes performance, which is performed more quickly than the InnoDB type, but does not provide transactional support, while InnoDB provides transactional support for advanced database functions such as external keys.  The main difference between the two types is InnoDB Transactional and foreign key and row level locks are supported. The MyISAM does not support the. MyISAM does not support transactions or foreign keys, its advantage is fast access (InnoDB when making a select, to maintain a lot more than the MyISAM engine, and will occupy more disk space to preserve data and indexes), the integrity of the transaction does not requirements, a query, insert-based application can basically use the MyISAM engine to create tables.

MyISAM support full-text indexing

INNODB support for foreign keys

MySQL Storage engine Introduction, index