sleeping connections

[knat]

ok that makes no sense to me.. i got the script from SMF and it runs fine on my server.. guess you cant use it then.. sorry bout that m8.. i hope you solve your problem anyway 

For your information i can tell that i only have one sleeping connection running on my forum 

[bulldog988]

ok that makes no sense to me.. i got the script from SMF and it runs fine on my server.. guess you cant use it then.. sorry bout that m8.. i hope you solve your problem anyway 

For your information i can tell that i only have one sleeping connection running on my forum 

hi,

i can use it... i got this informations...

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

Basic Information
August 16, 2007, 07:24:38 AM
Operating System: Microsoft Windows

MySQL processes
Total processes: 2 (1 sleeping, 1 running, 0 locked)

MySQL Statistics
MySQL 4.1.x
Connections per second:  6.1062 
Kilobytes received per second:  8.663 
Kilobytes sent per second:  33.8354 
Queries per second:  59.3542 
Percentage of slow queries:  0 
Opened vs. Open tables:
(table_cache)  44.9649 (should be <= 80) 
Table cache usage:
(table_cache)  1 (should be >= 0.5 and <= 0.9) 
Key buffer read hit rate:
(key_buffer_size)  0.0123 (should be <= 0.01) 
Key buffer write hit rate:
(key_buffer_size)  0.5417 (should be <= 0.5) 
Thread cache hit rate:
(thread_cache_size)  407.4287 (should be >= 30 ) 
Thread cache usage:
(thread_cache_size)  0.625 (should be >= 0.7 and <= 0.9) 
Temporary table disk usage:
(tmp_table_size)  0.0988 (should be <= 0.5) 
Sort merge pass rate:
(sort_buffer)  0.0019 (should be <= 0.001) 
Query cache enabled:
(query_cache_type)  1 (should be >= 1 and <= 1) 
Query cache miss rate:
(query_cache_limit)  0.2034 (should be <= 0.5) 
Query cache prune rate:
(query_cache_size)  0.3615 (should be <= 0.05) 

Show more information...

[knat]

You should run it when you have alot of users online

Total processes: 2 (1 sleeping, 1 running, 0 locked)

This looks fine to me

Anyway if you are on a shared server you will probably hear from you host again.

I was forced to upgrade my hosting plan because my forum was using to many server resources.. they will probably force you to do the same 

[bulldog988]

You should run it when you have alot of users online

Total processes: 2 (1 sleeping, 1 running, 0 locked)

This looks fine to me

Anyway if you are on a shared server you will probably hear from you host again.

I was forced to upgrade my hosting plan because my forum was using to many server resources.. they will probably force you to do the same 

hi,

thanks for the advice... one question is if i have many sleeping connections, how do i closed them?

[IchBin]

Thats why you need to figure out what is causing the sleeping connections. Once you figure that out we can go from there and see what needs to be fixed.

[bulldog988]

Thats why you need to figure out what is causing the sleeping connections. Once you figure that out we can go from there and see what needs to be fixed.

so u mean i need to run the status.php daily to see if there are any sleeping connections?

[IchBin]

No, you need to figure out why. How is a whole other question. You should continue your support thread at SMF as they know more the most here, and at this point it is SMF related more I think.

[bulldog988]

ok.. thanks for all the support here...