Link to home
Start Free TrialLog in
Avatar of RAJAN BABU SUBBARAYAN
RAJAN BABU SUBBARAYAN

asked on

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

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?
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Is this part of a web site?  Is there a scripting language involved?  Any other clues you can give us will definitely help!
Avatar of RAJAN BABU SUBBARAYAN
RAJAN BABU SUBBARAYAN

ASKER

.net framework and yes this is part of website involved.
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
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?