WP Clean Up Optimizer will extensively clean up your WordPress database along with Optimizing without manual queries.
Optimizes the WordPress Database after Cleaning it out
delete old, expired transients from WordPress wp_options table
Clear all transients by adding a query string parameter (`?ftr`) to whatever URL you are trying to load. Not for use in production.
Safest and simplest transients garbage collector.
Deletes ALL transients from ALL sites in a Multisite.
Provides details on your WP-eCommerce and WordPress installation state, issues and performance.
Debug Bar Transients adds a new panel to Debug Bar that displays information about WordPress transients.
Do you use custom post types and taxonomies? Do you want to list any related content, not just posts?