Implementing Commit
Every commit requires a log flush.
If you can do K log flushes per second, then K is your maximum transaction throughput
Group Commit Optimization - when processing commit, if the last log page isn’t full, delay the flush to give it time to fill
If there are multiple data managers on a system, then each data mgr must flush its log to commit
- If each data mgr isn’t using its log’s update bandwidth, then a shared log saves log flushes
- A good idea, but rarely supported commercially