sleeping connections

[bulldog988]

hi,

my db was suspended by my ISP due to tons of sleeping connections..

as i am a noob... i do not know what to do..

can anyone here kindly help me out?

[IchBin]

Your ISP? Do you mean your host?

[bulldog988]

Your ISP? Do you mean your host?

yes.. my host server suspended my db. they say there are tons of sleeping connections which is holding tons of resources from the cpu..

[bulldog988]

btw, what is sleeping connections? i am noob.. dunno much about mysql..

can someone kindly help me? my phone sms is beeping from morning till now.. asking why cannot access the webby...

[G6Cad]

I think this is more SMF related then TP, so i suggest you ask over at simplemachines.org.
Sleeping connections = when functions in the forum doesent release the connection to the database and keep them self open and with that you use up the recourses of the server for no good at all.

Check your Admin/Configuration/Server settings and make sure you doesent have "Use a persistent connection" checked there.

If you have more questions you will have to ask them on SMF forums.

[bulldog988]

hi,

this is the reply i got from my host...

I have put back your database. Please try fix the problem. In the meantime we suggest you put up a maintain notice on your web before you tackle down the problem.

Connection is establish when your web application connect with the MySQL database. Once it complete the query, the script should close the connection right away. It keeps the number of connections small and all the query much faster.

In this case, your MySQL have a lot of connections and cause entire server hang. You can check the number of connections via login Hosting Control Panel -> Databases -> MySQL Admin -> Current connections.

If we find the same problem again, we have no choice but stop your database again to maintain overall server performance. Thanks.

is this smf or tinyportal issue?

[bulldog988]

I think this is more SMF related then TP, so i suggest you ask over at simplemachines.org.
Sleeping connections = when functions in the forum doesent release the connection to the database and keep them self open and with that you use up the recourses of the server for no good at all.

Check your Admin/Configuration/Server settings and make sure you doesent have "Use a persistent connection" checked there.

If you have more questions you will have to ask them on SMF forums.

hi G6,
the "use a persistent connection" is never check.

[G6Cad]

Do as you host say, check what connections that are active and there you will see if and what holds the connection.
And again, post your questions on simplemachines.org as you will have more help there then here.

[knat]

Upload this file to the root of your forum and run it from a browser.. it will tell you alot about what your SMF ressource usage 

[bulldog988]

Upload this file to the root of your forum and run it from a browser.. it will tell you alot about what your SMF ressource usage 

hi,

i got this error when i run the status.php.

Warning: shell_exec() [function.shell-exec]: Unable to execute 'ver' in C:\hosting\webhost4life\member\tfntennis\smf\status.php on line 464