Re: Antwort: high paging

From: Holger.VanKoll@SWISSCOM.COM
Date: Thu Nov 14 2002 - 05:17:37 EST


oracle runs here, several instances.
there is much io on sequential files > 1GB, aprox. 15mbyte/sec. box has 6gb,6cpu. so I dont gain much from filecache.

I can set maxperm even lower, still have paging:
number of valid memory pages = 1572825 maxperm=4.0% of real memory
maximum pinable=80.0% of real memory minperm=2.0% of real memory
number of file memory pages = 228461 numperm=14.5% of real memory

Is the following correct:
If numperm > maxperm, only filepages will be stolen. So there should not be paging-space usage.
If minperm > numperm > maxperm filepages will be stolen if their repage-rate is higher than those of working storage.

The problem is long responsetime to short queries. So I set minfree to 600 and the responsetime increased a bit.

Anyway, I just dont understand why paging-space is used as long there are more filepages then maxperm.

-----Original Message-----
From: fmu@OERAG.DE [mailto:fmu@OERAG.DE]
Sent: Thursday, November 14, 2002 10:41 AM
To: aix-l@Princeton.EDU
Subject: Antwort: high paging

Hi *,

      what runs on this box? A database???
I see in your vmtune-Parameters that you have maxperm and minperm on default. When on this box runs DB2 or oracle you can decrease maxperm and minperm. Reduce the values step by step. For example:
      - First maxperm -p 12 -P 50
      - observe paging
      - maxperm -p 8 -P 30
      - ....

Mit freundlichen Grüßen / With best regards,
Frank Müller

-------------------------------------------------------
| OERAG Rechtsschutzversicherungs AG |
| |
| Dipl.-Physik Ing. Frank Mueller |
| IBM Certified Specialist - AIX |
| Fachverantwortlicher UNIX Systems |
| OERAG IT , Rechenzentrum |
| |
-------------------------------------------------------
###########################################################################################

Hello,

why do I have so much paging on this box (3GB is used)

 4 27 1146219 571 0 139 156 1657 2394 0 1969 9578 4332 20 7 0 73
 4 18 1147233 613 0 162 111 3728 7464 0 2879 17201 8539 39 13 1 47
 3 22 1147683 607 0 175 143 3149 10136 0 2513 20013 6676 37 12 1 51
 2 21 1148753 592 0 136 143 3000 5212 0 2941 10902 8507 27 12 2 59

I have 71% memory used as filecache. So lrud should steal pages there, shouldn´t it?

I know that I have an io bottleneck; but much of this io goes to paging.

(0)root@sbe2622 359# /usr/samples/kernel/vmtune
vmtune: current values:
  -p -P -r -R -f -F -N -W
minperm maxperm minpgahead maxpgahead minfree maxfree pd_npages maxrandwrt
 314565 1258260 4 16 600 616 524288 0

  -M -w -k -c -b -B -u -l
-d
maxpin npswarn npskill numclust numfsbufs hd_pbuf_cnt lvm_bufcnt lrubucket defps
1258260 65536 16384 1 93 977 9 131072
1

        -s -n -S -L -g -h
sync_release_ilock nokilluid v_pinshm lgpg_regions lgpg_size strict_maxperm
        0 0 0 0 0 0

 -t
maxclient
1257440

number of valid memory pages = 1572825 maxperm=80.0% of real memory
maximum pinable=80.0% of real memory minperm=20.0% of real memory
number of file memory pages = 1164847 numperm=74.1% of real memory

number of compressed memory pages = 0 compressed=0.0% of real memory
number of client memory pages = 38 numclient=0.0% of real memory
# of remote pgs sched-pageout = 0 maxclient=79.9% of real memory

I know the pgahead/minmaxfree parameters are not default, but I see no change when setting them to default.

Regards,

Holger



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:20 EDT