It allows you to remove post revisions, comments in the spam queue, un-approved comments, items in trash within few clicks.
Simple scheduler introduced (Still in very EXPERIMENTAL stage)
All the potentially dangerous clean up options are MARKED RED.
When you use this plugin for the first time or just updated to major version, make a backup of your database. This is a must for everyone
Are you interested to be a contributed developer of this plugin, use the contact form link below to contact me.
You will be credited inside the plugin screen and the plugin listing at WordPress.
Requirements:
WordPress 3++
PHP 5.1.xx
MySql 5.1.xx
PHP 4.xx and MySql 4.xx not supported
How this could help you?
Every-time 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 that's 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 spam 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
Automatically cleans database every week and respects the "Keep X number of weeks data" option.