Beginner's Guide for WordPress - Start your WordPress Blog in minutes.
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
WordPress Plugins
View all Guides

Optimize Your WordPress Database with One Click

Last updated on by
Special WordPress Hosting offer for WPBeginner Readers
Optimize Your WordPress Database with One Click

Recently on twitter we found a great plugin called WP-Optimize which is a database cleanup and optimization tool. It allows you to remove post revisions, comments in the spam queue, un-approved comments, and much more with just few clicks. This plugin is a great plugin for Beginners because it does not require you to go to PHPmyAdmin.


  • Remove the WordPress post revisions.
  • Remove all the comments in the spam queue.
  • Remove all the un-approved comments.
  • Rename one username to another username, it’s designed to rename default “Admin” user to something else.
  • Apply MySQL optimize commands on your database tables without phpMyAdmin.
  • Display Database table statistics. Shows how much space can be optimzied and how much space has been cleared.

WP Optimize

This plugin is a one for all for beginners. It takes care of one of the most important security major that is changing your admin username without going into the phpMyAdmin. It lets you control your revision with one click rather than the codes.

Having a smaller database size will help you by loading your site fast. It will also help you when you are trying to backup your database, and it is great when you have limited space on your hosting account.

Download WP Optimize

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Page maintained by Syed Balkhi.

WPBeginner's Video Icon
Our HD-Quality tutorial videos for WordPress Beginners will teach you how to use WordPress to create and manage your own website in about an hour. Get started now »


  1. Amiya says:

    I have been visiting for long time but, recently, i’m facing slow loading…

  2. Ashraf says:

    Yeah Its awesome plugin.. I never checked there were a heavy useless stuffs in my blog’s DB. Thanks wpbeginner !

  3. Wes Herndon says:

    I have used this plug in with great success on multiple sites…until this week. I installed this in one of my clients sites this week and ran it. It deleted the entire site…along with two others that I didn’t work on. They all shared the same database and there was a conflict with the WP Optimize and the database.

  4. namaserajesh says:

    Thanks for posting about this plugin, I’ll try this plugin.

  5. Cruz3N says:

    Nice man, i really love this plugin… Wow, you did a good job…

    Best Regard

  6. Rick says:

    Great post. Thank you for sharing this useful resource for beginning WordPress bloggers such as myself.

  7. Tom says:

    thanks for this post! that’s a really nice tool if you blog for longer time and the database is full of old stuff!

  8. joyoge bookmark says:

    nice information, thanks for the post..

  9. Luis says:

    Well, it says in repository that is compatible and tested up to WordPress 2.7.1, did you test it on WordPress 2.8.4?

  10. Ruhani Rabin says:

    Awesome Review! Thank you so much! The target of this plugin is to enable beginner users to be able to optimize their database without going deep into phpmyadmin!

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.