Portal Home > Knowledgebase > Articles Database > Windows - mySQL too many connection..
Windows - mySQL too many connection..
| Posted by justify, 07-15-2008, 06:45 AM |
| Hello,
I have win2003 server and running plesk 8.4, there is a website on it and it gives me error with mysql max_connection even I set the limit 1 million or 10000 no matters.
What can I do?
Thanks in advance.
|
| Posted by The Universes, 07-15-2008, 12:22 PM |
| You can narrow it down to which mysql user is making all the connections and then look for a script that isn't closing connections or something.
If you have phpmyadmin, login as the root/admin user and then click on Processes or use the query "SHOW PROCESSLIST"
|
| Posted by justify, 07-15-2008, 02:38 PM |
| Hello,
We know what account is causing this but do ytou think it's related to scripting?
Regards
|
| Posted by The Universes, 07-15-2008, 02:49 PM |
| Also, have you verified that the max connections change was successful? You can go into the "Show MySQL system variables" page of phpMyAdmin and search for "max connections" to check.
But yes, it can be related to scripting. However since you said you set it to 1M, it seems more likely the change wasn't reflected in mysql.
|
Add to Favourites 
Print this Article
Also Read
