/ mozey.co / blog

mysql myisam innodb

July 1, 2013

MyISAM versus InnoDB

InnoDB… has referential integrity, while MyISAM does not.

MyISAM do not support transactions whereas InnoDB does.

When a query runs against a MyISAM table, the entire table in which it is querying will be locked.

When you run an operation in MyISAM, the changes are set; in InnoDB, those changes can be rolled back.

MyISAM offers no data integrity - Hardware failures, unclean shutdowns and canceled operations can cause the data to become corrupt.

InnoDB does not support FULLTEXT indexing until MySQL version 5.6.4

…not always the case that MyISAM is faster than InnoDB