Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Kernoal Stephens — — source: Informix-list mailing list archive (1991-1998)
I recently upgraded from 7.13.UC2 to 7.22.UC1.
With 7.13.UC2 my checkpoint duration was averaging 4.5 seconds.
I used the same onconfig settings with 7.22.UC1 and my average
checkpoint duration
is 8.4 seconds.
I am not using any of the new tools yet (i.e. HPloader, ONbar, CDR).
I am 99% OLTP and have spent three months getting my checkpoint to under
5 seconds with 7.13.
What has changed to cause the checkpoint duration to increase?
Thanks
kernoals@earthlink.net
Kernoal Stephens
First Data Corporation
Tulsa
Server: 1000e, Solaris 2.5, 8CPUs, 640MB, KAIO, Raw Disks.
Dedicated Online Database Server.
ONCONFIG FILE
#####################
MULTIPROCESSOR 1
NUMCPUVPS 7
SINGLE_CPU_VP 0
NOAGE 1
AFF_SPROC 0
AFF_NPROCS 0
# Shared Memory Parameters
LOCKS 200000
BUFFERS 172032
NUMAIOVPS 2
PHYSBUFF 96
LOGBUFF 32LOGSMAX 400
CLEANERS 80
SHMBASE 0xa000000
SHMVIRTSIZE 137728
SHMADD 8192
SHMTOTAL 0
CKPTINTVL 600
LRUS 14
LRU_MAX_DIRTY 2
LRU_MIN_DIRTY 1
LTXHWM 50
LTXEHWM 60
TXTIMEOUT 0x12c
STACKSIZE 32
# Read Ahead Variables
RA_PAGES 24
RA_THRESHOLD 16DBSPACETEMP tmpspace40,tmpspace40m,tmpspace21,tmpspace21m
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 25
DS_MAX_QUERIES 50
DS_TOTAL_MEMORY 113152
DS_MAX_SCANS 1048576
DATASKIP off
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.