WP CleanFix

WP CleanFix is a plugin born to improve the core features within your WordPress installation and keep clean your databases with ease
This plugin is the perfect fit for anybody who needs to get rid of the annoyances database management which regularly rises and for those who need to literally clean their WordPress up from missing categories, users, meta, etc.

CleanFix embodies several functions, which normally are provided as single plugins, and make them all quickly and easily available through a clean dashboard for the website management (for specific information see the features tab).
A clean and simple UI lets you enable/disable every single feature quickly and smoothly with just a click. Since CleanFix takes advantage of Ajax, you’ll be able to perform simultaneously multiple actions without refreshing your page.
CleanFix, you’ve never been happier to clean stuff.

Features

• Optimise database tables, MyISAM and InnoDB
• Reset auto-increment preferences
• Check/Remove expired transient
• Transient preferences
• Check/Remove Post Revision, post in trash, auto-draft
• Check/Remove Post Meta, Orphan Media attachments, Orphans Post Tags and Orphans Post Categories
• Check/Repair Post without valid user linked
• Check/Remove Orphans Post Types
• Check/Repair Terms, Terms Taxonomies and Terms Relationships
• Check/Remove Orphans generic Terms
• Check/Remove expired user transient
• Check/Remove user meta
• Check/Remove Unapproved, SPAM and Trash Comments
• Tools/Database compact index
• Tools/Posts Find & Replace
• Tools/Comments Find & Replace
• Tools/Post Meta Find & Replace