Housekeep expired transients from your options table
"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 transients only get deleted when you attempt to access them. 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 reasons, which are explained in the FAQ, this has not been adequately 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 hero that you've been waiting for. 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.
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, and when you'd like the to be automatically scheduled. You can even 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.
Requires: 3.3 or higher
Compatible up to: 4.5.4
Last Updated: 6 months ago
Active Installs: 5,000+
Got something to say? Need help?