Difference Between InnoDB and MyISAM

Difference between InnoDB and 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

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 )

Connecting to %s

Blog at WordPress.com.

Up ↑

Solar Association

Solar Energy – Today's resource for a brighter tomorrow


4 out of 5 dentists recommend this WordPress.com site

Rahul Rajoria

Sr. Software Developer

%d bloggers like this: