One-click database optimization with precise revision cleanup and flexible scheduling. Speeding up sites since...
Clean expired transients from your options table. The original and best!
Transient Cleaner is a WordPress plugin designed to clean expired transients from your options table. It provides a way to manually manage transient data, which can accumulate and bloat your database if not properly handled. The plugin includes options for scheduling automatic clean-ups and performing ad-hoc runs.
This plugin is suitable for users who want to maintain a tidy database and improve performance, especially those running multiple sites who may prefer a simplified interface with the 'lite' mode feature. It complies with WordPress coding standards and is open for community contributions.
Best for: Users looking to manage transient data and improve database performance on WordPress sites.
What it does well
Where it falls short
Transient Cleaner is a straightforward tool for cleaning up expired transients, making it a practical choice for those concerned about database bloat.
David Artiss's own description of Transient Cleaner, lightly tidied.
Clean expired transients from your options table. The original and best!
Transient housekeeping was added to the core of WordPress after version 5.8. However, I have decided to open up this plugin to all versions to allow for manual transient cleaning. Longer term I am working on a new version of the plugin, designed specifically for all WordPress releases.
“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 this it 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.
Within Administration -> Tools -> Transients an options screen exists allowing you to tweak when you’d like cleaning 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”!
A “lite” mode is available. By activating this the options screen will no longer appear and default settings will be used. The advantage? Improved performance to Admin and, especially if you’re running multi-site, no chance of anybody “tinkering” with the settings.
To activate, use the following…
define( 'TC_LITE', true );
This should be added to your wp-config.php file.
Other plugins for database maintenance.
One-click database optimization with precise revision cleanup and flexible scheduling. Speeding up sites since...
Find and delete unused database tables belong to deactivated or deleted plugins directly from WP dashboard.
This plugin implements Servebolt's WordPress best practices, and connects your site to the Servebolt Admi...
Keep your WordPress database fast and clean by removing orphaned data left behind by plugins, themes, and Word...
Enables WP Database Tools. So you can optimize and repair InnoDB and MyISAM tables.
Maximize WordPress efficiency with Time-based Revision Cleanup: manage post histories by age, not count, with...