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 at some point you forget to delete them, so many will accumulate that the plugins that exist (Better Delete Revision) for automatic deletion 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 SQL execution box orders και κάντε αντιγραφή (ctrl+C) – επικόλληση (ctrl+V) την παρακάτω εντολή:
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);