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.

Michael Cannon

<p>Argh… it turn’s out that I was having problems with postmeta and options data being mixed. There went a day’s coding a migrator when I didn’t need it and doubt you either.</p>
<p>Anyways, just use the autoload cleanup and enforcer. That’s still quite valid.</p>
<p>~~Migrate left over <a href="https://wordpress.org/extend/plugins/advanced-custom-fields/" title="Advanced Custom Fields WordPress plugin" rel="ugc">Advanced Custom Fields</a> fields from wp_postmeta to wp_options while correcting autoload settings.~~</p>
<p>Convert previous ACF value migrations from autoload = ‘yes’ to ‘no’. This is very handy for performance optimization when you’ve got tens of thousands of custom fields. Can help drastically improve website load times.</p>
<h4>Thank you…</h4>
<ul>
<li><a href="http://mediaburn.org" title="Media Burn Archive — four decades of documentaries" rel="nofollow ugc">MediaBurn.org</a> for development funding.</li>
<li><a href="https://wordpress.org/extend/plugins/advanced-custom-fields/" title="Advanced Custom Fields WordPress plugin" rel="ugc">Advanced Custom Fields</a> for making custom WordPress site easier</li>
<li><a href="https://wordpress.org/support/profile/viper007bond" title="Viper007Bond WordPress profile" rel="ugc">Viper007Bond</a> for <a href="https://wordpress.org/extend/plugins/regenerate-thumbnails/" title="Regenerate Thumbnails WordPress plugin" rel="ugc">Regenerate Thumbnails</a> Ajax’d code base.</li>
<li><a href="http://www.ascic.net/" title="Željko Aščić's blog" rel="nofollow ugc">Željko Aščić</a> of <a href="http://www.touristplayground.com/" title="Tourist Playground" rel="nofollow ugc">Tourist Playground</a> for the plugin banner</li>
</ul>
<h3>TODOs</h3>
<ul>
<li>Implement ACF field migration</li>
</ul>


Advanced Custom Fields Migration Cleanup

Correct and prevent Advanced Custom Fields options migration autoload 'yes' to 'no'.

Orpharion vs Advanced Custom Fields Migration Cleanup