MyISAM | InnoDB |
| Default since version 3.23 | Relatively newer |
| Files storage: FRM: table definition, MYD: Actual Data MYI: Index File | FRM: table definition .ibd file (concept of table space) or single huge .ibdataX |
| No transation, Foreign key | ACID Transactions, Foreign key, Rollback |
| Low disk and memory utilisation | Relatively high storage requirements (Almost 3 times disk space) |
| Non clustered indexing | Clustered indexing for Primary key |
| Table level locking | Row level locking |
| Fulltext Indexes, Merge tables, Compressed tables. | Not available |
| GIS, RTREE indexes | Not available |
| Not avalable | HASH lookups |
Kedar