db是否正常？请大家分析下

chuchadf

b/s系统使用informix数据库，读写数据较慢，
查看日志记录，发现没有刷新的buffer逐渐增多，并且系统在不断的分配共享内存；请分析下db正常的吗？

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

不断分配新的虚拟段，把SHMVIRTSIZE，SHMADD调大点。

liaosnet

8192K的SHMADD也太小了点吧。。。。看情况增加。

chuchadf

机器内存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

16:07:27  Maximum server connections 11

----------------end-----------------

cdcd007

这个问题估计是内存泄漏,你可以检查一下 onstat -g ses
在mem 列上看session占用的最大内存是多少
如果没有批处理,仅是OLTP系统的话,通常单个session占用的内存不应该超过1M