Clean And Optimize WordPress .
Kt-cleanpress is a plugin designed to clean and optimize WordPress. It will give you the following options:
Clean Posts: which will let you remove all posts marked as Trash / Pending / Draft with all their related contents from the database, and then it will defragment it.
Clean Pages: will do the same things described in Clean Posts, but it will process the pages.
Clean Comments: will do the same things described in Clean Posts, but it will process the Spam / Unapproved / Trash Comments.
Clean Post Revisions: Whenever a post is edited and saved WordPress automatically creates a backup to which one can revert. This option will remove all posts backups.
Clean Auto Draft: This is a left over from the process of creating a new WordPress page or post and not saving it as a draft of publishing it.
Clean Other Left Overs: Will remove navigation menus that are created but not saved, and all their related data, and will also remove unneeded lock and last entries in the database.
Clean Empty Categories / Tags: Will delete all categories/Tags that do not have any post or link associated with them but will not remove the default WordPress categories.
Optimize The Tables: Reclaim unused space and defragment the data file.