Subscribe
|
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 |
Related posts:
- Choosing between MyISAM and INNODB – MySQL Storage Engines After reading at a lot of places for the...
- MySQL related file types and basic information This post covers the basic information of files that...
- Using MySQLTuner – MySQL Optimization Tool MySQLTuner is a script written in Perl that will...
good comparison