Difference between MySQL storage engines InnoDB and MyISAM

MySQL supported storage engines are,

  • MyISAM
  • InnoDB
  • Memory
  • CSV
  • Merge
  • Archive
  • Federated
  • Blackhole

And, Most commonly using storage engines are InnoDB and MyISAM. Let see the Difference between them in the following table,
 

InnoDB MyISAM
Speed on select Speed on insert or update
Row level locking Table level locking
Better - repair on crashes Worst - repair on crashes
ACID Transaction Do not support Transaction
Implements Forign key Do not have Forign key
Better handling huge volume of data Worst handling huge volume of data
Can Rollback Cannot Rollback

MySQL MyISAM InnoDB Comparision Posted on 2016-08-26 08:20:07