News: TinyPortal Release Schedule. Please read this update for More Info.

Login  |  Register
HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

August 21, 2019, 10:31:02 AM

Login with username, password and session length

Recent

Members
  • Total Members: 3751
  • Latest: tom888
Stats
  • Total Posts: 188690
  • Total Topics: 20745
  • Online Today: 68
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 1
Guests: 24
Total: 25

Author Topic: My website overloading server!!  (Read 21834 times)

0 Members and 1 Guest are viewing this topic.

Offline Zetan

  • Friends
  • *
  • Posts: 3471
Re: My website overloading server!!
« Reply #10 on: October 12, 2007, 02:04:38 AM »
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

Quote
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..

Offline bloc

  • Founder
  • *
  • Posts: 5216
    • Bloc
Re: My website overloading server!!
« Reply #11 on: October 12, 2007, 02:48:58 AM »
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

  • Guest
Re: My website overloading server!!
« Reply #12 on: October 12, 2007, 10:32:43 AM »
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:
Quote
I made some changes but not sure if its enuff. Could you test again?

Theirs:
Quote
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:
Quote
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

  • Guest
Re: My website overloading server!!
« Reply #13 on: October 12, 2007, 01:46:36 PM »
Quote
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..

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: My website overloading server!!
« Reply #14 on: October 12, 2007, 05:38:09 PM »
Good news Blue! But as Keith said, it showed you what they really wanted. :)

bluedevil

  • Guest
Re: My website overloading server!!
« Reply #15 on: October 12, 2007, 09:39:40 PM »
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.

  • Guest
Re: My website overloading server!!
« Reply #16 on: December 14, 2007, 12:28:22 AM »
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 ?:)

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: My website overloading server!!
« Reply #17 on: December 14, 2007, 09:20:01 AM »
If you read up a couple of posts you'll see that he tells you exactly what he did.

Ricky.

  • Guest
Re: My website overloading server!!
« Reply #18 on: December 19, 2007, 06:18:09 AM »
Ya .. I read that just after posting !!