Re: Dirty LRU exceeding the LRU_MAX of 2%
KAIO is on.
I think the application is doing a lot of work and not commiting. Would
this hold the buffers until checkpoint or until commit?
"Art S. Kagel" <kagel@bloomberg.net> on 11/10/99 05:13:07 PM
Please respond to kagel@bloomberg.net
To: Kernoal Stephens/STS/AUTOZONE
cc:
Subject: Re: Dirty LRU exceeding the LRU_MAX of 2%
If you are not running with KAIO enabled then the problem is that you only
have 2 AIO VPs.
Art S. Kagel
Kernoal.Stephens@AUTOZONE.COM wrote:
>
> Here is what I am seeing. In onstat -R the dirty q's are over 2% dirty.
> onstat -F shows all the flushers as Idle.>
> I know I have seen this in the post but cannot find it in search.
>
> Attached.
> onstat -R output
> onstat -F output> onconfig output
> IDS 7.30.UC6
> AIX 4.3.2
> 4CPU
> 512MB
>
> Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 00:28:33 --
> 141568 Kbytes
>
> 24 buffer LRU queue pairs priority levels
> # f/m pair total % of length LOW MED_LOW MED_HIGH HIGH
> 0 f 825 96.8% 799 1 304 494 0
> 1 m 3.2% 26 0 8 18 0
> 2 f 821 99.0% 813 0 344 469 0
> 3 M 1.0% 8 0 0 8 0
> 4 f 832 95.0% 790 0 294 496 0
> 5 m 5.0% 42 0 7 35 0
> 6 f 832 96.4% 802 0 271 531 0
> 7 m 3.6% 30 0 11 19 0
> 8 f 829 99.0% 821 0 272 549 0
> 9 M 1.0% 8 0 0 8 0
> 10 f 834 95.3% 795 1 318 476 0
> 11 m 4.7% 39 0 13 26 0
> 12 f 837 97.3% 814 0 283 531 0
> 13 m 2.7% 23 0 7 16 0
> 14 f 843 96.4% 813 0 343 470 0
> 15 m 3.6% 30 0 11 19 0
> 16 f 825 95.4% 787 0 313 474 0
> 17 m 4.6% 38 0 18 20 0
> 18 f 820 95.1% 780 0 299 481 0
> 19 m 4.9% 40 0 13 27 0
> 20 f 827 94.7% 783 0 282 501 0
> 21 m 5.3% 44 0 10 34 0
> 22 F 826 98.7% 815 0 330 485 0
> 23 M 1.3% 11 0 2 9 0
> 24 f 838 97.4% 816 0 368 448 0
> 25 m 2.6% 22 0 4 18 0
> 26 f 818 97.1% 794 0 329 465 0
> 27 m 2.9% 24 0 7 17 0
> 28 f 832 98.7% 821 0 307 514 0
> 29 m 1.3% 11 0 2 9 0
> 30 f 832 97.5% 811 1 367 443 0
> 31 m 2.5% 21 0 7 14 0
> 32 f 836 99.0% 828 0 312 516 0
> 33 M 1.0% 8 0 0 8 0
> 34 f 827 98.9% 818 0 335 483 0
> 35 m 1.1% 9 0 1 8 0
> 36 f 824 99.0% 816 1 300 515 0
> 37 M 1.0% 8 0 0 8 0
> 38 f 839 95.5% 801 0 318 483 0
> 39 m 4.5% 38 0 12 26 0
> 40 f 844 97.6% 824 0 356 468 0
> 41 m 2.4% 20 0 9 11 0
> 42 f 809 98.8% 799 0 314 485 0
> 43 M 1.2% 10 0 0 10 0
> 44 f 825 97.8% 807 0 312 495 0
> 45 m 2.2% 18 0 4 14 0
> 46 f 815 99.0% 807 0 342 465 0
> 47 M 1.0% 8 0 0 8 0
> 536 dirty, 19890 queued, 20000 total, 32768 hash buckets, 4096 buffer
size
> start clean at 2% (of pair total) dirty, or 16 buffs dirty, stop at 1%
>
> onstat -F
> Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 00:28:38 --> 141568 Kbytes
>
> Fg Writes LRU Writes Chunk Writes
> 0 25320 1572
>
> address flusher state data
> 400404c8 0 I 0 = 0X0
> 4004097c 1 I 0 = 0X0
> 40040e30 2 I 0 = 0X0
> 400412e4 3 I 0 = 0X0
> 40041798 4 I 0 = 0X0
> 40041c4c 5 I 0 = 0X0
> 40042100 6 I 0 = 0X0
> 400425b4 7 I 0 = 0X0
> 40042a68 8 I 0 = 0X0
> 40042f1c 9 I 0 = 0X0
> 400433d0 10 I 0 = 0X0
> 40043884 11 I 0 = 0X0
> 40043d38 12 I 0 = 0X0
> 400441ec 13 I 0 = 0X0
> 400446a0 14 I 0 = 0X0
> 40044b54 15 I 0 = 0X0
> 40045008 16 I 0 = 0X0
> 400454bc 17 I 0 = 0X0
> 40045970 18 I 0 = 0X0
> 40045e24 19 I 0 = 0X0
> 400462d8 20 I 0 = 0X0
> 4004678c 21 I 0 = 0X0
> 40046c40 22 I 0 = 0X0
> 400470f4 23 I 0 = 0X0
> states: Exit Idle Chunk Lru
>
> onconfig
> Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 00:28:23 --
> 141568 Kbytes
>
> Configuration File: /az/ifx730/gls/etc/onconfig.glssrv
>
#**************************************************************************
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.pproazo
> # Description: Informix Dynamic Server Configuration Parameters
> #
>
#**************************************************************************
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name> ROOTPATH /dev/rgls_rootdbs01
> # Path for device containing root dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 64000 # Size of root dbspace (Kbytes)>
> # Disk Mirroring Configuration Parameters
>
> MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
> MIRRORPATH # Path for device containing mirroredroot
> MIRROROFFSET 0 # Offset into mirrored device (Kbytes)>
> # Physical Log Configuration
>
> PHYSDBS physdbs # Location (dbspace) of physical log
> PHYSFILE 20