求助：online.log文件报如下错buffers not flushed，怎么解决？

cghou

14:42:20  Maximum server connections 68
14:44:22  Fuzzy Checkpoint Completed:  duration was 1 seconds, 513 buffers not flushed.
14:44:22  Checkpoint loguniq 4303, logpos 0x2ab240

14:44:22  Maximum server connections 68
14:46:31  Fuzzy Checkpoint Completed:  duration was 10 seconds, 2154 buffers not flushed.
14:46:31  Checkpoint loguniq 4303, logpos 0xaab43c

14:46:31  Maximum server connections 68
14:48:32  Fuzzy Checkpoint Completed:  duration was 0 seconds, 2180 buffers not flushed.
14:48:32  Checkpoint loguniq 4303, logpos 0xb5251c
数据库版本是INFORMIX IDS 9.30

songdu

正常的!为了提高效率Informix 9.X后引入了fuzzy checkpoint，
在检查点是不会把所有的dirty page写到硬盘上

cghou

能否大致说说原理？这感觉不像是检查点了，居然没有刷新干净，会不会不安全？

songdu

在进行fast recovery时会花更多的时间查找物理日志和逻辑日志来保障
数据的一致性。
如果不安全谁会用？现在9.x有几个人会设置成no fuzzy方式

如果你觉得不安全，那就用 no fuzzy 方式