Re: 7.31 performance problem
Embedded in the post are the main things I see.
The last one is the most important.
In article <Pine.GSO.4.30.0012191456560.18042-100000@loisto.uwasa.fi>,
<SNIP>
>
> Segment Summary:
> id key addr size ovhd class blkused
blkfree
> 41476 1381517313 c123f000 135438336 3500 R 16526 7
> (shared) 1381517313 c9369000 33562624 1132 V 4093 4
> 3077 1381517314 cb36b000 1130496 636 M 134 4
> 6 1381517315 cb47f000 1130496 636 M 131 7
> 7 1381517316 cb593000 1130496 636 M 131 7
> 11 1381517317 cc125000 33554432 1128 V 4091 5
> 12 1381517318 ce1be000 33554432 1128 V 3996 100
> 13 1381517319 d01be000 33554432 1128 V 3426 670
> 14 1381517320 d21be000 33554432 1128 V 993 3103
> Total: - - 306610176 - - 33521 3907
>
> 296112 Kbytes
>
Too many virtual memory segments. If this is constanly happening you
need to grab more virual shared memory on start up.
> Message Log File: /usr2/informix73/online_tuo.log
> 12:19:37 Logical Log 200 - Backup Completed
> 12:20:46 Checkpoint Completed: duration was 22 seconds.
> 12:22:10 Dynamically allocated new virtual shared memory segment
(size
> 32768KB)
>
> 12:41:30 Checkpoint Completed: duration was 30 seconds.
> 13:02:13 Checkpoint Completed: duration was 31 seconds.
> 13:03:24 Logical Log 201 Complete.
> 13:03:25 Logical Log 201 - Backup Started
> 13:03:28 Process exited with return code 142: /bin/sh /bin/sh -c
> /usr2/informix> 73/etc/log_full.sh 2 23 "Logical Log 201 Complete." "Logical Log 201
> Complete."
> 13:03:53 Logical Log 201 - Backup Completed
> 13:22:53 Checkpoint Completed: duration was 27 seconds.
> 13:35:40 Logical Log 202 Complete.
> 13:35:44 Process exited with return code 142: /bin/sh /bin/sh -c
> /usr2/informix> 73/etc/log_full.sh 2 23 "Logical Log 202 Complete." "Logical Log 202
> Complete."
> 13:35:44 Logical Log 202 - Backup Started
> 13:36:19 Logical Log 202 - Backup Completed
> 13:43:36 Checkpoint Completed: duration was 29 seconds.
> 13:59:04 Logical Log 203 Complete.
> 13:59:08 Logical Log 203 - Backup Started
> 13:59:09 Process exited with return code 142: /bin/sh /bin/sh -c
> /usr2/informix> 73/etc/log_full.sh 2 23 "Logical Log 203 Complete." "Logical Log 203
> Complete."
> 13:59:32 Logical Log 203 - Backup Completed>
Long checkpoints. You can probably decrease them by increasing your
LRU's and lowering your LRU_MIN/MAX. If you are interested in looking
into this, mention it, and I am sure further discussion will occur.
> onstat -c| more>
> 296112 Kbytes
>
> Configuration File: /usr2/informix73/etc/onconfig.tuo
>
#**********************************************************************
****
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.tuo
> # Description: INFORMIX-OnLine Configuration Parameters
> # - muutettu 9.12.00/LHu Informix 7.31 IDS:lle ja linkatuille
> # dataspace alueille
> # - muutettu LOCKS ja BUFFERS suuremmiksi 12.12.00 /LHu
> # (tulevat kM-dyttM-vM-vn seuraavassa alas/ylM-vsajossa
> #
>
#**********************************************************************
****
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name> ROOTPATH /usr3/informixdb/tuo/rootdbs # Path for root dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 100000 # 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 plogdbs # Location (dbspace) of physical log
> PHYSFILE 199000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 6 # Number of logical log files
> LOGSIZE 16000 # Logical log size (Kbytes)
> ##LOGSIZE 1000 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /usr2/informix73/online_tuo.log # System message log
file
> path
> CONSOLE /dev/console # System console message path
> ALARMPROGRAM /usr2/informix73/etc/log_full.sh # Alarm program path
> TBLSPACE_STATS 1>
> # System Archive Tape Device
>
> ## TAPEDEV /dev/rmt/1m # Tape device path
> TAPEDEV /dev/rmt/1m # Tape device path
> TAPEBLK 16 # Tape block size (Kbytes)
> TAPESIZE 24000000 # Maximum amount of data to put ontape
> (Kbytes)
>
> # Log Archive Tape Device
>
> ## LTAPEDEV /dev/rmt/0m # Log tape device path
> LTAPEDEV /dev/rmt/0m # Log tape device path
> LTAPEBLK 16 # Log tape block size (Kbytes)
> LTAPESIZE 8000000 # Max amount of data to put on logtape
> (Kbytes)
>
> # Optical
>
> STAGEBLOB # INFORMIX-OnLine/Optical staging
area
>
> # System Configuration
>
> SERVERNUM 2 # Unique id corresponding to a OnLine> instance
> DBSERVERNAME meritt_tuo # Name of default database server
> DBSERVERALIASES mern_tuo # List of alternate dbservernames
> # NETTYPE ipcshm,1,200,CPU # Configure poll thread(s) fornettype
> # NETTYPE soctcp,,200,NET # Configure poll thread(s) for
nettype
> NETTYPE ipcshm,3,100,CPU # Configure poll thread(s) fornettype
> NETTYPE soctcp,3,100,NET # Configure poll thread(s) fornettype
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed
> env.
> RESIDENT 0 # Forced residency flag (Yes = 1, No
= 0)
>
> MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor
> # NUMCPUVPS 2 # Number of user (cpu) vps
> NUMCPUVPS 3 # Number of user (cpu) vps
> SINGLE_CPU_VP 0 # If non-zero, limit number of cpuvps to
> one
>
> NOAGE 0 # Process aging
> AFF_SPROC 0 # Affinity start processor
> AFF_NPROCS 0 # Affinity number of processors>
> # Shared Memory Parameters
>
> # LOCKS 20000 # Maximum number of locks
> # LOCKS 60000 # Maximum number of locks
> LOCKS 80000 # Maximum number of locks> # BUFFERS 15000 # Maximum number of shared buffers
> # BUFFERS 30000 # Maximum number of shared buffers
> BUFFERS 60000 # Maximum number of shared buffers
> NUMAIOVPS # Number of IO vps>
<SNIP>
>
> MT gl