My website overloading server!!

[Zetan]

Have you tried this tool:
http://www.simplemachines.org/download/index.php?thanks;filename=status.php

From SMF?

Simply put it in your public folder and direct your browser to it.

From my status.php

MySQL Statistics
MySQL 4.1.x
Connections per second:  1.4179 
Kilobytes received per second:  6.098 
Kilobytes sent per second:  98.5185 
Queries per second:  41.2608 
Percentage of slow queries:  0 
Opened vs. Open tables:
(table_cache)  20209.2813 (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.0196 (should be <= 0.01) 
Key buffer write hit rate:
(key_buffer_size)  0.4774 (should be <= 0.5) 
Thread cache hit rate:
(thread_cache_size)  2296.4109 (should be >= 30 ) 
Thread cache usage:
(thread_cache_size)  0.75 (should be >= 0.7 and <= 0.9) 
Temporary table disk usage:
(tmp_table_size)  0.1741 (should be <= 0.5) 
Sort merge pass rate:
(sort_buffer)  0 (should be <= 0.001) 
Query cache enabled:
(query_cache_type)  1 (should be >= 1 and <= 1) 
Query cache miss rate:
(query_cache_limit)  0.3829 (should be <= 0.5) 
Query cache prune rate:
(query_cache_size)  0.3509 (should be <= 0.05) 


etc.. etc..

[bloc]

Can only agree with others here, just links do not create queries. By looking at your index page I see 47 queries used. thats a little over normal, but not unusual since you are using among other things, random gallery images. Some other blocks as well might create more connections. But its not really extreme or anything, since you don't have too many visitors at any time either.

One thing that can contribute to it, is if you are using any mysql calls that DON'T use db_query..as that is NOT calculated into that info down on the page. It may then be quite a few extra..and certainly way too much. But again, for example simple webshop scripts use up to 70-100 connections on a page load, so its really a sign of the need to move to another host imho.

[bluedevil]

Thanx for all the inputs.  I turned off several links,blocks,etc.  The front page is a lot smaller than before.

My reply last night:

I made some changes but not sure if its enuff. Could you test again?

Theirs:

Hello Michaelangelo,

Thank you for following our recommendations.

Please allow us some time to review the current behavior of your web site and we will update this ticket shortly.

Thank you for your patience.

Best Regards,

Valentin
Support Team
SiteGround.com

Theirs:

Hello Michaelangelo,

Your web site performs much better now. Our system administrators reviewd its CPU and memory consumption and now everything seems to be so they removed the limitations from your account. We are now marking your case as resolved.

Should you have any further questions or comments, please do not hesitate to contact us and we will be happy to assist you!

Best Regards,

Valentin
Support Team
SiteGround.com

oh yeah....they offered me a dedicated server.   I think not!

[keith021773]

oh yeah....they offered me a dedicated server.   I think not!

I think that right there tells you what they wanted.       I do have 2 sites thru siteground.   I had my main site there too, but moved it because they started giving me problems..

Glad you got it worked out..

[IchBin]

Good news Blue! But as Keith said, it showed you what they really wanted.

[bluedevil]

You know?    I think i like how it looks now.  Less links in the front page. It doesnt look busy anymore.

I read somewhere that if having too many links in one page,spiders wont crawl it?

any truth to that?

[Ricky.]

Now your page is pretty fine.. .102 sec to create index page..
Can you tell me what actually u did and what was real cause of problem ?

This is becs I am somehw now in same condition but I m not on shared host.. but on dedicated but I have to take care about my server.. isn't ?

[IchBin]

If you read up a couple of posts you'll see that he tells you exactly what he did.

[Ricky.]

Ya .. I read that just after posting !!