Re: IDS Performance Problem

Thanks a lot everyone, for your valuable comments and helping me in tuning my IDS. I will implement these changes very soon. Regards, Navaid Arif ----- Original Message ----- From: Navaid Arif To: ids@iiug.org ; classics@iiug.org ; peoplemix@iiug.org ; informix-list@iiug.org ; admin-tools@iiug.org Sent: Wednesday, February 07, 2007 10:25 PM Subject: IDS Performance Problem Dear All, I am trying to fine tune my IDS. My system configuration is mentioned below. I am worried about XXX, I have 4 GB physical memory on IBM-P5 machine. I have set BUFFERS to 8000, # of LRUs to 8, # of CLEANERS to 1, lru_min_dirty to 50% & lru_max_dirty to 60%. But still I can see bufwaits=1506913. Can anyone guide me. Further, please give me some comments, how can I improve my IDS performance. ############################################ # System Summary ############################################ 4 - CPUs currently 4 - CPUs configured 1900 - MHz CPU clock rate PowerPC_POWER5 - Processor 64 bit - Hardware 32 bit - Kernel Memory - 4 GB Dynamic - Logical Partition 5.3.0.40 ML04 - AIX Kernel Version ############################################ # result of onstat -p ############################################ IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 1 days 05:13:12 -- 83728 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 7670584 9375803 159269260 95.22 1231936 2288175 11155217 88.96 isamtot open start read write rewrite delete commit rollbk 114686642 4314954 5106448 67991599 604319 6379231 534288 75865 0 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 1251.98 429.56 353 706 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 1506913 0 32132874 0 0 211 128130 192953 ixda-RA idx-RA da-RA RA-pgsused lchwaits 609522 121903 4765665 5495588 676 ############################################ # Shared Memory Parameters in ONCONFIG file ############################################ LOCKS 8000 # Maximum number of locks NUMAIOVPS # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) #CLEANERS 1 # Number of buffer cleaner processes CLEANERS 1 # Number of buffer cleaner processes SHMBASE 0x40000000L # Shared memory base address SHMVIRTSIZE 8192 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) TXTIMEOUT 300 # Transaction timeout (in sec) STACKSIZE 64 # Read Ahead Variables RA_PAGES # Number of pages to attempt to read ahead RA_THRESHOLD # Number of pages left before next group # The following parameters are related to the buffer pool #BUFFERPOOL default,buffers=1000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 BUFFERPOOL size=4k,buffers=8000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 Regards, Navaid Arif