RE: onstat -R / LRUAGE -- Priority downgrades

Posted in 2006

Ford, Andrew G — Tue, 19 Sep 2006 11:10:54 -0400 — source: Usenet: comp.databases.informix

-----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Danny Sent: Tuesday, September 19, 2006 9:31 AM To: informix-list@iiug.org Subject: onstat -R / LRUAGE -- Priority downgrades Folks-- Not sure what/why exactly I am seeing a very high value under 'prioriy downgrades".. Anybody has seen this or facing this one. Any help is appreciated. I've turned on LRUAGE=1 onstat -R|tail -364 dirty, 174969 queued, 175000 total, 262144 hash buckets, 2048 buffer size start clean at 2% (of pair total) dirty, or 54 buffs dirty, stop at 1% 47062400 priority downgrades, 0 priority upgrades -------Here is the onstat -P output onstat -P|tail -5Percentages: Data 93.51 Btree 3.89 Other 2.60 ---- Version 7.31.FD5 / HPUX-11i --Danny _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Setting LRUAGE will cause priority downgrades. Do you have LRUAGE set because index pages were hogging your buffers? Andrew

↪ replying to Ford, Andrew G

Danny — 19 Sep 2006 08:52:17 -0700 — source: Usenet: comp.databases.informix

Ford, Andrew G wrote: > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of Danny > Sent: Tuesday, September 19, 2006 9:31 AM > To: informix-list@iiug.org > Subject: onstat -R / LRUAGE -- Priority downgrades > > > Folks-- > > Not sure what/why exactly I am seeing a very high value under 'prioriy > downgrades".. > Anybody has seen this or facing this one. Any help is appreciated. > > I've turned on LRUAGE=1 > > onstat -R|tail -3> 64 dirty, 174969 queued, 175000 total, 262144 hash buckets, 2048 buffer > size > start clean at 2% (of pair total) dirty, or 54 buffs dirty, stop at 1% > 47062400 priority downgrades, 0 priority upgrades > > -------Here is the onstat -P output > onstat -P|tail -5> Percentages: > Data 93.51 > Btree 3.89 > Other 2.60 > ---- > Version 7.31.FD5 / HPUX-11i > --Danny > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > > Setting LRUAGE will cause priority downgrades. Do you have LRUAGE set > because index pages were hogging your buffers? YES... we do have LRUAGE set .. So this high value "piority downgrades" can be ignored.. thanks > > Andrew

Related threads

Glossary

onstat