- 论坛徽章:
- 0
|
本帖最后由 houhuaw 于 2011-09-12 23:58 编辑
onconfig文件中CKPTINTVL设定为300s,可实际检查点间隔时间大部份为10分钟,也有少部分是5分钟的,但没有超过10分钟间隔仍旧不执行的。
比如上一个检查点执行时间是00:00:00
在00:05:00执行onstat -R显示大部份都是0 dirty(这台机子业务量很大,不可能不更新数据库,confonfig LRU配置为:BUFFERPOOL size=2K,buffers=500000,lrus=32,lru_min_dirty=0.390000,lru_max_dirty=0.780000):
> onstat -R显示:
IBM Informix Dynamic Server Version 11.10.FC2 -- On-Line -- Up 168 days 10:22:38 -- 1375204 Kbytes
Buffer pool page size: 2048
...
0 dirty, 500000 queued, 500000 total, 524288 hash buckets, 2048 buffer size
start clean at 0.780% (of pair total) dirty, or 122 buffs dirty, stop at
0.390%
大部份情况下过了5分钟后才会出现lru buffer中dirty不为0的情况,大部份情况为19 dirty。
>onstat -F显示:
IBM Informix Dynamic Server Version 11.10.FC2 -- On-Line -- Up 168 days 10:17:55 -- 1375204 Kbytes
Fg Writes LRU Writes Chunk Writes
0 1368228 1572810
> onstat -p显示:
IBM Informix Dynamic Server Version 11.10.FC2 -- On-Line -- Up 168 days 10:20:47 -- 1375204 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
3903022 131116576 5343564559 99.95 3411397 9564319 83376312 95.93
isamtot open start read write rewrite delete commit rollbk
6153942905 125408825 889940216 1475748619 18939770 139680 14628607 626166 2
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 88531.03 29910.57 27426 27929
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
29885 0 2750105435 0 0 749 1811164 2038837
ixda-RA idx-RA da-RA RA-pgsused lchwaits
338 0 134146 134484 640484682 |
|