Difference MyISAM and InnoDB Storage Engines Mysql

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

Exit mobile version