The revisions table in my database is at 70% capacity and growing. What should I do?

by

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.

2 Answers
2

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);

Leave a Comment