3 ms·
The minute your RDBMS' hot dataset doesn't fit into memory its going to shit itself. I've seen it happen anywhere from 90% CPU down to around 10%. Queries tha
by bcrosby95 7y ago
The minute your RDBMS' hot dataset doesn't fit into memory its going to shit itself. I've seen it happen anywhere from 90% CPU down to around 10%. Queries that were instant can start to take 50ms.
It can be an easy fix (buy more memory), but the first time it happens it can be pretty mysterious.