table size growth
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
Subject
Views
Written By
Posted
table size growth
8229
March 08, 2012 04:53AM
3172
March 09, 2012 09:45AM
3135
March 09, 2012 10:31AM
3463
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.