Re: table size growth
Posted by:
Rick James
Date: March 09, 2012 09:45AM
Where are you (Cacti) getting the table size? SHOW TABLE STATUS?
Is it ENGINE=MEMORY?
Do you have "huge_pages" turned on? (Perhaps relevant only to InnoDB.)
> its allocation cost a lot of CPU
Please elaborate.
How busy are your CPU(s)? (That will lead to questioning whether to use MEMORY at all.)
What INDEX(es) do you have on the table(s)? (SHOW CREATE TABLE)
Subject
Views
Written By
Posted
7959
March 08, 2012 04:53AM
Re: table size growth
3044
March 09, 2012 09:45AM
2979
March 09, 2012 10:31AM
3326
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.