|
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 |