WP-Optimize Database Cleanup and Optimization Plugin for Wordpress

I use wordpress solutions in a day to day basis. Wordpress comes with a very extensible framework that allows you to add comprehensive and powerful functionality to your Blog system. WP-Optimize plugin is written to simplify your daily wordpress works and make it simpler. WP-Optimize is a wordpress 2.7++ database cleanup and optimization tool. It doesn’t require PhpMyAdmin to optimize your database tables. It allows you to remove post revisions, comments in the spam queue, un-approved comments within few clicks. Additionally you can rename any username to another username too. Here are the details.
Hosted at Wordpress Official Plugin Directory

How this could help you?

• Everytime you save a new post or pages, wordpress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. Imagine if your post or pages are long and big. It’s a huge number of bytes thats on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing not necessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.
• Similar to the scenario described above, there might be thousands of spams and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click
• WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces
• Wordpress doesn’t allow you to rename existing username which could be a security issue because your default wordpress admin username is “admin”, if you read my Wordpress Security guide article, you will know the risks involved. WP-Optimize can rename any existing username to other name

Features:

• Remove the existing 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.

Requirements:

• It Requires wordpress version 2.7 and higher. Tested with 2.7

Installation:

• Unzip the archive into your hard drive.
• Upload the folder to your wp-content/plugins folder on your web host.
• Login to your dashboard and activate the plugin via activate option.
• The menu item is under Dashboard>WP-Optimize.

Usage:

• Select the WP-Optimize menu item under Dashboard dropdown menu
• Select the actions you want to perform
• Click on Process button

Screen Shots:

This is a primary version of the plugin so any feedback here would be highly appreciated.

Did this plugin helped you out?
Would you like to donate an amount for this Plugin?

• Integrate social networking in wordpress using facebook connect api and WordPress plugin tutorial
• Wordpress 2.5 – The Upgrade Resources
• How to Change Wordpress Permalinks without affecting Google
• 14 Effective Practical Security Tips for WordPress
• Easier way to add facebook connect to your blog using WP-FacebookConnect plugin
• How to – Add Facebook LIKE button to WordPress Posts
• How to style the latest post in WordPress
• Lazy Blogger’s guide to Super Charge WordPress with 100+ Plugins

About Ruhani Rabin

Ruhani Rabin is the original owner and author of this blog. He also reviews web 2.0 startups at Tech2all.com. Largely interested in web 2.0 apps & Social Media. Currently the Vice President of MOL Access Portal (MOL is owner of Friendster.com). Also he is Web 2.0 & Social Media Researcher and a Total fun Geek!.. There you have it ;)

Twitter Profile: http://twitter.com/ruhanirabin