Re: Onstat -R
Hi Roger,
The onstat -R commadn give you the listing of the LRU queue's and there
status. Eachr LRU queue consists out of two parts. A free and a modified
list. The letters f and m indicate wheter it is a f(ree) or m(odified)
queue. The LRU length is the numer of pages that are modified or free (m or
f) the last column gives the total number of pages in the free and
modified queue together. The % column gives a percentage of the total that
is free or modified.
You can read/implement the output as follows.
You have 8 LRU queue's defined in your onconfig file, Total number of
buffers are 1000 so number of buffers per LRU queue is about 125 (between
124 and 126). At this moment 20-25% of your LRU queue are dirty, and
cleaning starts at 60 % and stops at 50%.
I hope this explains enough.
Greetings,
Rob Prop
Database consultant
Informa Automatisering BV (Netherlands)
rbruenin <rbruenin@concentric.net> wrote in article
<35869275.C59A93C7@concentric.net>...
> Can someone explain the onstat -R headings.. Is the percentage free or
> used. Been digging thru the texts.. examples but little explanation?
>
> INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 --
> 36320 Kbytes
>
> 8 buffer LRU queue pairs
> # f/m length % of pair total
> 0 f 98 77.8% 126
> 1 m 28 22.2%
> 2 f 98 77.8% 126
> 3 m 28 22.2%
> 4 f 95 76.0% 125
> 5 m 30 24.0%
> 6 f 92 74.2% 124
> 7 m 32 25.8%
> 8 F 95 76.0% 125
> 9 m 30 24.0%
> 10 f 92 73.6% 125
> 11 m 33 26.4%
> 12 f 96 76.8% 125
> 13 m 29 23.2%
> 14 f 95 76.6% 124
> 15 m 29 23.4%
> 239 dirty, 1000 queued, 1000 total, 1024 hash buckets, 2048 buffer size
> start clean at 60% (of pair total) dirty, or 75 buffs dirty, stop at 50%
>
>
>
> TIA Roger Bruening
> Metro King County WA
>
>