Too many connections Print

  • performance, database, troubleshooting, caching, guide, howto, solution, zillionkinghost
  • 0

The database refused a new connection.

WHAT IT MEANS

The connection limit was reached. Existing connections are held open, and no more are permitted.

COMMON CAUSES

An application opening connections without closing them Several applications on one account competing A traffic spike Slow queries holding connections open longer than they should

WHAT TO CHECK

How many applications are on the account, each holding connections Whether a slow query is holding connections Whether traffic is unusually high

IMMEDIATE RELIEF

The condition frequently clears by itself as connections time out.

If it persists, something is leaking connections.

THE UNDERLYING FIXES

Enable caching, so fewer requests reach the database at all Fix slow queries, usually by adding an index Check for code opening connections in a loop

IF YOU RUN SEVERAL SITES

Each holds connections. Several busy sites on one account reach the limit collectively.

WHAT TO SEND US

The time, how many applications are on the account, and whether it coincides with a traffic spike.

We can see connection counts from the server side.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot