Ree: long checkpoints

thanks for the reply. I am curious why I see such low numbers on MIN/MAX, with many people setting them to 1/2 and apparently 9.4 giving the Admin the ability to even go to a decimal setting! (We are going to try lowering ours to 10/15 to see if that will make enough of a difference - I am hoping that is enough to see a change.) Is the idea to fill up very little and have the checkpoint be very short? Can someone explain further? "Mark Denham" <mkdenham@attbi.com> wrote in message news:<bbo2qu$o0p$1@terabinaries.xmission.com>... > Lower your LRU min and max for starters. That will reduce the volume of > dirty pages that have to be written out as part of the checkpoint process. I > would suggest you try 4/2 as a starting point. > > Mark > > ----- Original Message ----- > From: "tomL" <schmotom@yahoo.com> > To: <informix-list@iiug.org> > Sent: Thursday, June 05, 2003 11:53 > Subject: long checkpoints > > > > hello all, > > we have recently experienced checkpoints that are lasting 20-30 > > seconds that were previously 5-8 seconds. > > I am looking at the CONFIG file to see if something could be improved. > > We are on HP-UNIX box (11.00)(2 proc box) with Informix 9.21 HC-5. > > > > BUFFERS 250000 # Maximum number of shared buffers > > NUMAIOVPS 2 # Number of IO vps > > PHYSBUFF 32 # Physical log buffer size (Kbytes) > > LOGBUFF 32 # Logical log buffer size (Kbytes)> > LOGSMAX 40 # Maximum number of logical log files > > CLEANERS 50 # Number of buffer cleaner processes > > LRUS 50 # Number of LRU queues > > LRU_MAX_DIRTY 30 # LRU percent dirty begin cleaning> > limit > > LRU_MIN_DIRTY 25 # LRU percent dirty end cleaning limit > > CKPTINTVL 300 # Check point interval (in sec) > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> > multi-processor > > NUMCPUVPS 2 # Number of user (cpu) vps > > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> > to one > > LTXHWM 50 # Long transaction high water mark> > percentage > > LTXEHWM 60 # Long transaction high water mark > > (exclusive)> > > > KAIO is enabled. > > > > thanks for any help......