虚拟内存耗尽out of virtual shared memory

chuchadf

win idx9.4  内存2G
系统没有刷新的buffers不断增多，系统也在动态分配虚拟空间， 最终内存用光了；
怎么没有释放buffer啊？

19:39:08  Maximum server connections 7
19:44:08  Fuzzy Checkpoint Completed:  duration was 0 seconds, 60 buffers not flushed,
timestamp: 1355150.
19:44:08  Checkpoint loguniq 9, logpos 0x2af08a4, timestamp: 1355150

19:44:08  Maximum server connections 7
19:49:08  Fuzzy Checkpoint Completed:  duration was 0 seconds, 76 buffers not flushed,
timestamp: 1367615.
19:49:08  Checkpoint loguniq 9, logpos 0x305a3f4, timestamp: 1367615

19:49:08  Maximum server connections 8
19:49:29  Logical Log 9 Complete, timestamp:1368437.
19:54:08  Fuzzy Checkpoint Completed:  duration was 0 seconds, 85 buffers not flushed,
timestamp: 1378320.
19:54:08  Checkpoint loguniq 10, logpos 0x30f454, timestamp: 1378320

19:54:08  Maximum server connections 8
19:57:51  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:57:57  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:04  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:12  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:19  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:26  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:35  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:42  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:49  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:57  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:03  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:08  Fuzzy Checkpoint Completed:  duration was 0 seconds, 121 buffers not flushed,
timestamp: 1387780.
19:59:08  Checkpoint loguniq 10, logpos 0x63a604, timestamp: 1387780

19:59:08  Maximum server connections 8
19:59:13  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:41  Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:59  Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:06  Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:18  Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:21  Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:25  shmat: [ENOMEM][12]: out of available data space, check system MAXMEM

20:00:25  shmdt: errno = 22
20:00:25  out of virtual shared memory

20:00:26  shmat: [ENOMEM][12]: out of available data space, check system MAXMEM

20:00:26  shmdt: errno = 22
20:00:26  out of virtual shared memory

20:00:26  shmat: [ENOMEM][12]: out of available data space, check system MAXMEM

20:00:26  shmdt: errno = 22
20:00:26  out of virtual shared memory

20:00:26  shmat: [ENOMEM][12]: out of available data space, check system MAXMEM

20:00:26  shmdt: errno = 22
20:00:26  out of virtual shared memory

20:00:27  shmat: [ENOMEM][12]: out of available data space, check system MAXMEM


---end---

0226qimei

FreeMem(Buffer);

chuchadf

FreeMem是什么，在数据库中需要怎么配置才可以呢？

wolfop

你这个象内存漏洞啊，才8个连接要那么大的查询内存。跑DSS的么？

chuchadf

嗯。数据处理量比较大，系统跑2个小时就不够了。

alexander_lu

把config文件贴上来看看。

wolfop

原帖由 chuchadf 于 2007-3-20 17:29 发表
嗯。数据处理量比较大，系统跑2个小时就不够了。

真是DSS啊，你的配置看来只好减少buffer的大小，增加虚拟内存大小了。另外可以限制允许使用的虚拟内存大小，用
那个SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
的参数。
不过限制了可能导致你的查询失败。
改用64位平台增加内存会好点。怎么想着用INFORMIX做DSS呢，都不是它的强项。

asksoso1

第一个想到的就是：
核心参数配置有些问题。

但是需要看看具体配置才能了解。

wolfop

windows没什么核心参数让你调整。
二期是32BIT的系统，做DSS很容易VM爆了。

chuchadf

目前是测试前期在win主机。我调整了logical log、SHMVIRTSIZE的大小，现在已基本满足需求。最终还是要到unix主机。

谢谢wolfop  。
也可以参考下ibm Faq
http://www-1.ibm.com/support/docview.wss?uid=swg21153194#ratepage