Re: Online Performance Tuning
Dave, some actions you could take to reduce checkpoint (assuming everything
else is ok) time would be:
1. Reduce the value of CKPTINTVL (onconfig)
2. Reduce the value of LRU_MAX_DIRTY/LRU_MIN_DIRTY (lowest admissible values
are 2/1) (it may affect performance)
In order to determine a good value for LR_MAX/MIN, I suggest you to check
onstat -b before the checkpoint, so you can figure out a good pair. Alsocheck onstat -R
An excellent article on tuning is found at Informix TechNotes Vol. 8 Is. 3
1.998 by Art S. Kagel.
bye...
Arturo Rodr'guez Mutis
Director de Inform'tica
Melexa Ltda.
Dave McNight wrote:
> I would like to get a better handle on Online Performance tuning. We
> are running 7.3. We have a copy of "Informix-Online Performance Tuning"
> by Elizabeth Suto the first edition. I noticed that the second edition
> is available, but was published in 1996. Is there enough new information
> in the 2nd edition to make it worth while? I am looking at ordering
> "Informix Unleashed" and Joe Lumbley's new book. To recommend any
> others? Thanks ahead of time :-)) (Our checkpoints are running from 4
> to 9 seconds; it would be nice to get that down to 2-4 seconds)
>
> Dave McNight
> Bob Jones University
> Unix/Informix Administrator