I got this from my host.................

csampson1Advanced

1802 posts

We are not programmers, so we can't give you exact details on what exact lines/functions need to be changed or modified to avoid this issue in the future, but basically the script at

mycommunity/profile.php is either spawning a ton of child processes of itself, or being requested quite a lot. And the MySQL queries that it's firing off are not being ended properly, and instead just being put "to sleep", awaiting further queries or transactions.

-----------------------------------------------------------------------------------------------------------------------------------------

These could be related, in that the MySQL queries aren't being ended properly, so the PHP process itself doesn't die off when it should have, so when profile.php is requested again, it fires off another PHP process, another batch of MySQL queries, and this repeats again and again.

-----------------------------------------------------------------------------------------------------------------------------------------
If you recently updated the profile.php script, or whatever forum/CMS/program it's associated with, I would recommend starting there, and checking with the developer of that script to see exactly what changed. It could just be a bug in the code causing the MySQL queries to sleep instead of disconnect.

-----------------------------------------------------------------------------------------------------------------------------------------

Please advise on how to stop this as the system gets a great deal of attention the site has issues because of the above...........when I get a great deal of people on the site and they are using the site it brings it down............can anyone tell me how to end these and not have them sleep, I would assume they need to die?

Csampson

Quote · 21 Sep 2011

deano92964Premium

10772 posts

Possible topic that might be of some help. I have not been able to find anything.

http://www.boonex.com/forums/?action=goto&search=1#topic/Mysql-connections-are-being-left-open-Any-advice-why.htm

https://www.deanbassett.com

Quote · 21 Sep 2011

DosDawgPremium

3696 posts

We are not programmers, so we can't give you exact details on what exact lines/functions need to be changed or modified to avoid this issue in the future, but basically the script at

well thats just not very nice of them is it. they should fix it after all you are paying them to host your site. isnt that what you thought they were going to do when you paid them for your dedicated server?

well hope things work out.

and good luck with all of that.

typically a query should last about .0002 nanoseconds, if you disable persistent connections, then that should resolve the sleeping dogs.

though there seems to be something that has changed, and what is apache saying, i see that mysql is having issues, but what do you see when you restart the server and the requests start, because that is where the problem is at. there is apparently a LOD (loop of death), the fact that persistent connections are on, does not help the matter much, and your max connections on my.cnf are probably too low to handle the continued requests.

but your hosting company should know that, it doesnt take a programmer to understand connections.

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support

Quote · 21 Sep 2011

Reply ›

I got this from my host.................

Blogs

Help

Product

Company