MySQL Forums
Forum List  »  Memory Storage Engine

Huge heap vs performance
Posted by: Imre b
Date: October 05, 2007 02:42PM

We deploy an website that logs pager messages.

Every message is stored in a disk based table, only the last 72 hour (also) in a ENGINE=MEMORY. The Heap is always filled with about 15K rows and about 21 Mb in size. This is working pretty well with milions of queries a day.

Now we started to deploy the Mylsam table, that can contain 1,5 Milion rows. The queries are complicated and searches are slowing down.

What would happen if we install 4 GB system memory, increase the maximum heap size variable and try to copy this table to the memory typed engine at boot-time?

Is there a point where memory based tables become ineffective as they get bigger?

Imre

Options: ReplyQuote


Subject
Views
Written By
Posted
Huge heap vs performance
11555
October 05, 2007 02:42PM
6928
November 25, 2007 11:23PM
5543
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.