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
sending to informix-list
David Williams - 29 Mar 2004 20:16 GMT
> Hi all,
>
[quoted text clipped - 14 lines]
> 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)
> ----------------------------------
[quoted text clipped - 18 lines]
> http://taxes.yahoo.com/filing.html
> sending to informix-list
Art S. Kagel - 29 Mar 2004 22:08 GMT
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,
>
[quoted text clipped - 32 lines]
> http://taxes.yahoo.com/filing.html
> sending to informix-list