This simple but effective plugin allows you to clean up your WordPress database and optimize it without phpMyAdmin.
WP-Optimize is a WordPress 2.9++ 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.
PHP 4.xx and MySql 4.xx not supported
Translators are welcome to send their Translated Files to be included.
Contact me at http://wwww.ruhanirabin.com/contact/
Remove the WordPress post revisions
Remove the WordPress auto draft posts [NEW]
Remove all the comments in the spam queue
Remove all the un-approved comments
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.
Visible only to the administrators.
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 is 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