I wrote before when I got my blog “MyLifeThinking.com” down, I didn’t know what happened in the beginning, but after submitting more than 4 tickets to the support team at GoDaddy and losing my blog for 2 days I finally understand!
They say my database is causing the shared resources to be over-utilized. This, in turn, affects the usage by other customers, and there is some query that I have to change in WordPress StatPress plugin, it was the cause of the problem, I think because I didn’t set StatPress to delete older data from the database, so the file got so big, so they had to disable my database!
But.. How Godaddy disabled my database with out inform me first?
I was thinking about that, and say to my self this is not good at all, if I am going to expect that GoDaddy will turn my blog off each time a plugin cause a problem, this will be a nightmare.
Anyways.. after debating lots about how to fix my problem, I got sick of waiting for their reply day after day and wasting my time, so decided to create another database from my panel, and restore MyLifeThinking.com database backup to it. I consider my self so lucky because I got this backup file just one week before they cut the database!
How I did it?
You may ask yourself how I could build the tables and the structure of the new created database, well.. let me explain to you how I did it, at the beginning I was not sure how to do it, so I remember that I can use the applications on GoDaddy to create a new installation for WordPress, so I did it and created a new blog on a sub folder, then I changed the database information on the config.php file, and then the last step was importing the data to the new database.
In this process I lost one post and a few comments, I know that I can wait more time to get my blog online again, so I preferred to get it now!
Why I will live under GoDaddy merci?
Some times I can not see any reason for using Godaddy hosting service, I think that most successful blogers use other website hosting for their blogs instead of GoDaddy!
I am thinking to move to another web hosting, or at least try anew one, so plz give me some good suggestions! I will appreciate if you do!
{ 20 comments… read them below or add one }
Instead of just using the wordpress plug in just make a complete move over to wordpress. It’s what I use for my blog and it’s a good platform. I’m not so found of blogger, I orginally tried them out and feel it’s limited and a pain in the ass.
Bec Thomas’s last blog post..End of an era for News Print Photographers
@Bec Thomas, This is great news, me my self love WP and will never change to another platform! Thanks for your comment.. Where do you host your blog?
I don’t think there is anything wrong with GoDaddy hosting. They should have warned you or gave you a phone call before disabling your database though.
Kai Lo’s last blog post..Closed Comments or No Responses
@Kai Lo, Well, this is the first time I have this kind of problem, but GoDaddy talks to you only to let you know about their new offers :-p
Most people out there would only talk to you about their new offers/website anyway. They won’t help you unless they get rewarded somehow.
Kai Lo’s last blog post..Closed Comments or No Responses
@Kai Lo, You are right Kay!
go to hostgator hsred hosting, or mediatemple, they are the best one for shared platforms, but your should know that every host in the planet never notifies you before suspending your account..all are the same
creative’s last blog post..java.sql.SQLException: Exhausted Resultset error in java
@creative, Thank you for the links, I will check that!
Well.. I have to put this in mind then!
I agree with creative, I use HostGator too but any of them will do exactly what GoDaddy did. I like HostGator because I can call rather than play the ticket submission game. I had to upgrade to a dedicated server because of my ad tracking site and they did email my to let me know but then shut my sites down at the same time. They said I was using over 25% of the server. I won’t be so greedy as to paste an affiliate link here. You can check them out directly but to be honest you are probably better off staying where you are unless you have other issues with GoDaddy. Especially if you have a lot of sites because changing servers can be a pain.
Brian D. Hawkins’s last blog post..Why Not Just Ask For Subscribers?
@Brian D. Hawkins, But what is their problem if you use 25% of your “dedicated ” server resources?
I know this will be a big pain, but what I want to do it to have another hosting with another company, and use them both for some time until decide to move or not, The problem is not with my blogs, it’s more about my clients and to enhance my work.
wow…good blog…and nice theme..
elfams’s last blog post..SEO Service to market your site
@elfams, Glad you like it, you can get a very nice and powerful themes by being a member of EleganTheme , Thanks for the visit!
I’ve been using the WP Statpress plugin for years and it’s always worked well for me. I do have issues with some of the other plugins like Wordbook, and the Onlywire Autoposter, but never have I had a problem with the Statpress plugin. I’ve used Godaddy hosting on some sites and it’s never been that easy in setting up a Wordpress on there, so I mostly recommend to not use Godaddy but rather another hosting company that has as stable platform for Wordpress. I usually recommend either Hostgator, 1and1, or SEOhosting. All of these give you the resources you need to get a Wordpress up easy and all the plugins work great. Thanks for sharing this and I’m going to dig in a little deeper to see what issues I can find with the Statpress plugin on Godaddy.
Fred Cash’s last blog post..Why Use Payday Loans
@Fred Cash, I think the problem was because I didn’t set up my plugin to delete files after 1 month, so the database queries was eating the bandwidth!
This is great info. So good in fact that i’ll have to do a write up about it
I have no problem buying my domains from godaddy but hosting….never!
.-= Gabriella Mckee´s last undefined ..If you register your site for free at =-.
@Gabriella Mckee, thank you for the tip Gabriella!
.-= Hesham´s last blog ..5 Step-By-Step Video Tutorial Modules for Top Making Money Methods “WordPress Wizard 2.0” from MaxBlogPress =-.
I use Hostgator for all my websites now, I found GoDaddy to be a waste of space. With Hostgator I can speak to a real person (the instant chat option is excellent), the GoDaddy ticket system was very basic and is not as good as speaking to a real person.
I am Going Threw The Same Problem Right NOW. I dont have a DB back up, the WP site has only been live for 3 months, And they are Really PISSING ME OFF, I cant even log into WP to deactivate Plugin’s, WHAT A Dumb way to help people out !!!!! no warning, just shut down, and Emails that take 24 hour’s + to get a reply, even on the Phone Rep’s can not help, But at least they can Under stand Why I’m between a Rock and hard spot witch don’t say Much just that they know what 2 + 2 is.
If this Don’t get Fixed Soon, I will take However much Time Needed to change to HostGator.
Try nearlyfreespeech.net if you’re technically qualified to handle installations and upgrades yourself. No hassles, great philosophy, no overselling, just plain pay for what you use! You may probably get away with spending just a few dollars every year (yes, every year, not month) – that excludes domain costs though.
While I may not necessarily agree with the whole “shut them down immediately” process, I can understand it. As a MySQL Database Administrator, I can say that most shared hosting providers cram WAY to many users onto one server. The more users they can put on one server, the less hardware they have to buy, and the more money they’re going to make.
The problem with shared hosting is that hosting companies have to set very certain limits in order to prevent runaway queries from taking over the server. If a user has a query that examines an exorbitant number of rows from their database (I’ve seen 1.32E47 rows examined before from an EXPLAIN command), the query will take forever and never end, in theory. All the while, that query is likely trying to sort the records in a temporary table. Temp tables are stored in memory. Huge queries like that take up all the free memory and then all the swap space (physical storage space used as memory) on the server and there is literally NO memory left on the server. I have seen a single user use up all 48 GB of memory on a server before because of one bad query.
At that point, what is a hosting company to do? Yes they can kill the query, but how can you prevent that query from coming back? They have to protect their best interests. So does that mean shutting down and upsetting 1 user, or does it mean letting it go and letting the other 1,000, 2,000, or more customers on that same server suffer because of the 1 negligent user? It’s pretty obvious what they need to do. In order to prevent pissing off 2,000+ customers, they piss off the one and shut them down. They realistically can not keep that database running while they notify the problem user as they have to get the server back to a working state immediately for the sake of the thousands of other customers on the same hardware.
It’s unfortunate that you were the one customer in this instance, but if they let it go, they’d have thousands of angry customers sending tickets and calling and complaining about poor server performance. They’d rather risk have 1 customer jump ship as opposed to potentially thousands. It’s pretty much a lose-lose situation for everyone involved, and it sucks, but every hosting provider will do the exact same thing, as the other posters mentioned.
The best solution, as others mentioned, is remove yourself from that situation and go with a virtual dedicated or dedicated server. Although I’ve seen single users crash VPS’s before since obviously there are certain shared resources there still.
I hope this can shed a little light on why hosting providers do some of the things they do that may piss us off and I hope everything works out for the best for you.
P.S. I will say that from a design standpoint, StatPress is a crappy plugin. It provides very useful information, but it causes nothing but problems for site owners. Do a quick google search on it and you’ll see a plethora of people complaining about poor site performance due to StatPress.