"Transients are a simple and standardized way of storing cached data in the WordPress database temporarily by giving it a custom name and a timeframe after which it will expire and be deleted."
Unfortunately, expired entries will only be deleted if you attempt to access the transient again. If you don't access the transient then, even though it's expired, WordPress will not remove it. This is a known "issue" but due to reason, which are explained in the FAQ, have not been resolved.
Why is this a problem? Transients are often used by plugins to "cache" data (my own plugins included). Because of the housekeeping problems this means that expired data can be left and build up, resulting in a bloated database table.
Meantime, this plugin is the solution, using the same proposed method as the WordPress core change will use. Simply activate the plugin, sit back and enjoy a much cleaner, smaller options table. It also adds the additional recommendation that after a database upgrade all transients will be cleared down.
Within Administration -> Tools -> Transients an options screen exists allowing you to tweak which of the various housekeeping you'd like to happen, including the ability to perform an ad-hoc run. You can also request an optimization of the options table to give your system a real "pep"!
We'd like to thank WordPress Developer Andrew Nacin for his early discussion on this. Also, we'd like to acknowledge the useful article at Everybody Staze for ensuring the proposed solution wasn't totally mad, and W-Shadow.com for the cleaning code.
Delete Expired Transients
Delete old, expired transients from the WordPress options table (wp_options), to prevent them from bloating your database and even slowing down your website.
Unless you are using an object cache (like memcached), WordPress stores transient records in the options table. Many transients are given an .........
Drastic Table Manager
DrasticTools is a collection
of PHP and JS scripts that generate AJAX-based data managers and viewers for MySQL
tables. DrasticGrid is a data grid that supports pagination, sorting, insertions,
deletion and update of records.
The Drastic Table Manager plugin allows WP administrators to manage the .........
Edit Any Table
This plugin can be integrated as a dashboard widget or use its own admin page to allow you to connect to any MySQL database of your choice (as long as your hosting allows) and search, edit, add and delete records in an easy to use interface. Ideal if you have built a site referencing another databa.........
Custom DataBase Tables
WordPress database is easy to use with simple, but if you want to handle the data that does not conform to the provided initial table structure, or considering the use of as the CMS, is more better to create a new table.
This plugin provides the ability to be able to add a new table freely in the d.........
Easy WP Cleaner
Easy WP Cleaner is user friendly plugin to clean unnecessary data from WordPress database like "revision", "draft", "auto draft", "moderated comments", "spam comments", "trash comments", "orphan postmeta", "orphan commentmeta", "orphan relationships", "dashboard transient feed" and this plugin also .........
WP CleanFix
WPX CleanFix Light is the "light" version of wpXtreme CleanFix.
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 whic.........
WP-Sweep
This plugin cleans up:
Revisions
Auto drafts
Deleted comments
Unapproved comments
Spammed comments
Deleted comments
Orphaned post meta
Orphaned comment meta
Orphaned user meta
Orphan term relationships
Unused terms
Duplicated post meta
Duplicated comment meta
Duplicated user meta
Transient options.........
User Meta Manager
User Meta Manager is a handy plugin, with a simple interface, for managing user meta data....
WP Edit
Introduction
For a riveting video introduction into the possibilities available with WP Edit; please visit Jupiter Jim's Marketing Team....
Ultimate TinyMCE
Note: The end of Ultimate TinymceThis plugin will not work properly on WordPress versions 3.9 and above...
