虚拟内存耗尽out of virtual shared memory
win idx9.4内存2G系统没有刷新的buffers不断增多，系统也在动态分配虚拟空间， 最终内存用光了；
怎么没有释放buffer啊？
19:39:08Maximum server connections 7
19:44:08Fuzzy Checkpoint Completed:duration was 0 seconds, 60 buffers not flushed,
timestamp: 1355150.
19:44:08Checkpoint loguniq 9, logpos 0x2af08a4, timestamp: 1355150
19:44:08Maximum server connections 7
19:49:08Fuzzy Checkpoint Completed:duration was 0 seconds, 76 buffers not flushed,
timestamp: 1367615.
19:49:08Checkpoint loguniq 9, logpos 0x305a3f4, timestamp: 1367615
19:49:08Maximum server connections 8
19:49:29Logical Log 9 Complete, timestamp:1368437.
19:54:08Fuzzy Checkpoint Completed:duration was 0 seconds, 85 buffers not flushed,
timestamp: 1378320.
19:54:08Checkpoint loguniq 10, logpos 0x30f454, timestamp: 1378320
19:54:08Maximum server connections 8
19:57:51Dynamically allocated new virtual shared memory segment (size 64000KB)
19:57:57Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:04Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:12Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:19Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:26Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:35Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:42Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:49Dynamically allocated new virtual shared memory segment (size 64000KB)
19:58:57Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:03Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:08Fuzzy Checkpoint Completed:duration was 0 seconds, 121 buffers not flushed,
timestamp: 1387780.
19:59:08Checkpoint loguniq 10, logpos 0x63a604, timestamp: 1387780
19:59:08Maximum server connections 8
19:59:13Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:41Dynamically allocated new virtual shared memory segment (size 64000KB)
19:59:59Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:06Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:18Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:21Dynamically allocated new virtual shared memory segment (size 64000KB)
20:00:25shmat: : out of available data space, check system MAXMEM
20:00:25shmdt: errno = 22
20:00:25out of virtual shared memory
20:00:26shmat: : out of available data space, check system MAXMEM
20:00:26shmdt: errno = 22
20:00:26out of virtual shared memory
20:00:26shmat: : out of available data space, check system MAXMEM
20:00:26shmdt: errno = 22
20:00:26out of virtual shared memory
20:00:26shmat: : out of available data space, check system MAXMEM
20:00:26shmdt: errno = 22
20:00:26out of virtual shared memory
20:00:27shmat: : out of available data space, check system MAXMEM
---end--- FreeMem(Buffer); FreeMem是什么，在数据库中需要怎么配置才可以呢？ 你这个象内存漏洞啊，才8个连接要那么大的查询内存。跑DSS的么？ 嗯。数据处理量比较大，系统跑2个小时就不够了。 把config文件贴上来看看。 原帖由 chuchadf 于 2007-3-20 17:29 发表
嗯。数据处理量比较大，系统跑2个小时就不够了。
真是DSS啊，你的配置看来只好减少buffer的大小，增加虚拟内存大小了。另外可以限制允许使用的虚拟内存大小，用
那个SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
的参数。
不过限制了可能导致你的查询失败。
改用64位平台增加内存会好点。怎么想着用INFORMIX做DSS呢，都不是它的强项。 第一个想到的就是：
核心参数配置有些问题。
但是需要看看具体配置才能了解。 windows没什么核心参数让你调整。
二期是32BIT的系统，做DSS很容易VM爆了。 目前是测试前期在win主机。我调整了logical log、SHMVIRTSIZE的大小，现在已基本满足需求。最终还是要到unix主机。
谢谢wolfop。
也可以参考下ibm Faq
http://www-1.ibm.com/support/docview.wss?uid=swg21153194#ratepage
页:
[1]