MySQL Memory Engine Index

By default, Memory Engine uses Hash index type to index the table, which will make it pretty much unusable and very slow performer for prefix matches and range look-ups.

Changing the index type to BTree, would dramatically boost the speed and performance.

TABLE lookup
(id INT, INDEX USING BTREE (id))
ENGINE = MEMORY;

Check out this post for further information and bench marking.

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