undo機制工作原理描述的:
1. User 1 updates a record in block 777 (user 1 has not committed).
2. User 2 queries the same block and sees that the lock byte is set for a row being queried.
3. User 2 goes to the ITL portion of the block and gets the XID (transaction ID).
4. The XID (transaction ID) maps to the UNDO block, which holds the information before the update was done. If using IMU, then a check is done to see if the undo for this transaction is available in memory before going to the UNDO block.
5. A clone of the block is done (call it block 778).
6. The UNDO information is applied to the block, rolling it forward, but to where it used to be.
7. Block 777 is a CURRENT block.
8. Block 778 is a CONSISTENT READ block before the User 1 update occurred.
9. If another user wants to do a query before the commit, that user can also read the CR version.[@more@]
2. User 2 queries the same block and sees that the lock byte is set for a row being queried.
3. User 2 goes to the ITL portion of the block and gets the XID (transaction ID).
4. The XID (transaction ID) maps to the UNDO block, which holds the information before the update was done. If using IMU, then a check is done to see if the undo for this transaction is available in memory before going to the UNDO block.
5. A clone of the block is done (call it block 778).
6. The UNDO information is applied to the block, rolling it forward, but to where it used to be.
7. Block 777 is a CURRENT block.
8. Block 778 is a CONSISTENT READ block before the User 1 update occurred.
9. If another user wants to do a query before the commit, that user can also read the CR version.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1043591/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- undo的工作原理
- springMVC 的工作原理和機制SpringMVC
- 容器的工作原理和隔離機制
- UAV MOF工作原理之Agent注入機制原理
- 專題之Undo工作原理剖析
- Https工作原理&TLS握手機制HTTPTLS
- zt_oracle undo機制Oracle
- HTTPS 工作原理和 TCP 握手機制HTTPTCP
- 圖文詳解 HDFS 的工作機制及其原理
- Android的訊息機制之ThreadLocal的工作原理Androidthread
- handler機制的原理
- Android 原始碼分析 --Handler 機制的實現與工作原理Android原始碼
- ORACLE的工作機制Oracle
- 多型的機制原理多型
- Handler機制原理
- JavaScript 工作原理之九-網頁訊息推送通知機制JavaScript網頁
- 相機工作原理
- ORACLE的工作機制-1Oracle
- ORACLE的工作機制-2Oracle
- ORACLE的工作機制-3Oracle
- ORACLE的工作機制-4Oracle
- ORACLE的工作機制-5Oracle
- ORACLE的工作機制(簡)Oracle
- 理解storm的ACKER機制原理ORM
- oracle的undo的工作過程Oracle
- Zookeeper watch機制原理
- 交換機的概念以及工作原理
- InnoDB undo log原理
- Android Handler訊息傳遞機制:圖文解析工作原理Android
- HDFS成員的工作機制
- Roguelike機制的原理和應用
- oracle工作機制(1)Oracle
- oracle工作機制(2)Oracle
- oracle工作機制(轉)Oracle
- 【Qt】connect機制原理QT
- 如何形象地描述 RxJava 中的背壓和流控機制?RxJava
- 關於UNDO 內部一致性讀和回滾依賴的UNDO CHAIN描述AI
- 計算機基本工作原理計算機