Performance is getting worst after turn on the LRUAGE

Hi all, Due to the Bug 121515 where the LRU Queues get clogged with index pages, I have used the LRUAGE=1. Having the LRUAGE enabled, the buffer pool now being filled up by other pages (neither data pages nor index pages), and the performance is seems getting worst. Instead of being filled with high priority pages, the buffer pool predominantly contains MED_LOW pages. I was expecting to see a more even spread between MED_LOW and MED_HIGH pages. Disable the LRUAGE is not an option for me too as the buffer pool is filled up by the index pages which is also bring a performance problem to me. Is there anyone experience this problem? What can I do now? Before the change (without LRUAGE) ---------------------------------- Percentages: Data 12.16 Btree 86.52 Other 1.32 After the change (with LRUAGE=1) -------------------------------- Percentages: Data 20.29 Btree 29.90 Other 49.80 Thanks & regards, Miyaki __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html sending to informix-list

"miyaki" <lcib@yahoo.com> wrote in message news:c487qm$lbf$1@terabinaries.xmission.com... > > Hi all, > > Due to the Bug 121515 where the LRU Queues get clogged > with index pages, I have used the LRUAGE=1. Having the > LRUAGE enabled, the buffer pool now being filled up by > other pages (neither data pages nor index pages), and > the performance is seems getting worst. Instead of > being filled with high priority pages, the buffer pool > predominantly contains MED_LOW pages. I was expecting > to see a more even spread between MED_LOW and MED_HIGH > pages. > > Disable the LRUAGE is not an option for me too as the > buffer pool is filled up by the index pages which is > also bring a performance problem to me. > > Is there anyone experience this problem? What can I do > now? > - Upgrade Informix to a fixed version - Increase size of buffer cache > Before the change (without LRUAGE) > ---------------------------------- > Percentages: > Data 12.16 > Btree 86.52 > Other 1.32 > > After the change (with LRUAGE=1) > -------------------------------- > Percentages: > Data 20.29 > Btree 29.90 > Other 49.80 > > Thanks & regards, > Miyaki > > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html > sending to informix-list

On Sun, 28 Mar 2004 22:40:01 -0500, miyaki wrote: Other is usually 'unused pages'. Look at the top of the onstat -P report. On the line for address zero (0), is the value under Other very large? Those are unused buffer pages, ie no data pages have been loaded into them. There should only be a splattering of a few pages in the Other column for 'real' addresses, those are overhead pages. If the vast majority of your Other pages are for address zero, then this is not the source of your performance problems, and you could probably drop BUFFERS by 80% of the Other count without affecting performance. Art S. Kagel > Hi all, > > Due to the Bug 121515 where the LRU Queues get clogged with index pages, I > have used the LRUAGE=1. Having the LRUAGE enabled, the buffer pool now being > filled up by other pages (neither data pages nor index pages), and the > performance is seems getting worst. Instead of being filled with high > priority pages, the buffer pool predominantly contains MED_LOW pages. I was > expecting to see a more even spread between MED_LOW and MED_HIGH pages. > > Disable the LRUAGE is not an option for me too as the buffer pool is filled > up by the index pages which is also bring a performance problem to me. > > Is there anyone experience this problem? What can I do now? > > Before the change (without LRUAGE) > ---------------------------------- > Percentages: > Data 12.16 > Btree 86.52 > Other 1.32 > > After the change (with LRUAGE=1) > -------------------------------- > Percentages: > Data 20.29 > Btree 29.90 > Other 49.80 > > Thanks & regards, > Miyaki > > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html > sending to informix-list