Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
MrApples
New Member
New Member


Joined: Oct 03, 2004
Posts: 13

PostPosted: Mon Nov 01, 2004 9:02 pm Reply with quote

here is my dillemma:

I find that my hosting account was suspended because I crashed their dual xeon 2.8ht server... which i think is bogus but here is what they told me:
Quote:
Hi,

Your website was suspended because of mysql web server abuse. It caused the server to nearly crash.

| 335237 | whatsin | localhost | whatsin_whatsinyourbox | Query | 4 | closing tables | SELECT bid, imageurl, clickurl, alttext FROM nuke_banner WHERE type='0' AND active='1' LIMIT 0,1 |

There were about 45 or more of those in mysqladmin processlist and each of them exceeding 30 secs causing the server to crash. This is not acceptable on shared environment and thus as per TOS Only registered users can see links on this board! Get registered or login! we had to take this action and suspend the site.


My site has had quite a lot of traffic lately, averaging nearly 100 people on at any given time, many of them crawlers.

Please tell me what you think about this, and if there is any problem with that volume of sql requests.

Thanks in advance.
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Mon Nov 01, 2004 10:18 pm Reply with quote

Well, as a host myself, I can't see why they would be exceeding anything unless your host restricts the number of connections in a given period. I do not and I have a dual xeon with hyperthreading. I would demand that you host explain why a simple query like that would cause the mysql server to hang.
 
View user's profile Send private message
blith
Client


Joined: Jul 18, 2003
Posts: 977

PostPosted: Tue Nov 02, 2004 10:54 am Reply with quote

Or demand your money back and move to Only registered users can see links on this board! Get registered or login! !!
 
View user's profile Send private message Visit poster's website
TheosEleos
Life Cycles Becoming CPU Cycles


Joined: Sep 18, 2003
Posts: 960
Location: Missouri

PostPosted: Tue Nov 02, 2004 3:25 pm Reply with quote

^indeed

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website AIM Address ICQ Number
Mesum
Useless


Joined: Aug 23, 2002
Posts: 213
Location: Chicago

PostPosted: Wed Nov 03, 2004 11:33 am Reply with quote

Once any site starts to get busy, I always would recommend to move to a dedicated server. Find some ways to generate revenue by adding some adds or donation section. That is the best way to go.
 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©