Joost de Valk

Ari Stathopoulos

Progress Planner

Filip Ilić

<p>This plugin tracks which of the autoloaded options are used on a page, and stores that data at the end of page render. It keeps an array of options that it has seen as being used. On the admin page, it compares all the autoloaded options to the array of stored options, and shows the autoloaded options that have not been used as you were browsing the site. If you’ve been to every page on your site, or you’ve kept the plugin around for a week or so, this means that those options probably don’t need to be autoloaded.</p>
<h3>How to use this plugin</h3>
<p>Install this plugin, and go through your entire site. Best is to use it normally for a couple of days, or to visit every page on your site and in your admin manually. Then go to the plugin’s settings screen, and go through the unused options. You can either decide to remove an unused option (they might for instance be for plugins you no longer use), or to set it to not autoload. The latter action is much less destructive: it’ll still be there, but it just won’t be autoloaded.</p>


AAA Option Optimizer

And I love the speed in which improvements are made :)

Great tool to minimize autoloaded data size


I wonder how on earth a plugin tha promises to optimize the wp_options tables, stores 25MB of data in the option_value !!!! Maybe the guy who developed it does not understand the fundamentals of the internal database optimizers but such a huge deviation, totally ruins MariaDBs/MySQL internal optimizer. You see optimizers work on the assumption that in a table, the fields have somewhat related sizes. For more details please go to MariaDB Jira and check for cases MDEV-34097 and MDEV 32663If you add records with huge sizes (say > 100k) in wp_options table where each option is usually less than 30Bytes, then you have an issue. In our case the issue was caused by the very plugin that we used to monitor our options (that are by and large incorrect). Avoid it at all costs.


A joke!!!

Plugin that tracks autoloaded options usage and allows the user to optimize them.

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!

AAA Option Optimizer vs Transient Cleaner