Whether you're in pursuit to free up some much-needed space or prevent the altogether, disabling or removing old post revisions from your WordPress site is option. you can find the revisions under Publish box, also in the navigation panel.. One way to prevent accumulation of revisions from piling up in your WordPress database is to remove the opportunity for them to in the first place. If you're like most people, you'll want to save couple of post revisions for every post you add to your site just to be on the safe side. Instead of limiting the post revisions to number, you can also increase the auto-save interval to save fewer revisions. you can configure that number of post revisions allowed by going to Settings > Writing.. In order to delete all of your past post revisions from your database, login to the cPanel of WordPress site's hosting account and click on phpMyAdmin icon.. You might want to create backup of your prior to running this query as security measure. deleting post revisions from your WordPress site can be accomplished by running SQL query, you might find it easier to install plugin and let it do all the work. Once you install and activate the plugin, it will add WP-Optimize menu item to your WordPress dashboard.
Read more