MySQL architecture using pluggable storage engines

mysqlengines.jpg

Comparison Of Engines

 

MyISAM InnoDB MEMORY NDB

Multi-statement transactions, ROLLBACK

X

X

Foreign key constraints

X

Locking level

table

row

table

row

BTREE indexes

X

X

X

FULLTEXT indexes

X

HASH lookups

X

X

X

Other in-memory tree-based index

4.1.0

GIS, RTREE indexes

4.1.0

Unicode

4.1.0

4.1.2

Merge (union views)

X

Compress read-only storage

X

Relative disk use

low

high

low

Relative memory use

low

high

low

high

You may see the engines in MySQL using:

                                            SHOW ENGINES; 

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s