Beware of the fine print when choosing a HOST

Mo Goulet · 03-03-2011, 03:25 PM

I just got finished chatting with hostgator regarding a mysql error visitors have been receiving occasionally upon visiting my website. I purchased the special they ran last November and paid for 2 years in advance. I have been hosting my websites on Liquid Web for over 7 years and did not run into this problem one time.

If anyone can offer some advice on my part other than their simple "optimize or upgrade" solution, please let me know.

At this point, I'm going to simply move the domains I've put on Hostgator back to Liquid Web.

This is a copy of the chat....My question was why I was getting mysql errors 25% of the time when accessing one of my blogs. Error establishing a database connection

(04:00:45 PM) Timothy Po: It is hitting the 25 mysql connection limit
(04:00:59 PM) Maurice: How do we fix that
(04:03:07 PM) Timothy Po: You would have to optimize your wordpress or upgrade to a vps/dedicated server
(04:03:42 PM) Maurice: optimize your wordpress?
(04:04:56 PM) Maurice: I moved from Liquid Web to Hostgator and now I have to do something to make my stuff work?
(04:04:57 PM) Timothy Po: Make it more efficient, removing plugins,
(04:05:03 PM) Timothy Po: Using caching plugins
(04:08:22 PM) Timothy Po: Those errors just mean that the wordpress script is hitting the mysql connection limit which is 25 concurrent connections
(04:10:27 PM) Maurice: In 9 years this has not happened on Liquid Web and in the first month since I transferred the domain over I am getting these errors. Why was this not advised on your website before customers make the decision to buy?
(04:11:59 PM) Timothy Po: MySQL connection limits, processor limits « HostGator.com Support Portal
(04:12:02 PM) Timothy Po: It is pre sales

trishworks4u · 03-03-2011, 04:21 PM

no advice other than to leave. I honestly do not understand the love affair that people around here have w/ HG. I absolutely can't stand those turkeys and have had so many bad experiences with them it's just mind-boggling.

and yes, like a complete buffoon, I keep going back. I have 20+ hosting accounts so I figure "why not". I, too, signed up again on black friday. I put 1 Site on that account last week that's set up for 50G/500G and the thing takes minutes to load if it ever does at all. I have to move it now before launching a PPC campaign or i'll be screwed on the QS. HG blows.

Nick Garcia · 03-03-2011, 04:26 PM

I've been with HostGator for a few years and I haven't run into any serious problems like what you describe. My sites have never been down, either. Maybe I've just been lucky! Still, it makes me wonder what I could gain by going with another hosting company.

GeorgR. · 03-03-2011, 04:39 PM

Hello,

this is why i avoid such mainstream hosters usually.

The MySQL limit makes sense, especially in a shared hosting environment. Imagine zillions of users WITH YOU hosting their blogs and bogging down the server.

It is hardly the better alternative if a couple autoblogs from OTHER people would affect all other sites, including yours.

Wordpress can be a ****ch when it comes to CPU usage, and especially MySQL database accesses.

Therefore sooner or later you WILL want to move up to a VPS. Its simply impossible to grant every user on SHARED hosting unlimited resources...shared really only goes "so far".

It takes only a few sophisticated plugins on Wordpress and you will VERY quickly reach the cap what shared hosting resources can tolerate.

(I speak of experience, remember that one time when i had scripts running which affected a whole hosting company

They needed to spend LOTS of money on techs for trouble shooting to find out it was one of my sites basically shutting down their service.... ugh...

)

RyanAndrews · 03-03-2011, 04:58 PM

I assume your using WP Super Cache, or other caching solution. Caching is really the best way to stop the database being hit so much. Most connections would then only be for write activity such as commenting.

tj · 03-03-2011, 05:31 PM

Quote:

Originally Posted by trishworks4u

no advice other than to leave. I honestly do not understand the love affair that people around here have w/ HG. I absolutely can't stand those turkeys and have had so many bad experiences with them it's just mind-boggling.

and yes, like a complete buffoon, I keep going back. I have 20+ hosting accounts so I figure "why not". I, too, signed up again on black friday. I put 1 Site on that account last week that's set up for 50G/500G and the thing takes minutes to load if it ever does at all. I have to move it now before launching a PPC campaign or i'll be screwed on the QS. HG blows.

Not the best advice you're giving here. Other providers have a similar limit on the mysql limitation.

Timo

Mo Goulet · 03-03-2011, 06:22 PM

I've had the same site on Liquid Web for 7 plus years and never had a problem. 3 weeks on HG and wham...going back this w/e

03-03-2011, 03:25 PM	#1
Mo Goulet YadaText.com War Room Member Join Date: Jun 2005 Posts: 879 Thanks: 27 Thanked 102 Times in 79 Posts	Beware of the fine print when choosing a HOST I just got finished chatting with hostgator regarding a mysql error visitors have been receiving occasionally upon visiting my website. I purchased the special they ran last November and paid for 2 years in advance. I have been hosting my websites on Liquid Web for over 7 years and did not run into this problem one time. If anyone can offer some advice on my part other than their simple "optimize or upgrade" solution, please let me know. At this point, I'm going to simply move the domains I've put on Hostgator back to Liquid Web. This is a copy of the chat....My question was why I was getting mysql errors 25% of the time when accessing one of my blogs. Error establishing a database connection (04:00:45 PM) Timothy Po: It is hitting the 25 mysql connection limit (04:00:59 PM) Maurice: How do we fix that (04:03:07 PM) Timothy Po: You would have to optimize your wordpress or upgrade to a vps/dedicated server (04:03:42 PM) Maurice: optimize your wordpress? (04:04:56 PM) Maurice: I moved from Liquid Web to Hostgator and now I have to do something to make my stuff work? (04:04:57 PM) Timothy Po: Make it more efficient, removing plugins, (04:05:03 PM) Timothy Po: Using caching plugins (04:08:22 PM) Timothy Po: Those errors just mean that the wordpress script is hitting the mysql connection limit which is 25 concurrent connections (04:10:27 PM) Maurice: In 9 years this has not happened on Liquid Web and in the first month since I transferred the domain over I am getting these errors. Why was this not advised on your website before customers make the decision to buy? (04:11:59 PM) Timothy Po: MySQL connection limits, processor limits « HostGator.com Support Portal (04:12:02 PM) Timothy Po: It is pre sales

03-03-2011, 04:21 PM	#2
trishworks4u Floating Warrior War Room Member Join Date: Dec 2008 Location: St. Petersburg, FL Posts: 484 Thanks: 45 Thanked 86 Times in 72 Posts Social Networking Contact Info	Re: Beware of the fine print when choosing a HOST no advice other than to leave. I honestly do not understand the love affair that people around here have w/ HG. I absolutely can't stand those turkeys and have had so many bad experiences with them it's just mind-boggling. and yes, like a complete buffoon, I keep going back. I have 20+ hosting accounts so I figure "why not". I, too, signed up again on black friday. I put 1 Site on that account last week that's set up for 50G/500G and the thing takes minutes to load if it ever does at all. I have to move it now before launching a PPC campaign or i'll be screwed on the QS. HG blows.

03-03-2011, 04:26 PM	#3
Nick Garcia Part FireSpinner,Part SEO War Room Member Join Date: Jul 2008 Location: Earth (on the left side next to a tree) Posts: 65 Thanks: 23 Thanked 17 Times in 12 Posts Social Networking Contact Info	Re: Beware of the fine print when choosing a HOST I've been with HostGator for a few years and I haven't run into any serious problems like what you describe. My sites have never been down, either. Maybe I've just been lucky! Still, it makes me wonder what I could gain by going with another hosting company.

03-03-2011, 04:39 PM	#4
GeorgR. Senior Warrior Member War Room Member Join Date: Jun 2007 Location: Earth Posts: 6,061 Blog Entries: 16 Thanks: 72 Thanked 915 Times in 602 Posts Social Networking	Re: Beware of the fine print when choosing a HOST Hello, this is why i avoid such mainstream hosters usually. The MySQL limit makes sense, especially in a shared hosting environment. Imagine zillions of users WITH YOU hosting their blogs and bogging down the server. It is hardly the better alternative if a couple autoblogs from OTHER people would affect all other sites, including yours. Wordpress can be a ****ch when it comes to CPU usage, and especially MySQL database accesses. Therefore sooner or later you WILL want to move up to a VPS. Its simply impossible to grant every user on SHARED hosting unlimited resources...shared really only goes "so far". It takes only a few sophisticated plugins on Wordpress and you will VERY quickly reach the cap what shared hosting resources can tolerate. (I speak of experience, remember that one time when i had scripts running which affected a whole hosting company They needed to spend LOTS of money on techs for trouble shooting to find out it was one of my sites basically shutting down their service.... ugh... )

03-03-2011, 04:58 PM	#5
RyanAndrews The Biggest Advert Online Join Date: Feb 2011 Location: UK Posts: 102 Thanks: 8 Thanked 12 Times in 12 Posts	Re: Beware of the fine print when choosing a HOST I assume your using WP Super Cache, or other caching solution. Caching is really the best way to stop the database being hit so much. Most connections would then only be for write activity such as commenting.

03-03-2011, 06:22 PM	#7
Mo Goulet YadaText.com War Room Member Join Date: Jun 2005 Posts: 879 Thanks: 27 Thanked 102 Times in 79 Posts	Re: Beware of the fine print when choosing a HOST I've had the same site on Liquid Web for 7 plus years and never had a problem. 3 weeks on HG and wham...going back this w/e