MySQL: The Main difference between InnoDB and MyISAM

InnoDB:

  • InnoDB implements row-level.
  • InnoDB has better crash recovery option.
  • FULLTEXT Search indexes doesn’t support until v5.6.
  • Implemented transactions, foreign keys and relationship constraints.
  • ACID Properties is supported.
  • It has Buffer Pool to cache data and index pages.
  • You can take backup of InnoDB tables using just a snapshot of the filesystem.

MyISAM:

  • MyISAM can do only a table-level lock.
  • FULLTEXT Search is supported.
  • The main mechanism used is the key cache. It only caches index pages from .MYI files.
  • ACID Properties is not supported.
  • COUNT(*) performance is very fast.
  • Supported high level table compression.
  • You require mysqldump to take backup of MyIsam table.
Anvesh Patel

Leave a Reply

3 Comments on "MySQL: The Main difference between InnoDB and MyISAM"

Notify of
avatar
Sort by:   newest | oldest | most voted
christ
Guest

Awesome blog! Do you have any helpful hints forr aspiring writers?
I’m hoping to start my own website soon but I’m a little lost
on everything. Would you advise starting with a free platform
like WordPress or go for a paid option? There are so many choices out there that I’m completely confused ..
Any tips? Bless you!

Elangovan
Guest
wpDiscuz