Cache Hit Ratio & Buffer Pool Sizing: Working Set, Headroom & the RAM to Buy
This lesson is part of the course
In this lesson
You measure how well Parcelwise's cache works, estimate the hot working set, size the buffer pool with headroom and pick the smallest instance with enough RAM.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Row Size from Column Types & Table Size: Bytes per Row, Rows per Page, GiB Locked
- Index Size & Overhead: B-tree Leaf Pages, Fill Factor & Indexes vs Table Locked
- Database Storage Forecast: Compound Monthly Growth, Overhead & Months Until the Disk Alert (Chart) Locked
- IOPS & Throughput from the Query Mix: Reads, Amplified Writes & the Peak Locked
- Cache Hit Ratio & Buffer Pool Sizing: Working Set, Headroom & the RAM to Buy Locked
- Replicas, Backups & Retention: The Real Storage Footprint of One Database Locked
- Connection Pool Sizing with Little's Law: Busy Connections, Pool per Instance & Limits Locked
- Cost Comparison: Instance Sizes vs Serverless per Month (with a Chart) Locked