Does the job!

  • copytrans

    (@copytrans)


    1 year, 2 months ago

    I have used this plugin on 5 different multi-site wordpress and have achieved awesome results. Here’s the best one:

    • 13779 revisions deleted
    • database size reduced from 297MB to 65MB = 22% of original size!!
    • this lead to an 11% speed gain (server side execution time to generate the page)
    • we had such good results, because we had no limit on the number of revisions per post a few years back. wordpress does not automatically clean the revisions. The revisions for a post, only get cleaned up when you actually work on a post. In our case we had revisions from 2015 that were still encumbering the database.

    Those are the settings I used:
    Delete revisions of: POST, PAGE, USER_REQUEST, WP_BLOCK, WP_TEMPLATE, WP_TEMPLATE_PART, WP_GLOBAL_STYLES, WP_NAVIGATION, WP_FONT_FAMILY, WP_FONT_FACE
    Delete revisions older than: 720 days
    Maximum number of - most recent - revisions to keep per post / page: 25
    Delete trashed items: YES
    Delete spammed items: YES
    Delete unused tags: YES
    Delete transients: NO
    Delete pingbacks and trackbacks: YES
    Clear oEmbed cache: NO
    Keep a log: YES
    Optimize InnoDB tables: YES
    Number of excluded tables: 0

    I’ve reviewed the plugin’s source code and tested it extensively and found out a few issues in the source code that I have shared with the maintainers. Overall, I think this plugin is safe to use, provided you backup your database before and that you fully understand what you’re doing.

The topic ‘Does the job!’ is closed to new replies.