求教高手...INFORMIX数据库的checkpoint设置问题
我们的informix9.3数据库的日志：Message Log File: /informix/online.log
timestamp: 1448483624.
13:22:56Checkpoint loguniq 75615, logpos 0x9d6064, timestamp: 1448483624
13:22:56Maximum server connections 46
13:23:13Logical Log 75615 Complete, timestamp:1448485649.
13:37:59Logical Log 75616 Complete, timestamp:1448661449.
13:48:52Logical Log 75617 Complete, timestamp:1448824767.
14:01:59Logical Log 75618 Complete, timestamp:1449006752.
14:15:54Logical Log 75619 Complete, timestamp:1449187952.
14:22:56Fuzzy Checkpoint Completed:duration was 0 seconds, 3032 buffers not flushed,
timestamp: 1449294301.
14:22:56Checkpoint loguniq 75620, logpos 0x5d1148, timestamp: 1449294301
14:22:56Maximum server connections 46
14:28:47Logical Log 75620 Complete, timestamp:1449383553.
14:35:12Logical Log 75621 Complete, timestamp:1449521186.
14:47:24Logical Log 75622 Complete, timestamp:1449711684.
14:58:03Logical Log 75623 Complete, timestamp:1449895458.
15:02:53Logical Log 75624 Complete, timestamp:1450011287.
15:07:25Logical Log 75625 Complete, timestamp:1450096950.
CKPTINTVL 3600 # Check point interval (in sec) 是不是设置的时间太长了，online.log高手给指点一下迷津吧 ！ 拜谢了！ 本帖最后由 zpc_silenthill 于 2012-02-15 15:37 编辑
CKPTINTVL 这个参数只是指定满足条件的话，到达该时间间隔做一次检查点，其它条件也可以触发检查点
只要模糊/完全检查点的时间不太长就OK检查点时间过长的话 可以调低LRU脏读最大最小值
页:
[1]