Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

My WordPress site's database is nealy reaching 1GB which is the limitation of my host (GoDaddY), what should I do? I can't purchase a dedicated solution for it?

There must be a way out to split this database into 2 or, another way , can we use 2 database into a single WP installation?

What do you guys do on such case? Thanks.

share|improve this question

migrated from stackoverflow.com Jun 15 '11 at 13:36

This question came from our site for professional and enthusiast programmers.

1  
@9grams: Off topic on SO? –  Predator Jun 15 '11 at 12:35
2  
A WP database with 1 Gigabyte? What on earth are you storing in there? Is it all data for one blog? –  Pekka 웃 Jun 15 '11 at 12:43
    
@9grams: There is a dedicated Q & A site for wordpress, take a look here: wordpress.stackexchange.com –  Predator Jun 15 '11 at 12:46

3 Answers 3

You may find that a lot of that space is being taken up by past revisions of posts. A plugin like Delete Revision is a good way of managing this bloat.

share|improve this answer

9grams,

The first step is to determine why the database is so large. Though not impossible, it's extremely unlikely that it needs to be that large. There's probably some plugin inefficiently or unnecessarily storing data. If you're not sure what's going on, it may help to access phpMyAdmin, a database management tool, to see what table in the database is taking up so much space. This would help you identify if it's a specific plugin. If you don't know how, this help article explains how to access phpMyAdmin from your GoDaddy.com account.

In my experience, it's often traffic statistics data that causes this problem. I have no way of knowing if that's the case for you, but if it is, I would recommend finding another solution for stats tracking and then removing the plugin and stats table that the plugin generated. There are many solutions out there which don't store the information in the database (including a service offered by Go Daddy), so you wouldn't have to sacrifice stats tracking, just find a new way to do it.

Alon GoDaddy.com Social Media Team

share|improve this answer
    
It's great to see a representative from GoDaddy participating in our community. :) –  John Conde Jun 17 '11 at 19:14
    
Thanks Alon, indeed yes, it was Stats tracking plugin devouring around 460megs od MySQL data. –  Ekendra Jun 22 '11 at 12:08

You have several options:

  1. delete revisions
  2. old comments (say's older than N months)
  3. buy bigger plan (or VPS).
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.