04 Jan

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

Leave a Reply

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


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

-- Kedar Vaijanapurkar --