#performance

PostgreSQL "FATAL: sorry, too many clients already": find who holds the connections

Fix PostgreSQL "FATAL: sorry, too many clients already": see who holds the connections, end the idle ones, size your pools, and add PgBouncer before raising the limit.

Intermediate · 4 min read

ERROR 1040 (HY000): Too many connections

Databases

MySQL "ERROR 1040: Too many connections": get in, find who holds them, fix it

Fix MySQL and MariaDB "Too many connections": log in with the reserved admin connection, find idle and stuck connections, then fix pools, timeouts or max_connections.

Intermediate · 4 min read