db是否正常？请大家分析下
b/s系统使用informix数据库，读写数据较慢，查看日志记录，发现没有刷新的buffer逐渐增多，并且系统在不断的分配共享内存；请分析下db正常的吗？
08:49:49Maximum server connections 5
08:54:49Fuzzy Checkpoint Completed:duration was 0 seconds, 22 buffers not flushed,
timestamp: 852692.
08:54:49Checkpoint loguniq 8, logpos 0x159a148, timestamp: 852692
08:54:49Maximum server connections 7
08:59:49Fuzzy Checkpoint Completed:duration was 0 seconds, 23 buffers not flushed,
timestamp: 855072.
08:59:49Checkpoint loguniq 8, logpos 0x15c716c, timestamp: 855072
08:59:49Maximum server connections 7
09:01:24Dynamically allocated new virtual shared memory segment (size 8192KB)
09:01:28Dynamically allocated new virtual shared memory segment (size 8192KB)
09:01:30Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:28Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:31Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:33Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:49Dynamically allocated new virtual shared memory segment (size 8192KB)
09:02:58Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:01Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:04Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:19Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:22Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:24Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:25Dynamically allocated new virtual shared memory segment (size 8192KB)
09:03:28Dynamically allocated new virtual shared memory segment (size 8192KB)
09:04:50Fuzzy Checkpoint Completed:duration was 0 seconds, 26 buffers not flushed,
timestamp: 865140.
09:04:50Checkpoint loguniq 8, logpos 0x1681190, timestamp: 865140
09:04:50Maximum server connections 8
09:05:27Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:31Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:34Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:38Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:40Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:43Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:46Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:48Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:51Dynamically allocated new virtual shared memory segment (size 8192KB)
09:05:53Dynamically allocated new virtual shared memory segment (size 8192KB)
09:06:00Dynamically allocated new virtual shared memory segment (size 8192KB)
09:07:45Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:19Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:21Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:24Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:27Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:31Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:33Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:36Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:39Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:40Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:44Dynamically allocated new virtual shared memory segment (size 8192KB)
09:08:47Dynamically allocated new virtual shared memory segment (size 8192KB)
09:09:03Dynamically allocated new virtual shared memory segment (size 8192KB)
09:09:50Fuzzy Checkpoint Completed:duration was 0 seconds, 28 buffers not flushed,
timestamp: 869747.
09:09:50Checkpoint loguniq 8, logpos 0x16b51a8, timestamp: 869747
09:09:50Maximum server connections 8
09:11:43Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:27Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:31Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:33Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:56Dynamically allocated new virtual shared memory segment (size 8192KB)
09:12:58Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:21Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:30Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:37Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:41Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:43Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:46Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:48Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:50Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:52Dynamically allocated new virtual shared memory segment (size 8192KB)
09:13:55Dynamically allocated new virtual shared memory segment (size 8192KB)
09:14:50Fuzzy Checkpoint Completed:duration was 0 seconds, 45 buffers not flushed,
timestamp: 875824.
09:14:50Checkpoint loguniq 8, logpos 0x1723274, timestamp: 875824
09:14:50Maximum server connections 8
09:19:50Fuzzy Checkpoint Completed:duration was 0 seconds, 48 buffers not flushed,
timestamp: 888676.
09:19:50Checkpoint loguniq 8, logpos 0x18182a4, timestamp: 888676
09:19:50Maximum server connections 8
09:20:54Dynamically allocated new virtual shared memory segment (size 8192KB)
09:21:37Dynamically allocated new virtual shared memory segment (size 8192KB)
09:22:14Dynamically allocated new virtual shared memory segment (size 8192KB)
09:22:15Dynamically allocated new virtual shared memory segment (size 8192KB)
－－－－－－－－－－－－－－－end－－－－－－－－ 不断分配新的虚拟段，把SHMVIRTSIZE，SHMADD调大点。 8192K的SHMADD也太小了点吧。。。。看情况增加。 机器内存2G.
我把SHMVIRTSIZE modified from 8M to 300M
SHMADD modified from 8M to 64M
但还是发现使用的buffer逐渐增大，这样内存估计会用光了吧。
在checkpoint后，系统不会做flush吗？
15:46:57Onconfig parameter SHMVIRTSIZE modified from 8192 to 300000.
15:46:57Onconfig parameter SHMADD modified from 8192 to 64000.
15:46:57Dataskip is now OFF for all dbspaces
15:46:57Checkpoint Completed:duration was 0 seconds.
15:46:57Checkpoint loguniq 9, logpos 0xc03018, timestamp: 1096363
15:46:57Maximum server connections 0
15:46:57Init operation complete - Mode Online
15:46:57On-Line Mode
15:47:26Checkpoint Completed:duration was 0 seconds.
15:47:26Checkpoint loguniq 9, logpos 0xc04018, timestamp: 1096400
15:47:26Maximum server connections 1
15:52:26Fuzzy Checkpoint Completed:duration was 0 seconds, 25 buffers not flushed,
timestamp: 1098685.
15:52:26Checkpoint loguniq 9, logpos 0xc86190, timestamp: 1098685
15:52:26Maximum server connections 9
15:57:26Fuzzy Checkpoint Completed:duration was 0 seconds, 36 buffers not flushed,
timestamp: 1130788.
15:57:26Checkpoint loguniq 9, logpos 0x124a208, timestamp: 1130788
15:57:26Maximum server connections 11
16:01:18Dynamically allocated new virtual shared memory segment (size 64000KB)
16:02:26Fuzzy Checkpoint Completed:duration was 0 seconds, 41 buffers not flushed,
timestamp: 1137641.
16:02:26Checkpoint loguniq 9, logpos 0x155a244, timestamp: 1137641
16:02:26Maximum server connections 11
16:07:27Fuzzy Checkpoint Completed:duration was 0 seconds, 62 buffers not flushed,
timestamp: 1145896.
16:07:27Checkpoint loguniq 9, logpos 0x19a0990, timestamp: 1145896
16:07:27Maximum server connections 11
----------------end----------------- 这个问题估计是内存泄漏,你可以检查一下 onstat -g ses
在mem 列上看session占用的最大内存是多少
如果没有批处理,仅是OLTP系统的话,通常单个session占用的内存不应该超过1M
页:
[1]