Buffer Management and Disk I/O
Buffer management is the subsystem that caches disk pages in memory so that the database can reduce disk I/O.
Buffer Pool
The buffer pool holds recently used pages. Effective sizing reduces costly disk reads.
Replacement Policies
- LRU: Least Recently Used
- MRU: Most Recently Used
- Clock: An efficient approximation of LRU
I/O Optimization
- Group writes to reduce random I/O (write-ahead logging helps).
- Pin frequently used pages in memory.
- Tune page size and buffer pool size according to workload.
Some advanced sections are available for
Registered Members
🚀 Want to Test Your Knowledge?
Take quizzes related to this topic and see where you stand!
Start Quiz Now