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.
Thanks, this seems to be the general concensus. I'll start making
some modifications this weekend.
Thanks
Ray
In article <39B7DC87.BD5EDA82@informix.com>,
Ray Canuel <rayc@informix.com> wrote:
> You don't have enough cleaners (16 for 32 lrus). I like to set one
> cleaner per LRU. You may also increase LRUS to 64, because you have
> 400MB of buffers. Lets kick the page cleaning in a little bit earlier
> than 10%. I like to clean to 1%. I also like more infrequent
> checkpoints. Lets have the delay more infrequently; you are still
> recoverable no matter how often you checkpoint. Its just that the
> recovbery time 'may' take longer. If you don't have hw/sw crashes,
then
> lets checkpoint more infrequently.
>
> CLEANERS 64 # Number of buffer cleaner processes
> LRUS 64 # Number of LRU queues
> LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaninglimit
> LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
> CKPTINTVL 1800 # Check point interval (in sec)>
> Fuzzy checkpoints in 9.2x will help your checkpoint durations a lot,
but
> you still need to tune for old-fashioned checkpoints.
>
> Ray
>
> r_pastore@my-deja.com wrote:
> >
> > Hi all,
> >
> > I've been folloowing the forum for a little while and now it's my
turn
> > to ask for configuration advise.
> > We're having checkpoints averaging in the low teens during peak
times
> > with spikes to as high as 40 or 50 seconds. I've included a copy of
the
> > onconfig file as well as the onstat -p and -d. Is anything else
needed?
> >
> > The system is SUN E10000 and we're planning to upgrade to Informix
> > 9.x soon.
> >
> > Ray
> >
> > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up
08:11:06 --
> > 825168 Kbytes
> >
<< SNIP >>
Sent via Deja.com http://www.deja.com/
Before you buy.
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.