Difference MyISAM and InnoDB Storage Engines Mysql



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

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Petition – Help saving MySQL – II

And I looked back and thought of updating this post… Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview,…
View Post