What are the main differences between InnoDB and MyISAM

InnoDB has row-level locking, MyISAM can only do full table-level locking. 

InnoDB has better crash recovery. 

MyISAM has FULLTEXT search indexes, InnoDB did not until MySQL 5.6 (Feb 2013).

InnoDB implements transactions, for foreign  keys and relationship constraints, MyISAM does not

No comments:

Post a Comment