MySQL Forums
Forum List  »  InnoDB

InnoDB on RHE3 buffer pool swapped out..
Posted by: Andrew Mcleod
Date: April 25, 2005 10:35AM

Hi,

I would like to be able to run InnoDB with a high buffer pool size (such as 768MB) where my total database sizes are similar to this size, but after a few minutes the whole pool seems to get swapped out, thus causing any performance improvements from using a high buffer pool size to be obsolete..

I've attempted to research more on this subject, and found that people go as far to suggesting to disable swap space completely, but I really prefer not to do this...

I've experimented with the memlock options but that only results in the server inevitably crashing quite quickly, I suspect the memlock function isn't suitable for Linux :-)

...

So.. any suggestions would be greatly appreciated.

Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB on RHE3 buffer pool swapped out..
3088
April 25, 2005 10:35AM


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.