Re: Long check points

Posted in 2000

mars1972@my-deja.com — Thu, 13 Jan 2000 13:22:37 GMT — source: Informix-list mailing list archive (1991-1998)

In article <J_hf4.2$tC3.94@wa.nnrp.telstra.net>, "Hans Siebrand" <hans.siebrand@iluka.com> wrote: > Performance on one of the servers at my site is taking an exceptionally log > time for checkpoints, in the order of 120 to 160 seconds. > > What should I be looking for to shorten the check point length other than > decreasing CKPTINTVL. > > Hans > > Hard to tell, because I don't know what's causing it. Things to look at include CLEANERS, LRU_MIN_DIRTY, LRU_MAX_DIRTY, LRUS, PHYSBUF, and other such things like where are you trying to write the logs to? Is the drive sharing a UNIX filesystem that has somebody doing some huge disk intensive process? After you get the checkpoints down to a reasonable time, I'd recommend you take the Performance Tuning class, they spent quite a bit of time on tuning checkpoints. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.