π Planning for failure to ship faster π
Ship It! Cloud, SRE, Platform Engineering
00:00
Using Redis Keys Command to Overfetch Database Query Database
We've got a reasonably sized buffer pool. So like everything, all the queries will run in memory. But what happens is when the memory fit in the buffer pool is used up, those queries will start running on disk. And once they go, let's start running ondisk, get significantly degraded performance. Bigger spinning disks, HDDs. That will make a big difference. And then there's another step up. You go from HDDs to SSDs, then you go fromSSS to NVMes. I think that's where we might need to go. It's still on those like scanning millions of rows, queries and overfetching like 100 columns or more at
Transcript
Play full episode
