Three Major Difference:
- First major difference I see is that InnoDB implements row-level lock while MyISAM can do only a table-level lock.
- You will find better crash recovery in InnoDB. However, it doesn’t have FULLTEXT search indexes, as does MyISAM.
- InnoDB also implements transactions, foreign keys and relationship constraints while MyISAM does not.
