MySQL Forums
Forum List  »  Memory Storage Engine

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
7439
March 08, 2012 04:53AM
Re: table size growth
2692
March 09, 2012 09:45AM
2651
March 09, 2012 10:31AM
2914
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.