In the panel on the top right, which "memory" is X:15 being stored on? It can't be main memory because we haven't committed yet, right?
amaliujia
@ak47 If it is not main memory, Which one should store X:15? It is less likely be cache I think, because we can easily load X from main memory when recovery. So I think x:15 will be flush into memory, as well as x:10 in undo log, which should be somewhere in memory.
haodongl
@ak47 I think x:15 is in memory because eager versioning update memory immediately.
ak47
But if x:15 is in memory in the top right and the bottom left, what does the commit actually do?
In the panel on the top right, which "memory" is X:15 being stored on? It can't be main memory because we haven't committed yet, right?
@ak47 If it is not main memory, Which one should store X:15? It is less likely be cache I think, because we can easily load X from main memory when recovery. So I think x:15 will be flush into memory, as well as x:10 in undo log, which should be somewhere in memory.
@ak47 I think x:15 is in memory because eager versioning update memory immediately.
But if x:15 is in memory in the top right and the bottom left, what does the commit actually do?