Why does this SQL cache stampede?

Why does this SQL cache stampede under load. The SQL layer recomputes values on expiry without a lock, so every request hits the database. In SQL services this melts the backend.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcachestampede #sqlcacherefresh #sqldatabaseload #sqlperfo...

https://www.youtube.com/watch?v=BCmzcODQV2Q

Why does this SQL cache stampede? #sqlcachestampede

YouTube