Re: Reducing Checkpoint Duration

Posted in 1996

Juan R. Guzman — Fri, 27 Sep 1996 14:00:03 GMT — source: Informix-list mailing list archive (1991-1998)

Lin-Chuan Lee wrote: > > To reduce checkpoint duration, what are recommended strategies?? > > I have guide to performance tuning in front of me .. > so the standard 'by-the-book' .. lower LRU_Min/MAX stuff > I know.. Any other advice gained through real > experience would be greatly appreciated ! > > TIA, > -Lin In my experience, I would have to say that modifying LRU_MAX_DIRTY and LRU_MIN_DIRTY to 7 and 5 (from 50 and 40) made the most difference. My checkpoints went from a peak of close to 300 to a peak 14. On average they're 0 to 1 second.