求教高手...INFORMIX数据库的checkpoint设置问题

sugarzdl

我们的informix9.3数据库的日志：

Message Log File: /informix/online.log
timestamp: 1448483624.
13:22:56  Checkpoint loguniq 75615, logpos 0x9d6064, timestamp: 1448483624

13:22:56  Maximum server connections 46
13:23:13  Logical Log 75615 Complete, timestamp:1448485649.
13:37:59  Logical Log 75616 Complete, timestamp:1448661449.
13:48:52  Logical Log 75617 Complete, timestamp:1448824767.
14:01:59  Logical Log 75618 Complete, timestamp:1449006752.
14:15:54  Logical Log 75619 Complete, timestamp:1449187952.
14:22:56  Fuzzy Checkpoint Completed:  duration was 0 seconds, 3032 buffers not flushed,
timestamp: 1449294301.
14:22:56  Checkpoint loguniq 75620, logpos 0x5d1148, timestamp: 1449294301

14:22:56  Maximum server connections 46
14:28:47  Logical Log 75620 Complete, timestamp:1449383553.
14:35:12  Logical Log 75621 Complete, timestamp:1449521186.
14:47:24  Logical Log 75622 Complete, timestamp:1449711684.
14:58:03  Logical Log 75623 Complete, timestamp:1449895458.
15:02:53  Logical Log 75624 Complete, timestamp:1450011287.
15:07:25  Logical Log 75625 Complete, timestamp:1450096950.


CKPTINTVL       3600             # Check point interval (in sec) 是不是设置的时间太长了，online.log高手给指点一下迷津吧 ！ 拜谢了！

zpc_silenthill

CKPTINTVL 这个参数只是指定满足条件的话，到达该时间间隔做一次检查点，其它条件也可以触发检查点
只要模糊/完全检查点的时间不太长就OK  检查点时间过长的话 可以调低LRU脏读最大最小值