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.

Kazuto Takeshita

<p>The <code>wp_options</code> table accumulates leftovers from plugins and themes that have been deactivated or deleted but never cleaned up. Those rows bloat the autoload payload on every page load and there is no built-in way to decide which ones are safe to remove.</p>
<p>Orpharion observes which options are actually read at runtime, attributes each read to the plugin or theme that caused it, and surfaces the raw signals (accessor, autoload flag, size, last-read timestamp) so administrators can decide what to remove:</p>
<ol>
<li><strong>Observe</strong> — the tracker records when and by whom each option is read, using the live PHP backtrace to identify the real caller.</li>
<li><strong>Quarantine</strong> — rename the option temporarily so WordPress and the accessing plugin can no longer see it; confirm nothing breaks.</li>
<li><strong>Delete</strong> — the row is removed from both <code>wp_options</code> and the tracking table. Use the <strong>Export selected</strong> bulk action first if you want a restore copy; Orpharion never writes option_value content to the server filesystem on your behalf (option_value can contain API keys, SMTP credentials, and other secrets that should not leak into backups of <code>wp-content/</code>).</li>
</ol>
<p>Core WordPress options are locked out of destructive operations, on both the deletion and the import side.</p>
<p>The full PHP source ships uncompiled with the plugin; the non-compiled source of the compiled admin bundle (<code>build/index.js</code>, <code>build/index.css</code>) is published at https://github.com/mt8/orpharion — see the <strong>Source code</strong> section below for the exact build steps.</p>
<h3>Source code</h3>
<p>The published plugin ships with the compiled admin bundle in <code>build/</code> (<code>build/index.js</code>, <code>build/index.css</code>, <code>build/index.asset.php</code>). The non-compiled source for that bundle lives in <code>src/</code> in the public GitHub repository:</p>
<ul>
<li>Repository: https://github.com/mt8/orpharion</li>
<li>Build tool: <a href="https://www.npmjs.com/package/@wordpress/scripts" rel="nofollow ugc">@wordpress/scripts</a> (uses webpack + Babel under the hood).</li>
<li>
<p>Reproduce the bundle:</p>
<ol>
<li>Clone the repository.</li>
<li>Install dependencies: <code>npm install</code> (Node.js version compatible with <code>@wordpress/scripts</code> is required).</li>
<li>Build: <code>npm run build</code> — produces the same <code>build/</code> files that are shipped with the plugin.</li>
<li>Watch mode for development: <code>npm run start</code>.</li>
</ol>
</li>
</ul>
<p>PHP code is shipped uncompiled and is the same in the published ZIP and in the repository.</p>
<h3>Features</h3>
<ul>
<li>Per-option read tracking via dynamically registered <code>option_{$name}</code> filters, so every <code>get_option()</code> call is attributed to the real plugin or theme on the call stack.</li>
<li>Accessor inference (live tracker data <span aria-hidden="true" class="wp-exclude-emoji">→</span> slug prefix <span aria-hidden="true" class="wp-exclude-emoji">→</span> curated core list) with an active / inactive flag so you can filter down to options whose owner is no longer present.</li>
<li>Sortable options table with individual columns for accessor, autoload, size, and last-read timestamp — no opaque composite score.</li>
<li>Quarantine mode with automatic expiry (restore / delete / keep) and a manifest table that flags options that are still being accessed.</li>
<li><strong>No server-side backup</strong>: JSON exports are browser downloads (or explicit CLI <code>--output</code>), never written to disk on the server — so option_value content does not leak into <code>wp-content/</code> snapshots.</li>
<li>REST API under <code>/wp-json/orpharion/v1/*</code> (requires <code>manage_options</code>).</li>
<li>WP-CLI commands for scripted pipelines, including <code>--accessor-type</code> / <code>--inactive-only</code> filters on <code>list</code>, <code>export</code>, and <code>clean</code> (<code>clean</code> requires an explicit <code>--i-have-a-backup</code> acknowledgment).</li>
</ul>
<h3>License</h3>
<p>This plugin is licensed under the GPL, version 2 or later.</p>


Orpharion

Track which plugin or theme accesses each wp_options row, then quarantine or clean orphans.

AAA Option Optimizer vs Orpharion