Question: Consider transaction T 1 that sets x = 0 and y = 1 and transaction T 2 that sets x = 2 and y =
Consider transaction T that sets x and y and transaction T that sets x and y T runs first and after recording its intentions in the REDO writeahead log commits.Then T runs and writes its intentions to the log but a crash occurs before T writes its commit record to the log Consider two cases. In one case, the part of the log containing intentions of T was garbage collected before the crash. In the second case, the log garbage collection did not run yet after T committed. Explain what will be the state of x and y on disk after recovery in each case?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
