WordPress.org

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.

Now Multi-Lingual.

Requirements:

• WordPress 2.9++

• PHP 5.1.xx

• MySql 5.1.xx

• 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/

Features:

• 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

Author: ruhanirabin