Re: MySQL Thread Connections Count: 513
Posted by: Rick James
Date: July 09, 2015 09:31AM

What client are you using? Apache? Tomcat? Other?
What is the limit on number of "children" in the client?
Does the client software (PHP, etc) close the connection when finished?

513 Threads_connected but _Sleeping_ is rarely a problem.
513 Threads_running would be bad. -- I would look for slow queries that are failing to finish in a reasonably length of time.

You might be able to flesh out the naughty clients by setting max_connections to something considerably smaller than 513. They will start getting "cannot connect" error messages.

Options: ReplyQuote

Written By
Re: MySQL Thread Connections Count: 513
July 09, 2015 09:31AM

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.