MySQL supported storage engines are,
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 |