IDS/BaaN performance issues
Posted in 1999
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 nameROOTPATH /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 mirroredroot
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 OnLineinstance
DBSERVERNAME baan # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No =
0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor
NUMCPUVPS 3 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one
NOAGE 1 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 150000 # Maximum number of locks
BUFFERS 100000 # Maximum number of shared buffers
NUMAIOVPS 3 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 100 # Maximum number of logical log files
CLEANERS 12 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 200000 # initial virtual shared memory segmentsize
SHMADD 8192 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 16 # Number of LRU queues (increased from
8)
LRU_MAX_DIRTY 2