MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


Subject
Written By
Posted
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.