How To Clean Up And Optimize Your WordPress Database -Part II

Posted by on Feb 3, 2011 in WordPress | 13 comments

How To Delete Revision Posts

Yesterday we learned about how to optimize our WordPress Database by deleting and emptying tables created by various plugins which we are not using currently. If you Missed it here is the Link

Today I will talk about how to delete various versions of your posts called revision posts that are saved in your WordPress database. It will help us reduce extra burden on database space resource.

Each time you edit your posts and “update” it, WordPress save the old version of your post.  If you amend a post many time then it occupy precious space in your WordPress database ultimately slowing down the speed.

Example

Once I wrote a post on this blog about offices of big bloggers, showing some really cool images of offices of big boys of blogging. I also asked my readers to send images of their offices so that I can include it in the post.  Each time I update the post by uploading an image, WordPress also save the previous version of this post as revision. I did this exercise many time and many version of my post revision were saved in my WordPress database.

Have a look at the image below for better understanding;

Post Revisions

In a way it help you to revert changes made in post by publishing previous version of it. WordPress auto save your post revisions but it eat up very useful resource of your WordPress database. No point in keeping all these copies of a post so better after some time you should delete it.

WordPress Delete-Revision Plugin

This plugin do cleaning of revision posts saved in your database superbly. it help you delete a large number of redundant revision posts to increase the speed of implementation of the SQL quarries.

In my case this plugin helped me delete more than  2600 posts revisions from this blog making my database much lighter than it used to be.

post revision

Word of Warning

Dealing with database is always involve risk as some actions are not REVERSIBLE. Please try this if you know exactly what are doing

Tell me in comments below how these tutorials are helping you to improve your WordPress blog performance

I will come up with some more tools and methods to optimize your WordPress database.

Keep Reading :-)

13 Responses to “How To Clean Up And Optimize Your WordPress Database -Part II”

  1. Windows 8 says:
    February 4, 2011 at 12:51 pm

    Another great plugin,thanks for sharing :)

  2. Abhinav Sonkar says:
    February 4, 2011 at 7:42 pm

    Best option: Disable WordPress Revisions completely. Really not required in my opinion.

  3. Ankit @dohack.org says:
    February 4, 2011 at 8:22 pm

    Another great article,thanks for this.I’m hoping for next post.

  4. Jay Philips says:
    February 4, 2011 at 9:10 pm

    Great plugin and a great way to keep our WP DB’s clean.

  5. Rohit Batra says:
    February 6, 2011 at 1:51 pm

    thanks for sharing this Plug-In…it really works great..

  6. Anubhab says:
    February 8, 2011 at 2:58 am

    Bookmarked the post. Never knew about this plugin. Will be really helpful..Thanks a lot

  7. Dedicated Email says:
    February 8, 2011 at 6:37 pm

    I just read part one, nice plugin. This is going to save me a lot of time deleting revision posts without having to write SQL. Thanks Shanker

  8. bilal@domain name registration says:
    February 12, 2011 at 7:34 pm

    nice work shankar …i read your full article but i wnats to know some thing more about… how to delete various versions.. kindly send me some more info regarding that …

Trackbacks/Pingbacks

  1. Tweets that mention How To Clean Up And Optimize Your WordPress Database -Part II -- Topsy.com - [...] This post was mentioned on Twitter by Shanker Bakshi, Ileane Smith. Ileane Smith said: RT @shankerbakshi: New Blog Post ...