Re: BUFFERS! Arghhh!!! Please help before I do something silly!
Posted in 2004
Topics: Performance & Tuning, Storage & Space Management, Logging & Checkpoints
> CLEANERS and LRUS seem to be sufficient without more info. How many chunks > do you have? Set CLEANERS to at least 1.5*#chunks plus a few, if the 84 is > more than that then leave it. Looks like you're running 9.4, try reducing > LRU_MAX/MIN_DIRTY to 1.0 and 0.5 or 1.0 & 0 that alone should cut checkpoint > time in half. > Art S. Kagel Thanks again Art. I have 137 chunks, so about 210? I was thinking that there was a rule that when you raise the number of CLEANERS, you should also up the LRUs? I likely am way off base there, I dont know. I will tweak the CLEANERS and then if needed lower my MAX/MINs...which is another confusing subject based on the 9.4 Performance Guide. Thanks for all the wisdom!
"sumGirl" <emebohw@netscape.net> wrote in message
news:a5e13cff.0404290943.71aa323@posting.google.com...
> > CLEANERS and LRUS seem to be sufficient without more info. How many
chunks
> > do you have? Set CLEANERS to at least 1.5*#chunks plus a few, if the 84
is
> > more than that then leave it. Looks like you're running 9.4, try
reducing
> > LRU_MAX/MIN_DIRTY to 1.0 and 0.5 or 1.0 & 0 that alone should cut
checkpoint
> > time in half.
> > Art S. Kagel
>
> Thanks again Art. I have 137 chunks, so about 210? I was thinking that
> there was a rule that when you raise the number of CLEANERS, you
> should also up the LRUs? I likely am way off base there, I dont know.
>
> I will tweak the CLEANERS and then if needed lower my MAX/MINs...which
> is another confusing subject based on the 9.4 Performance Guide.
>
CLEANERS 127
LRU 127
After a while look at onstat -u and the informix ones at the top are the
page cleaners. Check if
any have all 0's against them and adjust accordingly allowing for futures
peaks in load.
> Thanks for all the wisdom!