Wordpress 2.6 Revisioning & Auto Save features
Thanks to Lester Chan for highlighting the config settings for turning off revisioning and for modifying the autosave feature. It appears that these two are closely linked. Useful for my personal blog since there is only one editor here. Not as useful for the corporate blog I manage for my employer, since there are multiple editors. Still, they may want to reduce the frequency of auto saves at some point in the future, and it’ll be good to have those notes here to look back on.
One of the irritating feature for me in WordPress 2.6 is the post revision. I am the only author of my blog and hence this feature is useless to me.
Just in case you are wondering how post revision works, whenever a post is auto saved or edited, a new row will be created in wp_posts table. Hence if WordPress auto saved 10 times, you will have 10 new rows in wp_posts table.
In no time your wp_posts table will be filled up and the post ID will be huge.
To turn off this feature, add this following code to wp-config.php:
define(‘WP_POST_REVISIONS’, false);
To change the timing (in seconds) WordPress auto saves a post, add this following code to wp-config.php:
define(‘AUTOSAVE_INTERVAL’, 60);
You can also delete all post revisions by running this query in phpMyAdmin:
DELETE FROM wp_posts WHERE post_type = ‘revision’;
Be sure to backup your database first before performing any queries in phpMyAdmin.
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
[...] has advice for ensuring that you don’t fill up your wordpress revision [...]