欢迎投稿

今日深度:

对checkpoint not completed的理解,checkpoint

对checkpoint not completed的理解,checkpoint


假设数据库存在两个日志组log1和log2,首先,-->log1-->log2-->log1,此时(log2切换到log1)触发checkpoint,该checkpoint will flush dirty block to datafile,从而触发DBWn书写dirty buffer,等到log1覆盖的dirty block全部被写入datafile后才能使用log1(循环使用),如果DBWn写入过慢,LGWR必须等待DBWn完成,则这时会出现“checkpoint not completed!”


别人的回答是

log1-> log2, trigger checkpoint 1
after log2 is full,
log2-> log1, trigger checkpoint 2
but if checkpoint 1 is still not finished, then LGWR must wait. This is "logfile switch (checkpoint incompleted)" event.


我的理解是

1.检查点完成,才能顺利切换。

2.checkpoint1阻塞了log2->log1的切换。

3.没有可用的redo日志,会阻塞数据正常使用,这时数据库是短暂hang住的。(原因如下)


不知道对不对,请高人指正~

Before a change is done in the buffer cache a change vector (file, block, row, value) about this change is written to the redo buffer. First the change of the undo block to be made soon is tracked (L). Then the change is done in the buffer cache (M). Then the change of the table block to be made soon is tracked (N). Then the insert to the table block is done in the buffer cache (O). All actions up to now where done by the server process (P). Finally it returns the control to the client process (Q).

redo无法试用,导致事务不能正常进行。


电脑中的setup was not completed successfully什意思

程序没有成功完成安装。
有可能是安装文件损坏。也有可能是其他原因。根据你具体的安装程序名称百度下吧
 

我的PS用滤镜液化的时出现The operation couLd not be compLeted是什

自己没遇到过,也许是跟什么软件或者滤镜发生冲突了吧!
 

www.htsjk.Com true http://www.htsjk.com/shujukunews/2611.html NewsArticle 对checkpoint not completed的理解,checkpoint 假设数据库存在两个日志组log1和log2,首先,--log1--log2--log1,此时(log2切换到log1)触发checkpoint,该checkpoint will flush dirty block to datafile,从而触发...
评论暂时关闭