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 |