Re: SQLSTATE[08004] [1040] Too many connections
Posted by:
Rick James
Date: September 03, 2011 08:00PM
SHOW GRANTS FOR admin@localhost;
(admin may not have permission to see the entire PROCESSLIST.)
> | Max_used_connections | 65 |
That gets reset when you restart mysql. Has "Too many connections" since you restarted?
> But yea it looks like there is an awful lot of connections, 12913?
It depends. Some applications legitimately do a lot of connections.
SHOW GLOBAL STATUS LIKE 'Uptime';
That will help you calculate connections/second -- a more useful metric.
Subject
Written By
Posted
September 01, 2011 12:45PM
September 01, 2011 04:47PM
September 02, 2011 10:17AM
Re: SQLSTATE[08004] [1040] Too many connections
September 03, 2011 08:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.