MySQL Forums
Forum List  »  Memory Storage Engine

Memory Engine Performance
Posted by: Saurabh Gupta
Date: January 28, 2009 07:51AM

Hi,
We have developed a B2C portal which is backed by MySQL. We have used caching at multiple levels. Since the request is widely varied, we are still left with approximately 60% requests not being served from cache.

We want to use memory engine for some big tables with approximately 2M records. Mostly these tables are used for read operations i.e. Select queries.

Would using memory engine make any significance difference?

I am looking at performance statistics of the memory engine over other storage engine in MySQL i.e. MyISAM, InnoDB.

Some people have not found the memory engine very effective in terms of performance. They find it only 10%-12% faster.
http://forums.mysql.com/read.php?24,191915,191915
http://blog.teksol.info/2008/12/12/mysqls-memory-engine-barely-faster-than-innodbs.html

Thanks,
Saurabh

Options: ReplyQuote


Subject
Views
Written By
Posted
Memory Engine Performance
18548
January 28, 2009 07:51AM
8610
May 15, 2009 01:41AM
8648
May 21, 2009 04:19AM
7507
May 22, 2009 05:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.