If you run a website with WordPress, you will surely know what the revisions are. Revisions or revisions are cached data that is stored while you are preparing a post. So if you have the revisions enabled, you should delete the stored data every two weeks, as they are not necessary and add "weight" to your database.
The problem is that if you forget to delete them, you'll get so many plugins that exist (Better Delete Revision) to automatically delete them, they will be timed out.
The article is addressed to those who do not host their website at wordpress.com, and have access to SQL.
If you search Google for a solution, there is a simple SQL statement, but you should not use it in your WordPress installation. The command will delete the revisions, but will leave all metadata in your database.
Do not use this command:
DELETE FROM wp_posts WHERE post_type = "revision";
Before you start, get a backup of your database.
Then go to the frame implementationof SQL commands and copy (ctrl+C) – paste (ctrl+V) the following command:
DELETE a, b, c FROM wp_posts and 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'
Run the command from GO.
If you want to disable all revisions, you can add the following code at the bottom of it archivey wp_config.php in / of WordPress.
define ('WP_POST_REVISIONS', false);