Re: IDS/BaaN performance issues

Move your TCP and MUX listeners (NETTYPE) to 3 NET VPS each and change the shared memory listener to use all 3 CPU VPs and the load will be balanced better. If you want to know why scan for a recent post in which I elaborated on this load balance issue and the role of the NETTYPE options or read my tuning article in Informix TechNotes Volume 8, Issue 3. Also your server has read 12Million pages into the buffer cache in 14 hours of uptime, 100,000 buffers is just NOT enough. I'd guess you will see best performance with about 600,000 buffers, start by doubling to 200,000 and see what happens. You should have CLEANER >= LRUS, increase to 16 to match LRUS to improve flush performance for all those new buffers. Art S. Kagel russ_kahler@andersonsinc.com wrote: > > Greetings, > > We are running IDS version 7.30.uc5 on a 4-way HP 9000 K-250 with 2.25 > GB of memory, and HP-UX 10.20. We are also a BaaN installation running > b40c4 with about 20 production users, and 25 test users. > > We have been experiencing performance difficulties with BaaN, and I have > modified our onconfig to try to adjust for this. I recently added memory > to bring it up to 2.25 GB, and also adjusted the SHMVIRTSIZE,BUFFERS,and > CLEANERS to try and make better use of the added memory. What I saw > however in onstat -p was a decline in both read cache % and write cache > %. Are buffers still an issue here? > > Also, where I do an onstat -g glo, it seems as if the virtual processors > are not balancing the loads between them, as one processor seems to be > doing 2X the work of the other two. I am able to confirm this by running > glance- as the oninit processes are using only 20 -40% of the CPU, while > the rest sit idle. Informix technical support says this is normal, but > that just doesn't seem right. > > Thanks for any help you can give. Here is the info: > > onstat -p :> > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 14:20:53 -- > 421160 K > bytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 7536503 12194535 78503378 90.40 111959 163941 661937 83.09 > > isamtot open start read write rewrite delete commit > rollbk > 36612289 443031 1916363 29251116 68550 113615 19749 51768 > 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 6499.98 1867.23 69 344 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 526588 0 30721288 0 0 15 8138 13609 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 4436892 11 1311 4423770 3720 > > onstat -g glo> > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 14:22:21 -- > 421160 K > bytes > > MT global info: > sessions threads vps lngspins > 62 95 10 0 > > sched calls thread switches yield 0 yield n yield > forever > total: 30482118 28283418 2493985 135177 13918422 > per sec: 0 0 0 0 0 > > Virtual processor summary: > class vps usercpu syscpu total > cpu 3 6612.03 1857.59 8469.62 > aio 3 2.15 7.43 9.58 > lio 1 0.76 2.22 2.98 > pio 1 0.71 2.48 3.19 > adm 1 4.06 9.73 13.79 > msc 1 1.58 0.50 2.08 > total 10 6621.29 1879.95 8501.24 > > Individual virtual processors: > vp pid class usercpu syscpu total > 1 2511 cpu 1023.73 410.28 1434.01 > 2 2512 adm 4.06 9.73 13.79 > 3 2513 cpu 3803.59 1070.54 4874.13 > 4 2514 cpu 1784.71 376.77 2161.48 > 5 2515 lio 0.76 2.22 2.98 > 6 2516 pio 0.71 2.48 3.19 > 7 2517 aio 0.79 2.68 3.47 > 8 2518 msc 1.58 0.50 2.08 > 9 2519 aio 0.69 2.57 3.26 > 10 2520 aio 0.67 2.18 2.85 > tot 6621.29 1879.95 8501.24 > > onconfig file > > # Root Dbspace Configuration > > ROOTNAME rootdbs # Root dbspace name> ROOTPATH /dev/informix/baan/rootdbs > # Path for device containing root > dbspace > ROOTOFFSET 0 # Offset of root dbspace into device > (Kbytes) > ROOTSIZE 500000 # Size of root dbspace (Kbytes)> > # Disk Mirroring Configuration Parameters > > MIRROR 0 # Mirroring flag (Yes = 1, No = 0) > MIRRORPATH # Path for device containing mirrored> root > MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> > # Physical Log Configuration > > PHYSDBS rootdbs # Location (dbspace) of physical log > PHYSFILE 200000 # Physical log file size (Kbytes)> > # Logical Log Configuration > > LOGFILES 30 # Number of logical log files > LOGSIZE 1000 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /informix/logs/online_prod.log # System message log file > path > CONSOLE /informix/logs/console_prod.log # System console message > path > ALARMPROGRAM /informix/etc/no_log.sh # Alarm program path > #ALARMPROGRAM /informix/etc/log_full.sh # Alarm program path > > # System Archive Tape Device > > TAPEDEV /dev/rmt/3m # Tape device path > TAPEBLK 2048 # Tape block size (Kbytes) > TAPESIZE 20000000 # Maximum amount of data to put on tape > (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /dev/rmt/1m # Log tape device path> #LTAPEDEV /dev/null # Log tape device path > LTAPEBLK 2048 # Log tape block size (Kbytes) > LTAPESIZE 4000000 # Max amount of data to put on log tape > (Kbytes)> > # Optical > > STAGEBLOB # INFORMIX-OnLine/Optical staging area > > # System Configuration > > SERVERNUM 1 # Unique id corresponding to a OnLine> instance > DBSERVERNAME baan # Name of default database server > DBSERVERALIASES # List of alternate dbservernames > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> distributed env. > RESIDENT 1 # Forced residency flag (Yes = 1, No = > 0) > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor > NUMCPUVPS 3 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> to one > > NOAGE 1 # Process aging > AFF_SPROC 0