Massive bloat of revision history (5 posts)

  1. stunley
    Posted 3 years ago #

    After downloading a backup of my database in phpadmin (gzipped) I finally noticed that the database was getting massive - 148mb on a site with less than 1,500 posts.
    Poking through the database I noticed it was filled with the post's revision histories; a few select posts had over 3,000! Finally I had a grand total of over 77,000 just filling the database.

    Once cleaned out it had shrunk to under 8mb (uncompressed). Now, it seems to me that this is not a sane way to handle revisions and very little mention about cleaning or possible bloat of the database. Or am I the crazy one?

  2. Now, it seems to me that this is not a sane way to handle revisions

    But there is :D http://codex.wordpress.org/Editing_wp-config.php#Post_Revisions

    As for cleaning them out, that's less easy.

  3. esmi
    Forum Moderator
    Posted 3 years ago #

    There are also plugins for revision control - eg: http://wordpress.org/extend/plugins/revision-control/

  4. Revision control is a great plugin, I use it a lot.

    That said, I'd wonder why a post had more than 3k revisions saved to it. Do you update posts a lot, like on a continual basis? Perhaps your process could change to accommodate your goals better.

  5. stunley
    Posted 3 years ago #

    Thanks for the feedback everyone.
    I edited the wp-config.php file to reduce the max number of revisions to 3. I don't think I've ever needed to use revisions (touch wood) so don't think I'll miss it.

Topic Closed

This topic has been closed to new replies.

About this Topic