Re: Random server overload

Viktor wrote:
> We are experiencing database random overloads caused by IDLE processes.
> Their count jumps from normal ~70 connections to 250-300 with high I/O
> (30-40% wa, when normal ~ 1 % wa).
> 
> The overload isn't long and lasts about 5 -10 minutes just a couple of
> times during the month.
> 
> Please suggest how to debug this issue and find the cause of the
> overloads. Or mby we should tune our config file ?
> 
> errorlog example:
> 2013-09-30 10:37:45 EEST FATAL:  sorry, too many clients already
> 2013-09-30 10:37:45 EEST FATAL:  remaining connection slots are reserved
> for non-replication superuser connections

Looks like something tries to open lots of connections at these times.

Your best bet is to is to set log_connections = on and examine the log file
when the problem happens.  That way you can figure out where the connections
come from.

Yours,
Laurenz Albe