After a few day’s playing around with wordpress, I felt one thing is quite annoying. It does not matter how little change you made to your post, wp always save them by means of revision. The result is a waste of resources and unnecessary longer database query time. I really see no reason to save that many revisions. There are a couple of ways to get rid of this “feature”.
- SQL command:
DELETE FROM wp_posts WHERE post_type = “revisionâ€;
select wp_posts table and run the command, make sure “ (double or single quote) is in proper format. - Modify wp-config.php :
define(‘WP_POST_REVISIONS’, false);
the file locates at the website root directory, add the code before /* That’s all, stop editing! Happy blogging. */, it turn out there is still one more thing needs to be done. - Plugin
Can not believe there is even a plug in for this, anyway this is the link. Delete-Revision
The official document is here: Revision Management. It turn out that there is only one autosave in database and the record will be updated every 60 second. The autosave has nothing to do with post revision control. The purpose is to give you something in case you have system crash while editing a post, I can live with that. I would like to suggest WordPress to move this from core to something like plug in.