David Artiss

<p>Clean expired transients from your options table. The original and best!</p>
<p><strong>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.</strong></p>
<ul>
<li>Tested up to PHP 8.2</li>
<li>Fully complies with WordPress coding standards</li>
<li>Compliant with the stronger <a href="https://wpvip.com/" rel="nofollow ugc">WordPress VIP</a> coding standards, as well as compatibility with their platform</li>
<li>Community plugin – visit the [Github page](https://github.com/dartiss/[repo link] “Github”) to get involved with the latest code development, request enhancements and report issues</li>
</ul>
<p>“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.”</p>
<p>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 href="https://core.trac.wordpress.org/ticket/20316" title="Ticket #20316" rel="nofollow ugc">a known “issue”</a> but due to reasons, which are explained in the FAQ, this has not been adequately resolved.</p>
<p>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.</p>
<p>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.</p>
<h3>The Settings Screen</h3>
<p>Within <code>Administration</code> -> <code>Tools</code> -> <code>Transients</code> 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.</p>
<p>You can even request an optimization of the options table to give your system a real “pep”!</p>
<h3>Running in Lite mode</h3>
<p>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.</p>
<p>To activate, use the following…</p>
<pre><code>define( 'TC_LITE', true );
</code></pre>
<p>This should be added to your <code>wp-config.php</code> file.</p>
<h3>Using hooks</h3>
<p>If you’re the type of odd person who likes to code for WordPress (really?) then I’ve added a couple of hooks so you can call our rather neat cleaning functions…</p>
<ul>
<li><code>housekeep_transients</code> – this will clear down any expired transients</li>
<li><code>clear_all_transients</code> – this will remove any and all transients, expired or otherwise</li>
</ul>
<h3>Acknowledgements</h3>
<p>I’d like to thank WordPress Developer Andrew Nacin for his early discussion on this. Also, I’d like to acknowledge <a href="http://www.staze.org/wordpress-_transient-buildup/" title="WordPress _transient buildup" rel="nofollow ugc">the useful article at Everybody Staze</a> for ensuring the proposed solution made sense, and <a href="http://w-shadow.com/blog/2012/04/17/delete-stale-transients/" title="Cleaning Up Stale Transients" rel="nofollow ugc">W-Shadow.com</a> for the cleaning code.</p>
<p>Iconography is courtesy of the very talented <a href="https://www.fiverr.com/jankirathore" rel="nofollow ugc">Janki Rathod</a>.</p>


Transient Cleaner

This plugin is great. A site I manage got hacked and the database export was 304mb. After clearing the transients the database export went from 304mb to 13mb.



Fantastic plugin!

This helped fix a widget that had cached old data in a transient

Clean Now - awesome

Clean expired transients from your options table. The original and best!

webaware

<p>Delete old, expired transients from the WordPress options table (<code>wp_options</code>), to prevent them from bloating your database and even slowing down your website.</p>
<p>Unless you are using an object cache (like memcached), WordPress stores transient records in the options table. Many transients are given an expiration time, so in theory they should disappear after some time. In practise, because old transients are only deleted when requested again after they’ve expired, many transients stay in the database. After a while, there can be thousands or even millions of expired transients needlessly taking up space in your options table, depending on what your plugins are doing.</p>
<p>Delete Expired Transients schedules a daily task to delete any expired transients from the options table. It performs this operation with a single SQL query, and then runs a second query to find any orphaned expiration records and deletes them too.</p>
<p>There are a few other plugins around that clean up expired transients. This one is written for fast performance, set-and-forget scheduled housekeeping, and maximum compatibility. It uses the PHP time to determine whether transients are expired, not the database time (which can be different). It does only one job, and it does it well with the minimum of resources.</p>
<p>Now optimised for WordPress Multisite.</p>
<h3>Translations</h3>
<p>Many thanks to the generous efforts of our translators:</p>
<ul>
<li>English (en_CA) — <a href="https://translate.wordpress.org/locale/en-ca/default/wp-plugins/delete-expired-transients" rel="nofollow ugc">the English (Canadian) translation team</a></li>
<li>English (en_GB) — <a href="https://translate.wordpress.org/locale/en-gb/default/wp-plugins/delete-expired-transients" rel="nofollow ugc">the English (British) translation team</a></li>
<li>English (en_ZA) — <a href="https://translate.wordpress.org/locale/en-za/default/wp-plugins/delete-expired-transients" rel="nofollow ugc">the English (South African) translation team</a></li>
<li>French (fr_FR) — <a href="https://translate.wordpress.org/locale/fr/default/wp-plugins/delete-expired-transients" rel="nofollow ugc">the French translation team</a></li>
<li>Hungarian (hu_HU) — <a href="https://translate.wordpress.org/locale/hu/default/wp-plugins/delete-expired-transients" rel="nofollow ugc">the Hungarian translation team</a></li>
<li>Norwegian: Bokmål (nb_NO) — <a href="https://www.neonnero.com/" rel="nofollow ugc">neonnero</a></li>
<li>Norwegian: Nynorsk (nn_NO) — <a href="https://www.neonnero.com/" rel="nofollow ugc">neonnero</a></li>
<li>Russian (ru_RU) — <a href="https://translate.wordpress.org/locale/ru/default/wp-plugins/delete-expired-transients" rel="nofollow ugc">the Russian translation team</a></li>
<li>Spanish (es_ES) — <a href="https://translate.wordpress.org/locale/es/default/wp-plugins/delete-expired-transients" rel="nofollow ugc">the Spanish translation team</a></li>
</ul>
<p>If you’d like to help out by translating this plugin, please <a href="https://translate.wordpress.org/projects/wp-plugins/delete-expired-transients" rel="nofollow ugc">sign up for an account and dig in</a>.</p>
<h3>Contributions</h3>
<ul>
<li><a href="https://translate.wordpress.org/projects/wp-plugins/delete-expired-transients" rel="nofollow ugc">Translate into your preferred language</a></li>
<li><a href="https://github.com/webaware/delete-expired-transients" rel="nofollow ugc">Fork me on GitHub</a></li>
</ul>
<h3>Privacy</h3>
<p>Delete Expired Transients does not collect any personally identifying information, and does not set any cookies. It removes some old information from the database, potentially reducing a website’s exposure to leakage of personally identifying information.</p>


Delete Expired Transients

Now and then, I run across a plugin that is simple, well-designed and fills a need painlessly and efficiently. Delete Expired Transients is just such a plugin.
I have a client whose site uses the Diverse Solutions dsIDXPress plugin, which was bloating the options table in the database with thousands of records containing expired transients. Delete Expired Transients cleaned out the options table and keeps it cleaned out. 
Thanks for a great plugin!



Thanks for a Great Plugin!

Given the preponderance of MySQL-backed transient storage installations, this or something like it really should be part of Codex.



A useful and much needed-plugin

Still works great, perfect on Multisite...

Still works great


easy to use. 簡単に利用できる。


useful plugin

Delete old, expired transients from WordPress wp_options table

Transient Cleaner vs Delete Expired Transients