Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
> 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!
↪ replying to sumGirl
David Williams — — source: Usenet: comp.databases.informix
"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!
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.