MySQL Forums
Forum List  »  Memory Storage Engine

table size growth
Posted by: Benjamin Tuffreau
Date: March 08, 2012 04:53AM

Hello all,

I've been monitoring the size of our memory tables for a few weeks now (with Cacti actually). And I noticed that the table size isn't growing linearly but from time to time.. for example, I had a 700 MB table which increased by 500 MB suddenly.

I think it may be logical since the engine is memory and its allocation cost a lot of CPU.. so MySQL probably allocates memory space by segment.

So, I'd like to know two things. First, is my theory correct? and then, how can I tune this behavior?


Thank you for your help.

Ben

Options: ReplyQuote


Subject
Views
Written By
Posted
table size growth
7929
March 08, 2012 04:53AM
3013
March 09, 2012 09:45AM
2945
March 09, 2012 10:31AM
3298
March 10, 2012 11:47AM


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.