Re: onconfig advise please

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.