checkpoint duration
Posted in 1998
I have a serious problem with checkpoint duration which cause my posting
process to almost double in duration because of the amount of time wasted
on checkpoints. Here is a a sample of the duration take directly from the
online log file.
05:32:00 Checkpoint Completed: duration was 20 seconds.
05:34:54 Checkpoint Completed: duration was 93 seconds.
05:37:02 Checkpoint Completed: duration was 50 seconds.
05:38:40 Checkpoint Completed: duration was 13 seconds.
05:40:19 Checkpoint Completed: duration was 16 seconds.
05:43:12 Checkpoint Completed: duration was 93 seconds.
05:45:26 Checkpoint Completed: duration was 59 seconds.
05:47:06 Checkpoint Completed: duration was 14 seconds.
05:48:44 Checkpoint Completed: duration was 14 seconds.
05:51:24 Checkpoint Completed: duration was 85 seconds.
05:53:37 Checkpoint Completed: duration was 58 seconds.
05:55:16 Checkpoint Completed: duration was 14 seconds.
05:56:54 Checkpoint Completed: duration was 12 seconds.
05:59:35 Checkpoint Completed: duration was 86 seconds.
06:01:57 Checkpoint Completed: duration was 65 seconds.
06:03:42 Checkpoint Completed: duration was 14 seconds.
06:05:21 Checkpoint Completed: duration was 14 seconds.
06:08:00 Checkpoint Completed: duration was 80 seconds.
06:10:21 Checkpoint Completed: duration was 65 seconds.
06:12:05 Checkpoint Completed: duration was 15 seconds.
06:13:48 Checkpoint Completed: duration was 15 seconds.
06:16:24 Checkpoint Completed: duration was 78 seconds.
06:18:55 Checkpoint Completed: duration was 72 seconds.
06:20:31 Checkpoint Completed: duration was 14 seconds.
06:22:11 Checkpoint Completed: duration was 15 seconds.
06:24:20 Checkpoint Completed: duration was 53 seconds.
06:26:44 Checkpoint Completed: duration was 70 seconds.
06:28:25 Checkpoint Completed: duration was 31 seconds.
06:30:08 Checkpoint Completed: duration was 18 seconds.
06:31:49 Checkpoint Completed: duration was 21 seconds.
06:34:14 Checkpoint Completed: duration was 71 seconds.
06:36:16 Checkpoint Completed: duration was 47 seconds.
06:37:56 Checkpoint Completed: duration was 16 seconds.
06:39:34 Checkpoint Completed: duration was 16 seconds.
06:41:57 Checkpoint Completed: duration was 65 seconds.
06:44:20 Checkpoint Completed: duration was 69 seconds.
06:46:02 Checkpoint Completed: duration was 15 seconds.
06:47:42 Checkpoint Completed: duration was 14 seconds.
06:49:52 Checkpoint Completed: duration was 56 seconds.
06:52:48 Checkpoint Completed: duration was 104 seconds.
06:54:25 Checkpoint Completed: duration was 14 seconds.
06:56:00 Checkpoint Completed: duration was 12 seconds.
06:58:10 Checkpoint Completed: duration was 47 seconds.
07:00:41 Checkpoint Completed: duration was 76 seconds.
07:02:20 Checkpoint Completed: duration was 15 seconds.
07:04:06 Checkpoint Completed: duration was 14 seconds.
NOTE: This is a non-logging database for decision support. The long
checkpoints occur during posting of data.
The following is a listing of the parameters from the onconfig file.
PHYSFILE 75000 # Physical log file size (Kbytes)
LOCKS 200000 # Maximum number of locks
BUFFERS 200000 # Maximum number of shared
buffers(12/11/97)
NUMAIOVPS 1 # Number of IO vps (tap was 0 3/5/97)
PHYSBUFF 512 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 40 # Maximum number of logical log files
CLEANERS 120 # Number of buffer cleaner
processes(12/11/97)
SHMBASE 0x10000000 # Shared memory base address
SHMVIRTSIZE 1280000 # initial virtual shared memory segmentsize
SHMADD 128000 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 1900000
CKPTINTVL 30000 # Check point interval (in sec)
LRUS 64 # Number of LRU queues(2/20/98)
LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
Regards,
Willie Meeks