MySQL / MariaDB DBA

Connection Management

Question

max_connections versus connection pooling: which capacity problem does each address?

Answer

max_connections caps simultaneous server clients; raising it increases potential per-connection resource use. Pooling reuses a bounded set of server sessions across application requests. Size pools to workload concurrency before raising the server cap. Applies to MySQL and MariaDB.

This is 14 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples