Last Friday I got suspended from my hosting company. This was their message to me;
'Your site is indeed crashing the entire server. Please see the Stuch PHP processes of your site:
fordaar 800 0.0 0.3 135984 13624 ? S 04:03 0:00 /usr/bin/php /home/fordaar/public_html/index.php
fordaar 2611 0.0 0.3 135988 13624 ? S 04:04 0:00 /usr/bin/php /home/fordaar/public_html/index.php
fordaar 27129 0.0 0.3 135984 13616 ? S 06:20 0:00 /usr/bin/php /home/fordaar/public_html/index.php
fordaar 22923 0.0 0.3 135988 13620 ? S 06:17 0:00 /usr/bin/php /home/fordaar/public_html/index.php
fordaar 24150 0.0 0.3 135988 13620 ? S 06:18 0:00 /usr/bin/php /home/fordaar/public_html/index.php
fordaar 24793 0.0 0.3 135988 13616 ? S 06:19 0:00 /usr/bin/php /home/fordaar/public_html/index.php
And the database queries
| 591225 | fordaar_wrdp1 | localhost | fordaar_wrdp1 | Query | 44243 | Sending data | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' |
| 606102 | fordaar_wrdp1 | localhost | fordaar_wrdp1 | Query | 36338 | Sending data | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' |
| 608217 | fordaar_wrdp1 | localhost | fordaar_wrdp1 | Query | 35369 | Locked | SELECT option_value FROM wp_options WHERE option_name = 'siteurl' |
| 616039 | fordaar_wrdp1 | localhost | fordaar_wrdp1 | Query | 32044 | Locked | SELECT option_value FROM wp_options WHERE option_name = 'siteurl' |'
And so on. I think they mispelled stuch and meant stuck? Anyway they are saying that I was getting a lot of calls to index.php in a very short period of time - overloading the server, upsetting the others on my shared host.
I thought ok, clean up time, go through the plugins etc. So I got unsuspended to do the work - I uninstalled some plug-ins, checked the dbase calls per page (about 28 or so) and then ran WP clean to remove orphaned table entries. I then run WP optimize and optimized the dbase, even limiting the btev log to 1000 and purging, myphpadmin says the dabases checked ok. My site is small with but 20-30 hits a day, but I do have a WPG2 embedded installation with about 1000 pictures, and finally rewrites enabled both sides. I was about to run WP supercache when they suspended me Monday morning this time more permanently for similar obnoxious behaviour (er server loading)
So we're at an impasse - they say my site is loading too much but I can't see what I'm doing wrong. What other things can I look for?
Could it be something to do with rewrites?
Do I post up who the host is?
All help suggestions feedback appreciated