If you run any webσελίδα με WordPress, σίγουρα θα γνωρίζετε τι είναι τα revisions. Τα revisions ή αναθεωρήσεις είναι cached δεδομένα που αποθηκεύονται ενώ ετοιμάζετε κάποια δημοσίευση. Έτσι αν έχετε ενεργοποιημένα τα revisions θα πρέπει κάθε μια με two weeks to delete the cached data as it is unnecessary and adds "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) for automatic delete them, they will be timed out.
The article is addressed to those who do not host the by clicking here them on 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 the wp_config.php file to WordPress.
define ('WP_POST_REVISIONS', false);