What connection pools do
The pool is a small set of reusable database connections. Requests can only query while holding one of those glowing slots.
Interactive Systems Explainers
See how limited database connections create bottlenecks, queues, and latency spikes.
Key Observations
The pool is a small set of reusable database connections. Requests can only query while holding one of those glowing slots.
When every slot is occupied, new requests stack in front of the pool. The app may look alive while work is blocked.
Workers help until the pool is saturated. After that, extra workers mostly create more blocked requests waiting together.
Long queries hold slots longer. That lowers connection turnover and makes everyone behind them feel the delay.
Interactive Systems Explainers