[prev] 50 [next]

Transactions and Buffer Pool

Two issues arise w.r.t. buffers:
  • forcing ... OUTPUT buffer on each WRITE
    • ensures durability; disk always consistent with buffer pool
    • poor performance; defeats purpose of having buffer pool
  • stealing ... replace buffers of uncommitted tx's
    • if we don't, poor throughput (tx's blocked on buffers)
    • if we do, seems to cause atomicity problems?
Ideally, we want stealing and not forcing.