Hosting Plan Hostgator Baby Plan

28 replies
Hello,

I am having problem with my sites. My hosting plan on Hostgator is baby Plan but mostly I get such errors:

Error establishing a database connection

Few days before when I deleted some posts from back end and then sites were working. But now again they are stopped working.

I need to upgrade my hosting or there is any way to resolve this?

is it server problem?

Best Regards.
#baby #hostgator #hosting #plan
  • Profile picture of the author kevbo22
    That error suggests that you are not connecting to the database. This shouldn't have anything to do with your hosting plan, unless your host does not provide php. Check your connection most likely in a config file.
    Signature

    The best path to prosperity is free market capitalism!

    {{ DiscussionBoard.errors[8536174].message }}
  • Profile picture of the author M@tt
    It could be a server problem or a script problem. Speak to their support team and hope for a fast/helpful reply
    Signature

    Matt Russell | CEO
    www.webhostingbuzz.com for 5 star US/UK web hosting
    And finally a reliable, honest hosting affiliate program. Warriors, join today at http://www.webhostingbuzz.com/affiliates.php

    {{ DiscussionBoard.errors[8536246].message }}
  • Profile picture of the author Kingfish85
    Error establishing a database connection
    This is almost indefinitely a Wordpress issue. You need to check your information inside the wp-config.php file to be sure the correct database, username & password is correct or that it even exists. I'd recommend contacting their support department if you're unsure what to do.
    {{ DiscussionBoard.errors[8536363].message }}
  • Profile picture of the author windowstoweb
    I received the below email:

    HostGator
    Ticket: CFT-25417144 - TOS/MySQL : gator2020.hostgator.com : whacky
    Hello,

    This message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved.

    Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.

    If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.

    ~~~
    Excessive MySQL activity is caused by (angel) a long-running process that locks a table, causing other queries to back up, (beer) a query that is not optimized ][example: select all from ... and involving a large or complex query], (coffee) huge table copies/maintenance during peak hours.

    NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it's best to backup any data before making any changes or adjustments.

    First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..

    Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles (Four Ways to Optimize Your MySQL Database - Developer.com - Developer.com and Optimizing MySQL: Queries and Indexes — DatabaseJournal.com). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.

    If you reply back to this with your IP address (Web Hosting Services, Reseller Hosting, VPS Hosting, and Dedicated Servers by HostGator) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.


    CPU_TIME:810 table_rows_read:5106914 SELECTS:2536 ROWS_UPDATED:22 ROWS_FETCHED:51210 BUSY_TIME:1682 ONNECTED_TIME:1746 BYTES_SENT:3244032 BYTES_RECEIVED:331371 WAIT_TIME:872





    Top table row reads:

    DB_USER: whacky_wrdp4 -- TOTAL_CONNECTIONS: 34 -- CONNECTED_TIME: 1746 -- CPU_TIME: 810 -- TABLE_ROW_READS: 5106914 -- SELECT_COMMANDS: 2536 -- UPDATE_COMMANDS: -- BUSY_TIME: 1682 -- BYTES_SENT: 3244032 -- BYTES_RECEIVED: 331371 -- WAIT_TIME (IO): 872







    Top WAIT (IO) TIME:

    DB_USER: whacky_wrdp4 -- TOTAL_CONNECTIONS: 34 -- CONNECTED_TIME: 1746 -- CPU_TIME: 810 -- TABLE_ROW_READS: 5106914 -- SELECT_COMMANDS: 2536 -- UPDATE_COMMANDS: -- BUSY_TIME: 1682 -- BYTES_SENT: 3244032 -- BYTES_RECEIVED: 331371 -- WAIT_TIME (IO): 872









    Thu Sep 19 17:08:17 CDT 2013

    Running Processes:



    Running Queries:



    Open connections



    Current Site Requests:







    Best regards,

    Systems Monitoring Department
    HostGator.com
    To reply to this ticket, please be sure to email 25417144@tickets.hostgator.com from the email address you created the ticket with.
    {{ DiscussionBoard.errors[8536371].message }}
    • Profile picture of the author RobinInTexas
      Originally Posted by windowstoweb View Post

      I received the below email:

      HostGator
      Ticket: CFT-25417144 - TOS/MySQL : gator2020.hostgator.com : whacky
      Hello,

      This message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved.

      Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.

      If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.
      You probably have a poorly written plugin or too many plugins active on that website.

      Since they have disabled the database on that site, you probably cannot access your wordpress site to resolve the issue.

      Reply to the ticket and tell them you will disable all the plugins and work with them to diagnose and resolve the problem.
      Signature

      Robin



      ...Even if you're on the right track, you'll get run over if you just set there.
      {{ DiscussionBoard.errors[8536442].message }}
  • Profile picture of the author waqascheema
    if its wordpress the check your plugins .. else check you code
    {{ DiscussionBoard.errors[8536858].message }}
  • Profile picture of the author kpmedia
    While that's always possible -- bad plugins -- the fact remains that Hostgator is NOT a good host.
    The site would probably be fine at other (better) hosts that don't severely (ridiculously) limit resources.

    Originally Posted by kpmedia View Post

    Don't use
    - Godaddy
    - Yahoo
    - 1&1
    - the 50+ EIG brands, including Hostgator, Bluehost, Justhost, iPage, Fatcow, and a crapload others.

    Hostgator is garbage:
    - http://www.warriorforum.com/main-int...-my-sites.html
    - http://www.warriorforum.com/main-int...s-traffic.html
    - http://www.warriorforum.com/main-int...-all-down.html

    I have no idea why people still suggest that in 2013. It's terrible. It's not even the same "Hostgator" anymore, not since summer 2012, and is nothing more than an EIG brand now. There are better hosts.
    {{ DiscussionBoard.errors[8539848].message }}
    • Profile picture of the author fghaegele
      Originally Posted by kpmedia View Post

      While that's always possible -- bad plugins -- the fact remains that Hostgator is NOT a good host.
      The site would probably be fine at other (better) hosts that don't severely (ridiculously) limit resources.

      That's because resources are limited.

      I would never host with a company that would allow one user to such up 25% of CPU when I have hundreds of other businesses relying on that network, too.

      This is most likely poorly written plugin, and it is ultimately the responsibility of the developer to know that X page is making 500 roundtrips to the database, for example. It's not Hostgator's fault.

      Note: not a Hostgator fanboy. I prefer Hawkhost.
      Signature
      Take A Break. Play A Puzzle: Merlin's Puzzles
      {{ DiscussionBoard.errors[8539895].message }}
  • Profile picture of the author fghaegele
    TABLE_ROW_READS: 5106914

    That's why.

    You're trying to squeeze a Boeing 747 into a one car garage.
    Signature
    Take A Break. Play A Puzzle: Merlin's Puzzles
    {{ DiscussionBoard.errors[8539897].message }}
    • Profile picture of the author windowstoweb
      Originally Posted by fghaegele View Post

      TABLE_ROW_READS: 5106914

      That's why.

      You're trying to squeeze a Boeing 747 into a one car garage.
      Thanks for pointing. How may I solve this problem?

      Thanks
      {{ DiscussionBoard.errors[8563596].message }}
  • Profile picture of the author kpmedia
    HG limits resources more than Hawkhost does.
    {{ DiscussionBoard.errors[8542695].message }}
    • Profile picture of the author RobinInTexas
      I have a plan on hostgator migrated to Utah (or wherever they left Planet to) and probably more plugins than I should, but I'm not exceeding their allowances. The OP either has waay to much traffic or more likely, a really bad plugin that's overloading the server.
      Signature

      Robin



      ...Even if you're on the right track, you'll get run over if you just set there.
      {{ DiscussionBoard.errors[8542935].message }}
  • Profile picture of the author protto
    Originally Posted by windowstoweb View Post

    Error establishing a database connection
    This error can show up if
    1) mysql has been turned off
    2) database and/or database user doesn't exist
    3) database credentials in your application's configuration file are wrong

    I am sure there is more to this.
    {{ DiscussionBoard.errors[8543728].message }}
    • Profile picture of the author RobinInTexas
      Originally Posted by protto View Post

      This error can show up if
      1) mysql has been turned off
      2) database and/or database user doesn't exist
      3) database credentials in your application's configuration file are wrong

      I am sure there is more to this.
      Yepper... there is more you're just not looking, read the post from 2 days ago.

      Originally Posted by windowstoweb View Post

      I received the below email:
      ...
      This message is to advise you of a temporary block placed on your database.
      ...
      Signature

      Robin



      ...Even if you're on the right track, you'll get run over if you just set there.
      {{ DiscussionBoard.errors[8543956].message }}
  • Profile picture of the author Ian25
    I had too many problems with hostgator especially with downtime of my sites.
    {{ DiscussionBoard.errors[8543920].message }}
  • Profile picture of the author CareerProf
    Just an FYI, HostGator seems to be going downhill. I have been a loyal customer for years and now it seems they are having all types of problems. You may want to look at another hosting service. My email with there service has been down for a week and they cannot give me a timeframe when it will work. Good luck. Has anyone else been having problems with HostGator?
    {{ DiscussionBoard.errors[8570923].message }}
  • Profile picture of the author Diversion52
    I have a reseller account at Hostgator and I am EXTREMELY disappointed with the quality of the servers. I am now going to have to migrate all my sites somewhere else and that is going to be one hell-of-a job.

    - My sites commonly lose contact with the MySQL server, causing my sites to give the same "Unable to access MySQL database" error. When I contact the customer service (which I've done more times than I care to count in just 5 months) they tell me it's because someone else is using all the resources. Well maybe they should manage this a little better, instead of telling me that "it happens".

    - Recently I noticed that my sites do not work. I looked into it and could not figure out any reason why. I just got a 500 error with every site. Turns out none of my sites were visible in my country. They showed up when using a proxy, but I could not access them anywhere in my country. (These are all small business websites with absolutely no questionable material). Customer service told me that "unfortunately they are unable to assist me with this problem".

    - The response time for my websites are laughable. There's very commonly a 5-15 second wait time from refreshing the page until it even starts loading the content. The DNS is seriously lagging.

    - The only positive side I've found is that the customer service is pretty nice there, but the only reason I know that is because I need to talk to them constantly.

    I've tried to use Arvixe and my initial impression is better but still not up to par. I would also be interested in hearing opinions on good shared hosting providers. I'm not ready to get a private server yet.
    Signature
    The Powerfast Method - Get Power... Fast!

    Break The Ice and Swim - Master the art of social interaction!
    {{ DiscussionBoard.errors[8571089].message }}
    • Profile picture of the author Kingfish85
      Originally Posted by Diversion52 View Post

      I have a reseller account at Hostgator and I am EXTREMELY disappointed with the quality of the servers. I am now going to have to migrate all my sites somewhere else and that is going to be one hell-of-a job.

      - My sites commonly lose contact with the MySQL server, causing my sites to give the same "Unable to access MySQL database" error. When I contact the customer service (which I've done more times than I care to count in just 5 months) they tell me it's because someone else is using all the resources. Well maybe they should manage this a little better, instead of telling me that "it happens".

      - Recently I noticed that my sites do not work. I looked into it and could not figure out any reason why. I just got a 500 error with every site. Turns out none of my sites were visible in my country. They showed up when using a proxy, but I could not access them anywhere in my country. (These are all small business websites with absolutely no questionable material). Customer service told me that "unfortunately they are unable to assist me with this problem".

      - The response time for my websites are laughable. There's very commonly a 5-15 second wait time from refreshing the page until it even starts loading the content. The DNS is seriously lagging.

      - The only positive side I've found is that the customer service is pretty nice there, but the only reason I know that is because I need to talk to them constantly.

      I've tried to use Arvixe and my initial impression is better but still not up to par. I would also be interested in hearing opinions on good shared hosting providers. I'm not ready to get a private server yet.
      How many accounts do you have that need to be migrated? What types of sites are these as well?
      {{ DiscussionBoard.errors[8571100].message }}
    • Profile picture of the author kpmedia
      Originally Posted by Diversion52 View Post

      I have a reseller account at Hostgator a
      I've tried to use Arvixe and my initial impression is better but still not up to par.
      Then don't use unlimited hosts for $4 --- or reseller accounts from those hosts.
      Arvixe is good, but for reseller hosting, there are others.
      HostGator is EIG, and EIG sucks.

      Stablehost is my usual suggestion.
      Veerotech (kingfish above) is also very good. I use that one myself for reseller hosting!
      {{ DiscussionBoard.errors[8574723].message }}
  • Profile picture of the author E1one
    How can i have that such amazing plan
    {{ DiscussionBoard.errors[8571109].message }}
  • Profile picture of the author Affiliate Ninja
    I been having the same issues with CPU and my sites keep going down with Hostgator. Every time I bring up the issue they sound like a bunch of used car dealers trying to sell me on upgrades instead of fixing the issue.

    So I upgraded to see if they are correct...now they tell me I may need to go to a dedicated server because my sites are still down...That's strange my sites ran on a shared account for two years without any issues...It sounds like Hostgator is running a fundraiser over there.

    All my wordpress sites are up to date I have W3 Total Cache installed on all sites to help but I am starting to think it isn't my sites. I need a more professional hosting that's for sure.
    {{ DiscussionBoard.errors[8603888].message }}
    • Profile picture of the author tonyla
      I am running 30 blogs, 2 article directories, 5 addon domains close to 40 subdomains, and 15 squeeze pages, plus a ton of php script all under one account with lunar pages. Been with then 10years and never had a problen.
      {{ DiscussionBoard.errors[8604038].message }}
    • Profile picture of the author Kingfish85
      Originally Posted by Affiliate Ninja View Post

      I been having the same issues with CPU and my sites keep going down with Hostgator. Every time I bring up the issue they sound like a bunch of used car dealers trying to sell me on upgrades instead of fixing the issue.

      So I upgraded to see if they are correct...now they tell me I may need to go to a dedicated server because my sites are still down...That's strange my sites ran on a shared account for two years without any issues...It sounds like Hostgator is running a fundraiser over there.

      All my wordpress sites are up to date I have W3 Total Cache installed on all sites to help but I am starting to think it isn't my sites. I need a more professional hosting that's for sure.
      Upgraded to what? The last I recall, the CPU/memory limits are the same between shared and reseller accounts...

      Its going to continue to be a finger pointing contest no matter what you do.
      {{ DiscussionBoard.errors[8604063].message }}
  • Profile picture of the author topnichewebsites
    Yes for HG doesn't matter what shared/reseller account they all have the same limiting CPU / Memory. Sounds to me its your sites not the account or your on a really bad server.

    1. Are they all wordpress sites
    2. If so do they all have the same plugins
    3. Did HG try to move your account to a different server
    Signature
    http://pixelcovers.com/ <- eBook add eCovers

    https://www.unicommercesolutions.com <- WordPress Websites and Maintenance
    {{ DiscussionBoard.errors[8605759].message }}
  • Profile picture of the author hostinghosted
    Best way is talk with hostgator customer support - they will solve the issue. Usually this issue comes with wordpress database.
    {{ DiscussionBoard.errors[8606597].message }}
  • go with high bandwith and high database space and related .. this is what i faced in past and it helped me to solve it ..

    - Dhawal
    {{ DiscussionBoard.errors[8608516].message }}
  • Profile picture of the author ViralMediaBoost
    May i ask what software do you use?
    {{ DiscussionBoard.errors[8615775].message }}

Trending Topics