Re: Checkpoint duration increase with 7.22.UC1
In article <5kq94e$o4q@cssun.mathcs.emory.edu>, Kernoal Stephens
<kernoals@earthlink.net> writes
>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
Part of - where is the rest of it E.g. OPTCOMPIND?
Check OPTCOMPIND = 0 first, we upgraded from 7.12 to 7.13 and found
oPTCOMPIND got set back to 2 (the default) even though
a) Nothing else in $ONCONFIG changed
b) we didn't get asked for /informed of the change.
>#####################
>
>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 32>LOGSMAX 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 16>
>DBSPACETEMP 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>
--
David Williams