8 {{ upvoteCount | shortNum }}
8 {{ upvoteCount | shortNum }}

Beware of the fine print when choosing a HOST

by Mo Goulet
6 replies
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
#beware #choosing #fine #host #print
  • Profile picture of the author 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.
    Signature
    {{ DiscussionBoard.errors[3467764].message }}
    • Profile picture of the author Nick Garcia
      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.
      {{ DiscussionBoard.errors[3467791].message }}
    • Profile picture of the author tj
      Originally Posted by trishworks4u View Post

      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
      Signature
      BIG BRAND Copywriting - Sales Letters + Bonuses for Warriors. $97 - Guaranteed! | OFFER NOT CONVERTING ? Need People to take action NOW?
      {{ DiscussionBoard.errors[3468028].message }}
  • Profile picture of the author GeorgR.
    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... )
    Signature
    *** Affiliate Site Quick --> The Fastest & Easiest Way to Make Affiliate Sites!<--
    -> VISIT www.1UP-SEO.com *** <- Internet Marketing, SEO Tips, Reviews & More!! ***
    *** HIGH QUALITY CONTENT CREATION +++ Manual Article Spinning (Thread Here) ***
    Content Creation, Blogging, Articles, Converting Sales Copy, Reviews, Ebooks, Rewrites
    {{ DiscussionBoard.errors[3467848].message }}
  • Profile picture of the author RyanAndrews
    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.
    {{ DiscussionBoard.errors[3467921].message }}
  • Profile picture of the author Mo Goulet
    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
    Signature
    Domain Names For Sale. Make an Offer.
    {{ DiscussionBoard.errors[3468224].message }}

Trending Topics