登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

中吴南顾惟一笑

成功法则就是那19个字

 
 
 

日志

 
 

MMDB:Log&Recovery   

2009-09-17 14:27:50|  分类: dbms |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Repeat history
Low Amount of disk I/O
    - Redo logs are written to disk
    - No undo logs to disk normally
Ping-Pong Checkpointing Scheme
    - Write to alternate disk copies on successive checkpoints
            resilient to crashes during checkpointing
Only relevant undo logs written to disk when checkpointing
    - undo logs of transactions that are active at the end of the checkpoint
Fuzzy checkpoints
    - Updates execute concurrently with checkpoints
            e.g. No page latching during checkpoints
    - Only dirty pages written to disk during checkpoints
Single pass recovery algorithm

Do not write logs for index.
    - If crash occurs, the index will be rebuild


Extended Logging Support:

Logging support for high concurrency
    - Multi-level logging
            Physical undo during updates, logical undo afterward
    - Post-commit actions
            Actions that cannot be rolled back (e.g. freeing storage space)
Support for user-defined operation logging
Time stamp recovery
    - Recover the database to a transaction-consistent point in the past
Turn redo logging off
    - Support atomic transactions without requiring them to be durable
  评论这张
 
阅读(163)| 评论(0)

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018