CMU 15-445 #06: Buffer Pool Managers, LRU-K Eviction & Direct I/O
Associate Professor of Databaseology
1:22:44·2023·undergraduate level
Explains why databases bypass OS page caches via O_DIRECT, manage page pin counts and latches, and prevent sequential-scan pollution using LRU-K and Clock policies.
Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)
Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/06-bufferpool.pdf
Notes: https://15445.courses.cs.cmu.edu/fall2023/notes/06-bufferpool.pdf
Previous · Lecture 6
CMU 15-445 #05: OLTP vs. OLAP Storage Models & Database Compression
Next · Lecture 8CMU 15-445 #07: Static & Dynamic Hash Tables (Linear Probe, Robin Hood, Cuckoo, Extendible)
Comments
Add a comment...Sign in