Turn off or Disable & Delete WordPress Post Revisions
The wordpress latest version is excellent for sure because of the added features and beautiful backend, but sometimes all the features are not as good , and one of them is the wordpress post revision. his feature was added for all the wordpress 2.6+ versions where a copy of your post is saved up in your wordpress database with the post version.
If you see the below screenshot, while writing a post and editing it, there were numerous copied saved i nthe database, increasing the size of the database and slowing it down. You will need to disable this post revision in your blog along with deleting the older saved data.
WordPress Post Revisions
Turning off Post Revision in WordPress :
Login to your ftp and find your wp-config file and add the following code in the file, somewhere in the middle or after the database details in wp-config.php file.
define(‘WP_POST_REVISIONS’, false);
Deleting your old Post Revision data from your database :
Its not really required but if you feel that you need tosave up some of your database space and remove the useless data , then you can try to delete all of these by logging into your cpanel>phpmyadmin > and selecting your database, following by running the query given below.
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
Whenever you perform any of these sql related queries, always make sure you take a backup of your database because if some problem comes up you can restore the database and stay safe. via Lester Chan
