Tuesday, July 30, 2013

Difference between InnoDB and MyISAM?

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.

1 comment:

  1. Nice 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.