Posted on October 21, 2009 at 12:01 am as Plugin
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 existing username to another username too. WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces.
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.
Pricing: Free
Requirements: WordPress 2.7+
Source: http://www.ruhanirabin.com/wp-optimize/