WordPress.org

1. smithcreate
   Member
   Posted 4 months ago #

   My website is/was hosted on GoDaddy with no issue until this weekend. My friend who has the site hosted under his account called me and said he received a phone call and email from GoDaddy stating the following:

   The "wordpressDB" MySQL database on your example.com hosting account has been disabled for violating Section 3 "Your Obligations" of Go Daddy's “Web Hosting and Virtual Dedicated Server Service Agreement.”

   Specifically:

   Statpress needs to either be removed or properly indexed/configured.

   Problematic query:
   SELECT count(DISTINCT(ip)) as pageview FROM wp_statpress WHERE date = '20120127' and spider='' and feed=''

   EXPLAIN:
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE wp_statpress ALL 860260 Using where

   This query examines 860,260 rows, which is unacceptable in shared hosting

   I've kept plugin up to date and haven't really done anything in quite a while as far as adding new plugins and such. There doesn't seem to be any contact available for StatPress that I could find to help get to the bottom of the issue.

   In the meantime, I'm moving to a new host and starting from scratch. I'm afraid I may ave lost 8 years or so of blog posts.

2. Go Daddy
   Member
   Posted 4 months ago #

   I wouldn't worry about losing your posts. Though the site may have been disabled, it would not be standard procedure for our staff to actually delete your data. You or your friend (whoever has access to the Go Daddy Hosting Control Panel for the hosting account) should be able to perform a backup of the database so you can get a copy for safe keeping or for migration to another server. Here's a quick walkthrough for making a backup of a database on our shared hosting services: http://x.co/dNu6

   Please note, though, that moving to a new provider is not necessarily the best solution. In fact, you may have similar issues at another provider if you get a similar hosting service without addressing the problem that your site exhibits - that is, overuse of shared hosting resources due to an overly intensive database query. It may be better to simply stop using the StatPress plugin and find another solution for tracking the stats of your site. If that is not an option and you'd prefer not to make changes to your site, you should consider moving to a more powerful hosting environment, like a dedicated server, where the impact of a query won't negatively affect other users.

   I hope this response is helpful to you. If you have any additional questions about how to proceed, the account holder can contact our Support staff for assistance or advice about managing the account in question.

3. camu
   Member
   Posted 2 months ago #

   You may want to take a look at WP SlimStat

   http://wordpress.org/extend/plugins/wp-slimstat/

   Friends of mine use it on GoDaddy without any major problems.

   Cheers,
   Camu

Reply

You must log in to post.