Online 5.03 real slow performance
Hi everyone,
I have spent a few days looking at the REAL slow performance problems
and have tried LRU_MAX-DIRTY/LRU_MIN_DIRTY,LTXHWM/LTXEHWM,
and BUFFERS adjustment. Nothing worked. The users complained that it
took them 30min to 1 hour to bring up a record, that should be less than a
few seconds, especially in the waiting line. I have included the tbconfig
and kernal parameters info to see if anyone there can correct it. Is there
something else I am missing. I have also reviewed the index issue.
Online 5.03
# Root Dbspace Configuration
ROOTNAME rootdbsROOTPATH /dev/ifmx/coris1
ROOTOFFSET 1000
ROOTSIZE 50000
# Disk Mirroring Configuration
MIRROR 0
MIRRORPATH
MIRROROFFSET 0
# Physical Log Configuration
PHYSDBS rootdbs
PHYSFILE 4000
# Logical Log Configuration
LOGFILES 10
LOGSIZE 2000
# Message Files
MSGPATH /usr/informix/onlog.coris
CONSOLE /dev/null
# Archive Tape Device
TAPEDEV /dev/rmt/1m
TAPEBLK 1024
TAPESIZE 2000000
# Logical Log Backup Tape Device
LTAPEDEV /dev/rmt/0m
LTAPEBLK 1024
LTAPESIZE 2000000
# Identification Parameters
SERVRNUM 3
DBSERVERNAME vernl_coris
# Shared Memory Parameters
RESIDENT 1USERS 50
TRANSACTIONS 100
LOCKS 90000
BUFFERS 10000TBLSPACES 240
CHUNKS 8
DBSPACES 8
PHYSBUFF 32
LOGBUFF 32LOGSMAX 20
CLEANERS 4
SHMBASE 0x0CHPTINTVL 300
LRUS 4
LRU_MAX_DIRTY 40
LRU_MIN_DIRTY 20
LTXHWM 60
LTXEHWM 75
# Machine - and Product Specific Parameters
DYNSHMSZ 0
GTRID_CMP_SZ 32
DEADLOCK_TIMEOUT 60
TXTIMEOUT 300SPINCNT 0
STAGEBLOB
# System Page Size
BUFFSIZE 2048
HP-UX O/S 9.04u model# 817 with 67 meg, 3 gig of disk capacity
reserved for database, LD-tape, HD-tape, 1 controller, and 1 CPU.
Kernel Configurable Parameters
DELAYCLOSETIMER 500
NSTREVENT 50
NSTRPUSH 16
NUM_DKHS 0
STRCTLSZ 1024
STRMSGSZ 4096
acctresume 4
acctsuspend 2
bootspinlocks 64
bufpages 0
dst 1
eqmemsize 10
file_pad 10
fs_async 0
iomemsize 40960
ipx_max_sockets 100
maxdsiz 67108864
maxfiles 60
maxfiles_lim 1024
maxssiz 8388608
maxswapchunks 256
maxtsiz 67108864
maxuprc 100
maxusers 32
maxvgs 10
minswapchunks 1
msgmap 258
msgmax 32768
msgmnb 32768
msgmni 50
msgseg 7168
msgssz 32
msgtql 256
nbuf 0
ncallout 1064
ncp_max_clients 250
ncp_max_engines 50
netisr_priority -1
netmemmax 0
nfile 670
nflocks 200
ninode 1114
nni 2
nproc 1000
npty 60
nstlbe 1024
nswapdev 10
nswapfs 10
nvt_connections 60
pfail_enabled 1
public_shlibs 1
reboot_option 1
semaem 16384
semmap 10
semmni 64
semmns 128
semmnu 30
semume 10
semvmx 32767
shmmax 67108864
shmmni 100
shmseg 12
spx_max_connections 30
spx_max_sockets 100
swapmen_on 1
swchunk 2048
timeslice 10
timezone 480
unlockable_mem 2200
The software development product is Powerbuilder