Hosting Plan Hostgator Baby Plan

11 years ago

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.

Thanks

Signature

The best path to prosperity is free market capitalism!

{{ DiscussionBoard.errors[8536174].message }}

M@tt

11 years ago

It could be a server problem or a script problem. Speak to their support team and hope for a fast/helpful reply

Thanks
1 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 }}

LynnM 11 years ago

You might find these videos useful: Free Technology Tutorials » “Error Establishing a Database Connection” — How to Fix This WordPress Error
- Thanks
{{ DiscussionBoard.errors[8536302].message }}

Kingfish85

11 years ago

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.

Thanks

Signature

|~| VeeroTech Hosting - sales @ veerotech.net
|~| High Performance CloudLinux & LiteSpeed Powered Web Hosting
|~| cPanel & WHM - Softaculous - Website Builder - R1Soft - SpamExperts
|~| Visit us @veerotech Facebook - Twitter - LinkedIn

{{ DiscussionBoard.errors[8536363].message }}

windowstoweb

11 years ago

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.

Thanks
1 reply

{{ DiscussionBoard.errors[8536371].message }}

RobinInTexas

11 years ago

Originally Posted by 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.

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.

Thanks

Signature

Robin

...Even if you're on the right track, you'll get run over if you just set there.

{{ DiscussionBoard.errors[8536442].message }}

waqascheema

11 years ago

if its wordpress the check your plugins .. else check you code

Thanks

{{ DiscussionBoard.errors[8536858].message }}

kpmedia

11 years ago

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

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.

Thanks
1 reply

Signature

FAQ: Need a Site5/Arvixe/Hostgator alternative? And who is EIG?
Reviews: Need a good VPS, dedicated server, or unlimited host? (This is NOT a fake "top 10" list!)

{{ DiscussionBoard.errors[8539848].message }}

fghaegele

11 years ago

Originally Posted by 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.

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.

Thanks

Signature

Take A Break. Play A Puzzle: Merlin's Puzzles

{{ DiscussionBoard.errors[8539895].message }}

fghaegele

11 years ago

TABLE_ROW_READS: 5106914

That's why.

You're trying to squeeze a Boeing 747 into a one car garage.

Thanks
1 reply

Signature

Take A Break. Play A Puzzle: Merlin's Puzzles

{{ DiscussionBoard.errors[8539897].message }}

windowstoweb 11 years ago

Originally Posted by fghaegele

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
- Thanks
{{ DiscussionBoard.errors[8563596].message }}

kpmedia

11 years ago

HG limits resources more than Hawkhost does.

Thanks
1 reply

Signature

FAQ: Need a Site5/Arvixe/Hostgator alternative? And who is EIG?
Reviews: Need a good VPS, dedicated server, or unlimited host? (This is NOT a fake "top 10" list!)

{{ DiscussionBoard.errors[8542695].message }}

RobinInTexas 11 years ago

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.
- Thanks
Signature

Robin

...Even if you're on the right track, you'll get run over if you just set there.
{{ DiscussionBoard.errors[8542935].message }}

protto

11 years ago

Originally Posted by windowstoweb

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.

Thanks
1 reply

{{ DiscussionBoard.errors[8543728].message }}

RobinInTexas

11 years ago

Originally Posted by protto

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

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

Thanks

Signature

Robin

...Even if you're on the right track, you'll get run over if you just set there.

{{ DiscussionBoard.errors[8543956].message }}

Ian25

11 years ago

I had too many problems with hostgator especially with downtime of my sites.

Thanks

{{ DiscussionBoard.errors[8543920].message }}

CareerProf

11 years ago

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?

Thanks

{{ DiscussionBoard.errors[8570923].message }}

Diversion52

11 years ago

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.

Thanks
2 replies

{{ DiscussionBoard.errors[8571089].message }}

Kingfish85

11 years ago

Originally Posted by 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.

How many accounts do you have that need to be migrated? What types of sites are these as well?

Thanks

Signature

|~| VeeroTech Hosting - sales @ veerotech.net
|~| High Performance CloudLinux & LiteSpeed Powered Web Hosting
|~| cPanel & WHM - Softaculous - Website Builder - R1Soft - SpamExperts
|~| Visit us @veerotech Facebook - Twitter - LinkedIn

{{ DiscussionBoard.errors[8571100].message }}

kpmedia 11 years ago

Originally Posted by Diversion52

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!
- [ 1 ] Thanks
Signature
FAQ: Need a Site5/Arvixe/Hostgator alternative? And who is EIG?
Reviews: Need a good VPS, dedicated server, or unlimited host? (This is NOT a fake "top 10" list!)
{{ DiscussionBoard.errors[8574723].message }}

E1one

11 years ago

How can i have that such amazing plan

Thanks

{{ DiscussionBoard.errors[8571109].message }}

Affiliate Ninja

11 years ago

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.

Thanks
2 replies

{{ DiscussionBoard.errors[8603888].message }}

tonyla 11 years ago

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.
- Thanks
{{ DiscussionBoard.errors[8604038].message }}

Kingfish85

11 years ago

Originally Posted by 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.

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.

Thanks

Signature

|~| VeeroTech Hosting - sales @ veerotech.net
|~| High Performance CloudLinux & LiteSpeed Powered Web Hosting
|~| cPanel & WHM - Softaculous - Website Builder - R1Soft - SpamExperts
|~| Visit us @veerotech Facebook - Twitter - LinkedIn

{{ DiscussionBoard.errors[8604063].message }}

topnichewebsites

11 years ago

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