RE: IDS Performance Problem

Hi Navaid. How about the following. 1. Change priority btscanner. onmode -C high2. Add btscanner onmode -C start If you re-bounce IDS, btscanner will set default. Regards. -- Tsutomu Ogiwara from Tokyo Japan. >From: "Navaid Arif" <navaid.arif@access.net.pk> >To: <ids@iiug.org>, <classics@iiug.org>, <peoplemix@iiug.org>,<informix-list@iiug.org>, <admin-tools@iiug.org> >Subject: IDS Performance Problem >Date: Wed, 7 Feb 2007 22:25:28 +0500 > >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 >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ 北海道から沖縄まで選りすぐりのラーメン1000杯が大集合 http://promotion.live.jp/searchmap/

On Feb 7, 8:44 pm, "Ogiwara Tsutomu" <tsutomu_ogiw...@hotmail.com> wrote: > > >From: "Navaid Arif" <navaid.a...@access.net.pk> > >To: <i...@iiug.org>, <class...@iiug.org>, > > <people...@iiug.org>,<informix-l...@iiug.org>, <admin-to...@iiug.org>>Subject: IDS Performance Problem > >Date: Wed, 7 Feb 2007 22:25:28 +0500 > > 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. > Is this supposed to be an exercise for Informix admin 101 ? This isn't fine tuning. This is basic stuff. You have 4GB of physical memory, and yet you allocate only 8000 4K buffers (32MB memory). In addition, you set dirty levels to 60%/50%. No wonder you get a lot of bufwaits. Bufwaits mean that threads are waiting for clean buffers, and you didn't allocate a lot, nor do you clean them often. Increase the number of buffers and/or lower the dirty levels (and don't forget to match shared memory segment size accordingly). Zachi