Siby P Varkey

Is your WordPress website loading slowly? The culprit is often hidden in plain sight: a bloated <code>wp_options</code> table.
Every time a visitor opens any page on your site, WordPress automatically loads all “Autoload” data from your database. Over time, as you install and uninstall plugins, this table fills up with “orphaned” data—leftovers that are no longer needed but continue to slow down every single page load. This increases your Time to First Byte (TTFB) and negatively impacts your SEO rankings.
Autoload Cleaner & Analyser is a professional-grade diagnostic platform designed to help you visualize, analyze, and safely remove this hidden bloat. Unlike simple scripts that can be dangerous, our plugin uses a forensic approach to database health.
Using a crowdsourced signature database, the plugin identifies the “owner” of almost every option (plugins, themes, or WordPress core). This gives you the confidence to delete data belonging to plugins you removed years ago, without the risk of breaking your current site.
<h3>🚀 Key Features</h3>
<ul>
<li>Visual Command Center: Stop guessing. The dashboard provides an instant snapshot of your database health, highlighting your “Top 5 Memory Hogs” and calculating your total “Cleanup Potential.”</li>
<li>Smart Analysis Engine: Our engine automatically cross-references your options against 780+ known signatures. It categorizes rows as “Core,” “Active,” or “Orphaned” so you know exactly what you are looking at.</li>
<li>The “Transient Killer”: WordPress transients are temporary cache files. Many plugins fail to clean them up, leading to thousands of useless rows. Our one-click tool purges expired transients safely.</li>
<li>Forensic Trash System: Safety is our priority. Deleted items are moved to a custom “Trash” table first. You can Undo or Restore any option instantly if you realize it was still needed.</li>
<li>Global Bulk Actions: Select hundreds or thousands of rows at once. Toggle autoload status or move items to trash in seconds with our optimized bulk-processing logic.</li>
<li>Developer Console: A hidden powerhouse for advanced users. Inspect raw database values, manage the JSON signature file, and toggle “Deep Clean” mode for a thorough audit.</li>
</ul>
<h3>🛡️ Safety & Reliability Protocols</h3>
We believe a performance tool must be the safest plugin on your server: 
1. Trash-First Workflow: We never perform “hard deletes” on the first step. Data is always recoverable until you manually empty the trash. 
2. Core Protection: Essential WordPress system options are hard-coded as “Protected” and cannot be deleted by the plugin. 
3. Backup Integration: The system encourages best practices by detecting and alerting you to your backup status before performing major operations.
For a complete walkthrough, advanced tutorials, and detailed troubleshooting, please visit our <a href="https://www.zetozone.com/autoload-cleaner-docs.html" rel="nofollow ugc">Official Documentation</a>.

Autoload Cleaner & Analyser

Professional database analyzer. Detect hidden memory hogs, clean the wp_options table, and boost site performance safely.

Moris Papasmadov

Admin dashboard widget measuring and monitoring MySQL / MariaDB <a href="https://mariadb.com/resources/blog/flexible-mariadb-server-query-cache" title="MariaDB Query Cache" rel="nofollow ugc">query cache</a> performance & statistics – to optimize sizing configuration and highlight bottlenecks.
<h4>Why</h4>
Database Query for <a href="https://kinsta.com/knowledgebase/wp-options-autoloaded-data/#what-is-the-wp_options-table" title="What is the wp_options table" rel="nofollow ugc">Options Autoload</a> is repeatedly executed for each WP page load and its poor performance has been identified as a good indicator for a poorly performing database resulting in slow site.
<h4>How</h4>
<ul>
<li>Use dashboard widget to measure and monitor <code>Options Autoload Query Time</code></li>
<li>Use dashboard widget to measure and monitor <code>Options Autoload Query Size</code> 
This query result size increases constantly over time, as WP site usage grows – but its oversized sudden growth or constant balooning must not be overlooked.</li>
</ul>
Heavy plugins might rely heavily on adding data to <code>Options Autoload Query Size</code>. 
Poorly written plugins causing WP performance degradation have been found to constantly increase this query result size.
<h4>Time Metrics</h4>
‘Options Autoload Query Time’ is measured in milliseconds (ms)
0 ms – great performance below one millisecond 
 1-2 ms – good performance 
 3-5 ms – OK performance 
 50+ ms – poor performance should be investigated
<h4>Size Metrics</h4>
‘Options Autoload Size’ is measured in Bytes 
If you have the control to enable the database server wide query cache – configure query_cache_limit to be larger than <code>Options Autoload Size</code>
20,000 Bytes – freshly installed clean wordpress site 
 30,000 Bytes – small wordpress site 
 50,000 Bytes – medium wordpress site 
 250,000 Bytes – large wordpress site 
 2,000,000+ Bytes – too large should be investigated 
( <code>all above are rough metrics</code> )

MySQL query cache stats

Admin dashboard widget measuring MySQL database performance & query cache

Autoload Cleaner & Analyser vs MySQL query cache stats