We help IT Professionals succeed at work.

Mysql connections are nearly 10 million, what could be the reason and how to solve

424 Views
Last Modified: 2014-10-09
Mysql connections found 10 million  by using query "Show status like '%onn%'". Thread connections showing more than 10 million. What can be done to bring to normal and how much connections can a Mysql database server handle?
Comment
Watch Question

Most Valuable Expert 2011
Author of the Year 2014

Commented:
Is this part of a web site?  Is there a scripting language involved?  Any other clues you can give us will definitely help!

Author

Commented:
.net framework and yes this is part of website involved.
Most Valuable Expert 2011
Author of the Year 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for the response and How to enable the console message to every connection made - any link to understand it.  
Does the mysql connections overloading compensated by any mysql.ini file settings change?

Author

Commented:
Any update for the question

Thanks for the response and How to enable the console message to every connection made - any link to understand it.  
Does the mysql connections overloading compensated by any mysql.ini file settings change?
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.