Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / March 2004

Tip: Looking for answers? Try searching our database.

Performance is getting worst after turn on the LRUAGE

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
miyaki - 29 Mar 2004 04:40 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.