- 论坛徽章:
- 0
|
以下是我执行checkpont时的记录
执行inser操作产生记录
54112 2008-06-05 11:28:09 WriteFile abc.dat /sybase-databack/ overwrite offset:2232320 size:4096
54111 2008-06-05 11:28:03 WriteFile abclog.dat /sybase-databack/ overwrite offset:24576 size:4096
执行commit
go
产生记录
54114 2008-06-05 11:29:13 WriteFile abc .dat /sybase-databack/ overwrite offset:1740800 size:4096
54113 2008-06-05 11:28:54 WriteFile abclog.dat /sybase-databack/ overwrite offset:24576 size:4096
执行checkpoint
go产生记录
54117 2008-06-05 11:37:13 WriteFile abc.dat /sybase-databack/ overwrite offset:98304 size:4096
54116 2008-06-05 11:37:13 WriteFile abclog.dat /sybase-databack/ overwrite offset:24576 size:4096
54115 2008-06-05 11:37:13 WriteFile abc.dat /sybase-databack/ overwrite offset:98304 size:4096
124200 2008-06-05 11:37:13 WriteFile master.dat /sybase-databack/sybase/data/ overwrite offset:634880 size:4096
单独执行checkpoint,没新数据时产生记录
54118 2008-06-05 11:42:36 WriteFile abc.dat /sybase-databack/ overwrite offset:98304 size:4096
124201 2008-06-05 11:42:36 WriteFile master.dat /sybase-databack/sybase/data/ overwrite offset:634880 size:4096
1.可不可以认为只要对master.dat写(offset:634880 size:4096),对abc 数据库的设备文件写offset:98304 size:4096就产生了checkpoint点?
2.在有数据更新时checkpoint,为什么有两次WriteFile abc.dat /sybase-databack/ overwrite offset:98304 size:4096?
[ 本帖最后由 badpage 于 2008-6-5 12:06 编辑 ] |
|