Using too many resources?

[jbear6]

I have a 2.26 vB installation that has been at the same host for three years now. All of a sudden, out of the blue, I get hit with a "Suspended Page" Error page, where my website used to be. They claim I am using too many resources. Our membership has been "halved" in the last two years, and where we used to have 50 members on our Who's Online page then, we might average 15 - 20 members now. I haven't added any hacks in the last year, and page loading times average .50 seconds.

When I asked for some specific numbers on what was using all these extra resources, this is what I got back:

+--------+------------------+-----------+----------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------------------+-----------+----------------------+---------+------+-------+------------------+
| 128104 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 830 | | |
| 128429 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1550 | | |
| 129074 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1223 | | |
| 129942 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1466 | | |
| 132481 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 738 | | |
| 133200 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1122 | | |
| 134166 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1181 | | |
| 134348 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1602 | | |
| 134606 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 683 | | |
| 134723 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 473 | | |
| 134815 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1659 | | |
| 134838 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1538 | | |
| 134957 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 862 | | |
| 134987 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1089 | | |
| 135077 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 173 | | |
| 135082 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1064 | | |
| 135169 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1505 | | |
| 135262 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 353 | | |
| 135278 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1489 | | |
| 135282 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1489 | | |
| 135307 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1454 | | |
| 135411 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1429 | | |
| 135442 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1416 | | |
| 135569 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 601 | | |
| 135696 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1059 | | |
| 135807 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1265 | | |
| 135832 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1257 | | |
| 136024 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1179 | | |
| 136058 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1162 | | |
| 136099 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 1139 | | |
| 136145 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 382 | | |
| 136312 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 280 | | |
| 136461 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 417 | | |
| 136521 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 940 | | |
| 136678 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 855 | | |
| 136723 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 738 | | |
| 136891 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 751 | | |
| 136908 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 739 | | |
| 137063 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 601 | | |
| 137070 | bresso_adsenseai | localhost | bresso_adsenseairmp3 | Sleep | 650 | | |
| 137224 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 570 | | |
| 137241 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 561 | | |
| 137353 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 501 | | |
| 137665 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 330 | | |
| 137810 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 283 | | |
| 137850 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 272 | | |
| 137852 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 270 | | |
| 137974 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 221 | | |
| 138001 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 204 | | |
| 138028 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 2 | | |
| 138325 | jbear_vbdforu | localhost | jbear_vbdforum | Sleep | 26 | | |
| 138365 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 10 | | |
| 138368 | eximstats | localhost | eximstats | Sleep | 9 | | |
| 138376 | eximstats | localhost | eximstats | Sleep | 2 | | |
| 138377 | bresso_airmp3 | localhost | bresso_airmp3 | Sleep | 3 | | |
| 138379 | root | localhost | | Query | 0 | | show processlist |
+--------+------------------+-----------+----------------------+---------+------+-------+-----

Does this prove I am a server "resource hog"?

Thanks
Jbear6

[dstruct2k]

This proves you should turn on persistant_connections (config.php). That's all it shows.


The fact that all your processes are in "sleep" means you are using 0 resources. Your host isn't too bright if he can't figure that out himself.

[jbear6]

Originally Posted by dstruct2k

This proves you should turn on persistant_connections (config.php). That's all it shows.


The fact that all your processes are in "sleep" means you are using 0 resources. Your host isn't too bright if he can't figure that out himself.

Are you sure?
The man who sent me those numbers has this title after his name "SyAdmin | Tech Manager".

Thanks,
Jack

[Zachery]

Originally Posted by jbear6

Are you sure?
The man who sent me those numbers has this title after his name "SyAdmin | Tech Manager".

Thanks,
Jack

If anything you want to TURN OFF Persistant connections,

since your on a shared account it might be time to upgrade to vB3 as its much much less resource intensive.

[dstruct2k]

Whoops... Yeah, listen to Zach up there... :nervous:


I had the persistant connections function reversed in my mind.

[amykhar]

Have you added any new hacks within the past couple of months?

[dstruct2k]

Originally Posted by jbear6

... I haven't added any hacks in the last year, and page loading times average .50 seconds. ...

[Serge]

I have a question: By any chance are you hosted my hostrocket.com?

[Infopro]

Or webhosting network? They both like to use this line of BS.