Code RoomDatabase shard hot partition
HardPrep Room Coding #3115

Database shard hot partition

On-callDatabases & SQLReliability & on-callSenior~20 min

A service that's been fine suddenly has high latency on some requests but not others, and you find one database shard (or partition) is far hotter than the rest — a data-skew / hot-partition problem. How do you respond?

What a strong answer looks like

Stop the bleeding first (mitigate), then form hypotheses from real signals. Separate root cause from symptom, communicate status as you go, and close with what prevents a repeat.

0:00 of about 20 min
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.