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.