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.
ReplyDeleteNice Article !
Really this will help to people of MySQL Server Community.
I have also prepared small note on this, the main difference between innodb and myisam of MySQL Server.
http://www.dbrnd.com/2015/11/mysql-the-main-difference-between-innodb-and-myisam/