MySQL crashed @ HostRocket.com! What should I do?

[esoin]

I received this message from there tech-support

Looking at the notes on your account, it says you were suspended because your account was using too much of the servers resources. It specifically noted your message board which often has 40 concurrent users.

and


It wasnt shut down because of bandwidth usage, it was because of mysql usage... your site was using more than the rest of the server combined.

I currently have a plan that lets me have:
15gig bandwidth
300mb of space
It's the corp. plan @ this website http://hostrocket.com/v1/hosting_plans.html

What should I do? Find another host? Will I be expected to pay much more so it will handle all the users on my vB? Any suggestions are apreciated!! thank you much

-esoin

[Martin]

have you tried turning off persistent connections?

I would definitely move to a different hosting company...

[nuno]

I currently have a plan that lets me have:
15gig bandwidth
300mb of space

wow, and they suspended your account??
damn, how many members do you have??

[Philipp]

Yes, disable the persistent connections to MySQL (config.php -> $usepconnect = 0; ) that might help.

If you are looking for another provider check out Tera-Byte http://www.tera-byte.com/hosting.html

[brendan]

The site he was running would often have 40+ concurrent users at a time, which is definatly approaching dedicated server level very quickly.

-Brendan

[OneChance]

Brendan, is that something you tell your new subscribers? I couldn't find anything about a concurrent users limit on your web site. Or do you set 40 as an arbitrary number and surprise customers by shutting them down when they reach that limit? Why not a warning first? or am I reading wrong and you actually did give warning? Give the customer a day or two to do something about the problem. I can't believe you actually shut someone down without warning when they reach some limit that they knew nothing about. You guys are more professional than that. Anyway, here's a recent thread (http://forums.hostrocket.com/showthread.php?threadid=1937) discussing this very topic at HR.

[tubedogg]

If you read around about hosting before signing up, you will find that most virtual hosts limit you to 20 to 30 concurrent users. It is an industry standard. You get what you pay for. Hosts can't really afford to let you use more resources than that, because you would be monopolizing the server and that's not fair to their other customers. If you need more connections, you need to look at semi-dedicated, dedicated or co-located servers.

If you are hitting that many MySQL connections, it's not like other problems where you can correct it (e.g. you are over your alloted space or bandwidth), it's something that usually has to be taken care of immediately or it jepordizes the server for the rest of the customers using it. Also suspending != kicking off, which you are making it sound like. Suspending an account allows the server to return to normal while the host talks to the user about it.

40 is hardly an arbitrary number. It's on the very high end of shared-server MySQL usage. If you are going to run something like that, you are expected to do your homework on the subject.

[OneChance]

I agree there should be a limitation, but the limitation should be stated upfront. I'd figure that the average user has no idea to even ask a question about concurrent users since there was no mention of it on the provider's web site nor in the customer's contract.

[tubedogg]

It is stated in the contract/TOS/AUP whatever you want to call it. There are clauses in every agreement that allow them to shut you down for excessive use of server resources. I can't for the life of me find the TOS on HR's site but I'm willing to bet money it has a clause similar to that.

[Nicholas Brown]

Well, if you are gonna have 40+ concurrent users, you shouldnt even consider shared hosting.

I think Brendan did the correct thing by closing your site down.



Servers are filled to a responsible capacity as determined by our server admins, and then carefully monitored and maintained at a safe level to ensure a positive hosting environement for all of our customers


:)

[auto]

guys, stop with the dedicated talks :D

i honestly think this is BS that a person has to get a dedicated for 40 concurrent users or whatever.

My site:
http://www.automotiveforums.com/vbulletin/index.php

is NOT on a dedicated server, our message board alone has a record of 129 simultanous users, usually its around 60-70 [less of weekends]

and www.hostmatters.com , my host has no problem with my site taking "too much resources" or whatever you guys call it. :D

40 concurrent doesnt ring a bell to get a dedicated for me :rolleyes:
you just have to find an honest host.
hosts will try to tell you to move to a dedicated when your site begins to grow so they will get more money, thats all.

[auto]

oh btw,
couple of days ago HM contacted me by ICQ :


I also wanted to talk to you about a new server that we have. And what we would like to do is move you to the new server. The reason for this is that the server is faster. It's a PIII 800. And we are going to have a better control panel on it that will allow you to set up subdomains yourself, FTP accounts, extra databases, etc.


They're going to move my account to a brand new server they just got which is even better than the one they have me on right now at no charge to "maintain a safe level to ensure a positive hosting environement for all of our customers" as Hostrocket puts it. :p

See, here's an honest host, HM doesnt kick people out, they are supposed to host you, and that is what they do.

[Steve Machol]

Wow auto!

My hosts deletes my entire web site while making a DNS change and doesn't even bother to apologize.

I'm jealous. :D

[auto]

Really, Stephanie and Annette are doing such a great job at HM its amazing :)

[HRSurvivor]

Wow,

Thanks for all the good hosting suggestions guys. Unfortunately for me I bought six months with HR. I intend to move my site. But so the six months I've paid for doesn't go completely to waste I've used it for a Hostracket Survivor support group.

at: HostRocket Hell (http://66.78.8.167/~crvstcom/)

I'm collecting survivor stories to fill it with for the next six months.

-John

[JohnM]

I personally have used HostRocket for awhile, and the only problem I had was when the server I was on crashed, but they restored all files and data, and upgraded my account for no extra charge :)

[wert]

Originally posted by HRSurvivor
Wow,

Thanks for all the good hosting suggestions guys. Unfortunately for me I bought six months with HR. I intend to move my site. But so the six months I've paid for doesn't go completely to waste I've used it for a Hostracket Survivor support group.

at: HostRocket Hell (http://66.78.8.167/~crvstcom/)

I'm collecting survivor stories to fill it with for the next six months.

-John :rolleyes:Smellin' the not so sweet scent of excessive Melodrama:rolleyes:

[Nicholas Brown]

Originally posted by auto
oh btw,
couple of days ago HM contacted me by ICQ :

They're going to move my account to a brand new server they just got which is even better than the one they have me on right now at no charge to "maintain a safe level to ensure a positive hosting environement for all of our customers" as Hostrocket puts it. :p

See, here's an honest host, HM doesnt kick people out, they are supposed to host you, and that is what they do.

I know Anna and Steph have just got that server at the NAC Datacenter through Site5.
<rant>
They may honor to this, I dont know - but remember that its a brand new box with our many people on it - it may change once it starts to fill up.

What you have to remember is that there may be other high SQL users on a box - and 1 or more user(s) cant be allowed to slow things down for everyone else.
</rant>

Annette, Stephanie, I am not doing an attack against you or your company which I have had very good things about (keep up the good work, our industry needs more people like yourselves) - I was just uisng it as an example.

[HRSurvivor]

Originally posted by wert
:rolleyes:Smellin' the not so sweet scent of excessive Melodrama:rolleyes:

Sniff. Sniff. Nope, just way too much team spirit. It was a much simpler world when little ones like you just hung out on gaming forums trolling the adults once in a while and didn't think cheerleading for their bogus hosting services was a past time.

[Steve Machol]

HRSurvivor,

Hmmm...I've certainly had some problems with Hostrocket, but don't even think of adding me to your list of horror stories.

All in all Hostrocket is an excellent web hosting company. Perfect? No, of course not! But they are usually very responsive and most of the problems I've seen have been direcly related to problems at VDI.

[wert]

Originally posted by HRSurvivor


Sniff. Sniff. Nope, just way too much team spirit. It was a much simpler world when little ones like you just hung out on gaming forums trolling the adults once in a while and didn't think cheerleading for their bogus hosting services was a past time. Gaming forums? Um... No. Not cheerleading at all actually. Have had my share of trouble with them, which they resolved. Are they perfect? Near perfect? No! They're ok though.

I'm comfortable with the fact that I don't have to stoop to the infantile name calling that you seem to hold so dear.

At age 35, I do know the smell of incessant whining when I hear it... :rolleyes:

[HRSurvivor]

Originally posted by wert
Gaming forums? Um... No. Not cheerleading at all actually. Have had my share of trouble with them, which they resolved. Are they perfect? Near perfect? No! They're ok though.

At least I'm comfortable with the fact that I don't have to stoop to the infantile name calling that you seem to hold so dear.

At age 35, I do know the smell of incessant whining when I hear it... :rolleyes:


Well, I haven't actually called anybody names... yet. And the only whining I've seen in our conversation is the above and this:

"Smellin' the not so sweet scent of excessive Melodrama"

(It’s not hard to recognize).

I personally don't like whining of this sort or any sort. I don't like being called a "whiner" (or "melodramatic" or "infantile") by people such as yourself either (you don’t seem to be able to STOP yourself from “stooping to the level” of name-calling).

But when I look at that crappy, mediocre drivel you refer to as "art" it does make me want to cry. :)

-John

P.S. I'll try and remember to put smiley faces next to all the jokes from now on so you don't get your panties in a knot.

[wert]

Originally posted by HRSurvivor
Well, I haven't actually called anybody names... yet. Er. Do you read your own posts? Calling me a "little one" "troll" and "cheerleader" isn't name calling?


I personally don't like whining of this sort or any sort. I don't like being called a "whiner" (or "melodramatic" or "infantile") by people such as yourself either (you don’t seem to be able to STOP yourself from “stooping to the level” of name-calling).Actually, it has more to do with your actions than anything else. You posted some *very* dramatic, borderline ridiculous attack on a company without backing it up with facts and you get upset when someone calls you on it? I in no way apology for poking a little fun at your post.


But when I look at that crappy, mediocre drivel you refer to as "art" it does make me want to cry. :)

-John

P.S. I'll try and remember to put smiley faces next to all the jokes from now on so you don't get your panties in a knot. I guess nothing can ever rise to the artistic level of your inane attempts at sarcasm. :D :cool: :D

*thinking that my "ignore user list" is about to grow by one "adult"*

[HRSurvivor]

"Smellin' the not so sweet scent of excessive Melodrama"

Again, here's where it all began for you and me "wert". I said nothing disrespectful to you, never had any beef with you, never said anything bad about your mother. Heck, I never even knew you existed until you decided it would be fun to take a shot at me.

It's ok if going around looking for opportunities to insult people gives you pleasure. If that's what floats your boat, hey! go for it.

Your game, your rules. NOT MINE. I don't really like doing the "anything goes" dance with people like you. Don’t you guys ever get bored with this crap?

p.s. I know! You can insult people and then squelch them, yeah that'll help. :)

[wert]

Originally posted by HRSurvivor .

It's ok if going around looking for opportunities to insult people gives you pleasure. If that's what floats your boat, hey! go for it. So, I guess you're trying to turn it around now. I get called "troll" "cheerleader" and "little one" This came after I *justifiably* poked some fun at your oh-so-dramic "survivors" post. Why would you post such unmitigated nonsense if you didn't expect people to react to it. And you call 'me' a troll?



Your game, your rules. NOT MINE. I don't really like doing the "anything goes" dance with people like you. Don’t you guys ever get bored with this crap? Hm. I never get bored when I see folks acting badly online. Obvously, you have some unresolved anger issues here. Why else would you try to start a site called "HostRocket Hell" and look for "Survivor Stories" unless you have some unresolved desire to strike back at your former host. I called you on it because it was a ridiculous and not very fair post. If you can't deal with that, then I guess it's your future phychiatric bills.


p.s. I know! You can insult people and then squelch them, yeah that'll help. :) I don't need to insult you. I would rather have folks read your your somewhat incoherent :rolleyes:wisdom:rolleyes: and let it speak for itself...

[Nicholas Brown]

ok - kill this now - :p

[Mike Sullivan]

Yes, we don't really need this here anymore.