Difference Between InnoDB and MyISAM

Difference between InnoDB and MyIsam

InnoDB MyISAM
Default engine from version 5.5 Default engine before version 5.5
ACID* Complaint (Atomicity, Consistency, Isolation, Durability)) Not ACID Complaint
Transactional (Rollback, Commit) Non-Transactional
Row Level Locking Table level Locking
Row data stored in pages as per primary keyorders No Particular order for data stored
Support foreign key Does not support relationship constraint
No full-text search Full-text search
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

Blog at WordPress.com.

Up ↑

Little Local

littlelocal

playwithlifeorg

4 out of 5 dentists recommend this WordPress.com site

Crafsol Technology Solutions

Crafting Enterprise Services

Rahul Rajoria

Sr. Software Developer(Looking for a opportunity)

system care

best laptop repairing center in indore

%d bloggers like this: