RE: INFORMIX and utilization of system resources on HP-UX 10.20
You are probabli very low on buffers
> -----Original Message-----
> From: Andrzej Piotrowski [SMTP:a.piotrowski@apexim.com.pl]
> Sent: Thursday, April 08, 1999 12:28 PM
> To: informix-list@iiug.org
> Subject: INFORMIX and utilization of system resources on HP-UX 10.20
>
> This is a multi-part message in MIME format.
> --------------1BDF045F91B4032E8276E3E0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> I have a new double HP9000 system with MC/ServiceGuard, and I,ve
> installed IDS 7.3 UC7 on this cluster. At the beginning I've notticed,
> that database is running rather slowly (thats mean it is unacceptable
> slow ;-). I've carefully read release notes for IDS 7.3 and I had tuned
> kernel as it was described in this document, but the situation was the
> same. For instance I am doing dbexport & dbimport and there is onperf
> runnig at background, which monitors cpu utilisation (machine has 2
> CPU). The diagram is awfully shaterred. In 2-3 sec. periods CPU
> utilization can change from 0% to 80% and back to 0% and it is regular.
> On the other way average utilization measured in longer periods isn't
> constant, but becomes smaller and smaller. I have already set NOAGE
> parameter to 1 in $ONCONFIG.
>
> Anybody knows what is going on? I'm not sure, if I should search the
> solution at the HP-UX kernel or IDS 7.3 tuning.
>
> I'm attching my onconfig file.
> Thanks for any advice.
> --------------1BDF045F91B4032E8276E3E0
> Content-Type: text/plain; charset=us-ascii;
> name="onconfig"
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline;
> filename="onconfig"
>
> #*************************************************************************
> *
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: INFORMIX-OnLine Configuration Parameters
> #
> #*************************************************************************
> *
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /dev/vg01/rrootdbs # Path for device containing root> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 50000 # 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 plogdbs # Location (dbspace) of physical log
> PHYSFILE 1024000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 5 # Number of logical log files
> LOGSIZE 60000 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /usr/informix/online.log # System message log file path
> CONSOLE /usr/informix/console # System console message path
> ALARMPROGRAM /usr/informix/log_full.sh # Alarm program path
>
> # System Archive Tape Device
>
> TAPEDEV /baan/worek/tapedev # Tape device path
> TAPEBLK 512 # Tape block size (Kbytes)
> TAPESIZE 25165824 # Maximum amount of data to put on tape
> (Kbytes)>
> # Log Archive Tape Device
>
> LTAPEDEV /baan/worek/ltapedev # Log tape device path
> LTAPEBLK 512 # Log tape block size (Kbytes)
> LTAPESIZE 25165824 # Max amount of data to put on log tape
> (Kbytes)>
> # Optical
>
> STAGEBLOB # INFORMIX-OnLine/Optical staging area
>
> # System Configuration
>
> SERVERNUM 0 # Unique id corresponding to a OnLine> instance
> DBSERVERNAME baan # Name of default database server
> DBSERVERALIASES # List of alternate dbservernames
> NETTYPE ipcshm,1,300,CPU # Configure poll thread(s) for nettype
> NETTYPE soctcp,1,300,NET # Configure poll thread(s) for nettype
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed
> env.
> RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
>
> MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor
> NUMCPUVPS 1 # Number of user (cpu) vps
> SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to> one
>
> NOAGE 1 # Process aging
> AFF_SPROC 2 # Affinity start processor
> AFF_NPROCS 2 # Affinity number of processors>
> # Shared Memory Parameters
>
> LOCKS 1000000 # Maximum number of locks
> BUFFERS 40000 # Maximum number of shared buffers
> NUMAIOVPS 1 # Number of IO vps
> PHYSBUFF 32 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 6 # Maximum number of logical log files
> CLEANERS 8 # Number of buffer cleaner processes
> SHMBASE 0x0 # Shared memory base address
> SHMVIRTSIZE 16384 # initial virtual shared memory segment> size
> SHMADD 16384 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes).
> 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 4 # Number of LRU queues
> LRU_MAX_DIRTY 25 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 15 # LRU percent dirty end cleaning limit
> LTXHWM 50 # Long transaction high water mark> percentage
> LTXEHWM 60 # Long transaction high water mark
> (exclusive)
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)>
> # System Page Size
> # BUFFSIZE - OnLine no longer supports this configuration parameter.
> # To determine the page size used by OnLine on your platform
> # see the last line of output from the command, 'onstat -b'.
>
>
> # Recovery Variables
> # OFF_RECVRY_THREADS:
> # Number of parallel worker threads during fast recovery or an offline
> restore.
> # ON_RECVRY_THREADS:
> # Number of parallel worker threads during an online restore.
>
> OFF_RECVRY_THREADS 10 # Default number of offline worker> threads
> ON_RECVRY_THREADS 1 # Default number of online worker> threads
>
> # Data Replication Variables
> # DRAUTO: 0 manual, 1 retain type, 2 reverse type
> DRAUTO 0 # DR automatic switchover
> DRINTERVAL 30 # DR max time between DR buffer flushes
> (in sec)
> DRTIMEOUT 30 # DR network timeout (in sec)> DRLOSTFOUND /usr/informix/etc/dr.lostfound # DR lost+found file path
>
> # CDR Variables
> CDR_LOGBUFFERS 2