Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig

Posted in 1996

Martin Berns — Thu, 11 Jul 1996 10:08:20 +0000 — source: Informix-list mailing list archive (1991-1998)

Stuart Cracraft wrote: > The checkpoint always seems to occur at the interval and > not at the early 75% interval. > > Seems to me this means I could increase the checkpoint > interval some. No! This would result in longer checkpoints. All I know 300 secs is ideal for normal OLTP-Systems. You could think about decreasing, but this generates an overhead due to the Physical-Log-Flushing. Have a look on the disk-workload at checkpoint. Use both detailed iostat (I think its -x) and onstat as David Williams mentioned earlier. Only diskless databases are fast ;-) martin