Databases
Intermediate
What is Connection Pool?
A cache of database connections that can be reused, avoiding the overhead of creating new connections for each request.
Connection pooling maintains a set of open database connections that are shared among application threads. Creating a new database connection is expensive (authentication, SSL handshake, memory allocation), so pooling dramatically improves performance.
Popular connection poolers include PgBouncer (PostgreSQL), MySQL Connector pools, and application-level pools. Key settings include minimum/maximum pool size, connection timeout, and idle timeout.
