Re: memory cache problem

[Christopher McCrory <chrismcc pricegrabber com>]

On Wed, 2004-09-15 at 08:59, John Haxby wrote:
> Mark Dadgar wrote:
> 
> > This really, really sucks.  And hopefully will get fixed one of these 
> > days, as it's going to be a real problem soon when I go into 
> > production.  Paging out the SQL server is a very bad idea.
> 
> 
> Ahh.   I see.  I do remember something in the archives about tuning the 
> cache parameters for precisely this reason -- another poster (sorry, the 
> message has been deleted) suggested doing exactly the same thing.   I 
> agree that you don't want the SQL server paging out even if it appears 
> to be idle.   I wish I could remember something else about the tuning, 
> but there was definitely something about SQL servers and cache tuning on 
> the list a little while back.
> 


/etc/sysctl.conf
# https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=89226
vm.pagecache = 1 10 20





> jch
> 
> 
> --
> Taroon-list mailing list
> Taroon-list redhat com
> http://www.redhat.com/mailman/listinfo/taroon-list
-- 
Christopher McCrory
 "The guy that keeps the servers running"
 
chrismcc pricegrabber com
 http://www.pricegrabber.com
 
Let's face it, there's no Hollow Earth, no robots, and
no 'mute rays.' And even if there were, waxed paper is
no defense.  I tried it.  Only tinfoil works.