WP-CleanDB

This WordPress plugin will cleanup your WordPress database, performing the following actions:

• Remove all post revisions.
• Remove all spam comments.
• Remove all unapproved comments.
• Remove all unused tags.
• Remove all unused post meta.
• Optimize MySQL tables by removing all unused table space.

Based on WP-Cleanup by JortK, this plugin replaces usage of mysql_query() that was deprecated in PHP 5.5 with WP_Query functions .