08:49:49 Maximum server connections 5
08:54:49 Fuzzy Checkpoint Completed: duration was 0 seconds, 22 buffers not flushed,
timestamp: 852692.
08:54:49 Checkpoint loguniq 8, logpos 0x159a148, timestamp: 852692
08:54:49 Maximum server connections 7
08:59:49 Fuzzy Checkpoint Completed: duration was 0 seconds, 23 buffers not flushed,
timestamp: 855072.
08:59:49 Checkpoint loguniq 8, logpos 0x15c716c, timestamp: 855072
08:59:49 Maximum server connections 7
09:01:24 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:01:28 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:01:30 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:28 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:31 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:33 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:49 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:58 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:01 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:04 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:19 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:22 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:24 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:25 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:28 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:04:50 Fuzzy Checkpoint Completed: duration was 0 seconds, 26 buffers not flushed,
timestamp: 865140.
09:04:50 Checkpoint loguniq 8, logpos 0x1681190, timestamp: 865140
09:04:50 Maximum server connections 8
09:05:27 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:31 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:34 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:38 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:40 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:43 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:46 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:48 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:51 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:53 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:07:45 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:19 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:21 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:24 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:27 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:31 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:33 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:36 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:39 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:40 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:44 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:47 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:09:03 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:09:50 Fuzzy Checkpoint Completed: duration was 0 seconds, 28 buffers not flushed,
timestamp: 869747.
09:09:50 Checkpoint loguniq 8, logpos 0x16b51a8, timestamp: 869747
09:09:50 Maximum server connections 8
09:11:43 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:27 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:31 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:33 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:56 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:58 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:21 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:30 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:37 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:41 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:43 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:46 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:48 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:50 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:52 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:55 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:14:50 Fuzzy Checkpoint Completed: duration was 0 seconds, 45 buffers not flushed,
timestamp: 875824.
09:14:50 Checkpoint loguniq 8, logpos 0x1723274, timestamp: 875824
09:14:50 Maximum server connections 8
09:19:50 Fuzzy Checkpoint Completed: duration was 0 seconds, 48 buffers not flushed,
timestamp: 888676.
09:19:50 Checkpoint loguniq 8, logpos 0x18182a4, timestamp: 888676
09:19:50 Maximum server connections 8
09:20:54 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:21:37 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:22:14 Dynamically allocated new virtual shared memory segment (size 8192KB)
09:22:15 Dynamically allocated new virtual shared memory segment (size 8192KB)
---------------end--------作者: zzjijun 时间: 2007-03-19 13:58
不断分配新的虚拟段,把SHMVIRTSIZE,SHMADD调大点。作者: liaosnet 时间: 2007-03-19 14:08
8192K的SHMADD也太小了点吧。。。。看情况增加。作者: chuchadf 时间: 2007-03-19 16:14
机器内存2G.
我把SHMVIRTSIZE modified from 8M to 300M
SHMADD modified from 8M to 64M
但还是发现使用的buffer逐渐增大,这样内存估计会用光了吧。
在checkpoint后,系统不会做flush吗?
15:46:57 Onconfig parameter SHMVIRTSIZE modified from 8192 to 300000.
15:46:57 Onconfig parameter SHMADD modified from 8192 to 64000.
15:46:57 Dataskip is now OFF for all dbspaces
15:46:57 Checkpoint Completed: duration was 0 seconds.
15:46:57 Checkpoint loguniq 9, logpos 0xc03018, timestamp: 1096363
15:46:57 Maximum server connections 0
15:46:57 Init operation complete - Mode Online
15:46:57 On-Line Mode
15:47:26 Checkpoint Completed: duration was 0 seconds.
15:47:26 Checkpoint loguniq 9, logpos 0xc04018, timestamp: 1096400
15:47:26 Maximum server connections 1
15:52:26 Fuzzy Checkpoint Completed: duration was 0 seconds, 25 buffers not flushed,
timestamp: 1098685.
15:52:26 Checkpoint loguniq 9, logpos 0xc86190, timestamp: 1098685
15:52:26 Maximum server connections 9
15:57:26 Fuzzy Checkpoint Completed: duration was 0 seconds, 36 buffers not flushed,
timestamp: 1130788.
15:57:26 Checkpoint loguniq 9, logpos 0x124a208, timestamp: 1130788
15:57:26 Maximum server connections 11
16:01:18 Dynamically allocated new virtual shared memory segment (size 64000KB)
16:02:26 Fuzzy Checkpoint Completed: duration was 0 seconds, 41 buffers not flushed,
timestamp: 1137641.
16:02:26 Checkpoint loguniq 9, logpos 0x155a244, timestamp: 1137641
16:02:26 Maximum server connections 11
16:07:27 Fuzzy Checkpoint Completed: duration was 0 seconds, 62 buffers not flushed,
timestamp: 1145896.
16:07:27 Checkpoint loguniq 9, logpos 0x19a0990, timestamp: 1145896