MySQL Forums
Forum List  »  Memory Storage Engine

Re: Huge heap vs performance
Posted by: Jeff C
Date: November 25, 2007 11:23PM

There currently is a bug with memory tables, where periodically deletes on btree indexes take longer than expected.... HOWEVER, I currently have my summary tables built and loaded all into memory tables (using btree) and I can handle a lot more than I could with myisam.

Some of my queries are complex and do full table scans... where the table is memory it blazes. You should really try it out.

init-file -- lets you run sql at startup... throw some sql to build your memory tables at startup.

I mentioned the bug because you may see a period where deletes aren't 0.01 seconds.

Where the memory tables have been outgrown, InnoDB fits well.

Options: ReplyQuote

Written By
October 05, 2007 02:42PM
Re: Huge heap vs performance
November 25, 2007 11:23PM
January 28, 2009 07:43AM

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.