Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I installed the Wordpress System Health Plugin and it says that the revisions table in my database is at 70% capacity with 994 rows. I don't fully understand what this means. I anticipate that my site will get much larger than it is today.

Questions

  • Am I going to run into trouble or is there some way I can increase that table's capacity?
  • Is it a hosting issue?

One proactive thing I have done is set a max number of post revisions to 4.

Any solution or an explanation to help me understand what's going on would be really appreciated. Thanks for your help.

share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

SQL query to run via phpmyadmin

DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = 'revision'  

That query will remove all post revisions from your wp database,, But remember always back up your database before running any direct SQL query..

you can also add a line into wp_config.php that will disable revisions (optional, i use it as i find revisions a bit of a pain)

define('WP_POST_REVISIONS', false);

share|improve this answer
add comment

Is it possible it's telling you that 994 rows equal 70% of the total data in your database? I'm not sure what "70% capacity" means, MySQL has a memory limit of several gigabytes for a single database and can handle millions of records.

share|improve this answer
add comment

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.