Wednesday, 15 April 2015

What is difference between innodb and myIsam?

Ans:
1) InnoDB implements row-level lock while MyISAM can do only a table-level lock.
2) InnoDB provides better crash recovery compared to MyISAM.
3) InnoDB doesn’t have FULLTEXT search indexes, whereas MyISAM does.
4) InnoDB supports transactions, foreign keys and relationship constraints while MyISAM does not.

No comments:

Post a Comment