Last updated November 16, 2026.
Your WordPress site feels slower than it used to. Pages take a little longer to appear, the admin area drags when you save a post, and nothing obvious has changed. Your theme is the same, your hosting plan is the same, and you have not added a dozen new plugins. One quiet cause of this kind of slowdown sits inside your database, in a table called wp_options, and it is called autoloaded data.
This guide is a WordPress autoloaded options cleanup walkthrough: what autoloaded options are, how to check how much your site carries, and how to clean them up safely, step by step, without breaking anything. Autoloaded options are settings WordPress loads on every single request, before it even knows which page a visitor asked for. That design makes sense for the handful of settings every page needs. It becomes a problem when that handful grows into a heavy load of leftover settings from plugins you no longer use, temporary data that never expired, and oversized chunks of stored configuration.
Everything here applies to any WordPress site, on any host, anywhere in the world. If you would rather not touch your database yourself, the last section explains when to hand this job to a professional, and our WordPress maintenance plans cover this kind of routine database care.
What autoloaded options actually are
WordPress stores most of its settings in the wp_options table. Each row has a name, a value, and an autoload flag. When the flag is set to load automatically, WordPress reads that row on every page load and every admin request, and keeps it in memory while the page is built. The loading happens through a core function that gathers all such rows at once, right at the start of the request.
WordPress 6.6 changed how this works. Before that version, the autoload column held only yes or no. Since 6.6, new rows can also hold on, off, auto, auto-on, or auto-off, and old yes and no rows still work. WordPress also stopped autoloading a newly saved option larger than 150,000 bytes when the code saving it did not ask for autoload. That change only helps new options. It does not clean up old rows, so a site that has run for years can still carry a large autoload total.
Some rows genuinely need to load every time. Your site address, your site title, the list of active plugins, and your current theme are examples. Every page needs those facts, so loading them early saves WordPress from asking the database for them one by one later.
The trouble starts with rows that do not need to be there at all, or do not need to load on every page. A plugin that stores a large settings array, a theme that saves a whole page of layout data as one option, or a marketing tool that keeps a growing log in the options table can all add weight to every request. Visitors never see these rows, but every one of them is fetched, read, and held in memory before the page content is even assembled.
Think of it like a bag you carry on every trip. A few essentials in the bag are fine. A bag stuffed with things you stopped using years ago slows every journey, even though you never take those things out.
How autoload bloat builds up over time
Autoload bloat rarely appears overnight. It accumulates in a few predictable ways.
First, uninstalled plugins leave their settings behind. Many plugins create options when you activate them, but never remove those options when you delete the plugin. The settings stay in wp_options, still marked to load automatically, long after the plugin itself is gone. A site that has tried many plugins over the years can carry a surprising amount of this dead weight.
Second, temporary data gets stuck. WordPress uses transients, which are temporary values with an expiry time, for things like cached API responses and short-lived calculations. When a transient expires, its value should be cleaned up, but expired transients and their timeout rows often linger, because WordPress only clears them when they are read again, or during infrequent cleanups. Clearing them tidies the table, but it does not shrink the autoload total, because a transient with an expiry time is never autoloaded in the first place. The transient rows that do add to autoload are the ones saved without any expiry time at all: those load on every request and never expire on their own.
Third, active plugins and themes store more than they need to autoload. A plugin may mark a large option as autoloaded simply because that was the default when the developer wrote it, even though the value is only used on one settings screen. A single oversized row can matter more than hundreds of tiny ones, because the cost is in the size of the data, not just the number of rows.
Finally, some plugins keep appending to the same option. A log, a history list, or a stored queue that grows with every event can turn one ordinary row into a very large one over months of use. By the time the site feels slow, the row has been growing unnoticed for a long time.
Stores carry extra weight of this kind. WooCommerce and its extensions store shipping zone settings, tax settings, and other configuration as options, and a store that has tried many extensions can carry a large autoload total from them alone. The same rules apply: find the owner of each heavy row before you change it, and never delete a row that belongs to an extension the store still uses.
How to check how much autoloaded data your site carries
Start with the easiest check, which needs no database access at all. In your WordPress admin, go to Tools, then Site Health, then the Status tab. If your autoloaded data has grown too large, Site Health raises a critical warning called Autoloaded options could affect performance, and it shows both the number of autoloaded rows and their total size. WordPress raises this warning when the total passes 800 KB, which gives you a clear line: below that, autoload is not your problem, and above it, cleanup is worth doing.
The warning only appears when the total is already above the line. Silence from Site Health means the total is under 800 KB, not that it is zero. If you want the exact number, run a second query that adds the sizes up:
SELECT ROUND(SUM(LENGTH(option_value)) / 1024, 2) AS autoload_kb, COUNT(*) AS option_count FROM wp_options WHERE autoload IN ('yes', 'on', 'auto', 'auto-on');
Compare the result with the 800 KB line before you decide whether cleanup is worth doing.
If you would rather not run SQL, the free Performance Lab plugin from the WordPress Performance Team adds a table of the largest autoloaded options to the Site Health screen, with a way to switch autoload off for a row from the dashboard. It only measures and switches flags. It does not delete rows, so the same backup and staging rules still apply.
If you want to see which rows are the heaviest, you need database access, usually through phpMyAdmin in your hosting panel. The query below lists the largest autoloaded rows first. Replace wp_options with your own table prefix if your installation uses a different one, and read the results only at this stage. Do not change or delete anything yet.
SELECT option_name, LENGTH(option_value) AS size FROM wp_options WHERE autoload IN ('yes', 'on', 'auto-on', 'auto') ORDER BY size DESC LIMIT 20;
Read the list from the top. The rows at the top are the ones costing you the most on every request. Note the names, and for each one, work out which plugin, theme, or part of WordPress created it. The name usually gives a strong clue, because developers normally prefix their options with the plugin or theme name. A row you cannot attribute to anything is a row to treat with extra care, as the next sections explain.
One exception: on a Multisite network, each site has its own options table, and network-wide settings live in a separate wp_sitemeta table. Check each site on its own, and do not treat a network setting like an ordinary site option.

Before you touch anything: back up and use staging
Database cleanup is routine work, but it is also work where a wrong deletion can break a site. Two precautions make it safe, and neither should be skipped.
First, take a full backup that includes the database, and confirm you know how to restore it. A backup you have never restored is a hope, not a safety net. If your host offers one-click database backups, use that, and keep the backup until you have confirmed the site works after cleanup.
Second, do the cleanup on a staging copy first whenever you can. Make the same changes on staging, click through the site, test the admin area, test any forms or checkout flow, and only then repeat the confirmed changes on the live site. If you have no staging environment and no way to restore a backup, stop here and ask a professional to do the job. That is not a failure. It is the correct call for a site you cannot afford to break.
Work through the steps below in order, one step at a time, checking the site after each one. If anything behaves oddly after a step, restore that step before moving on.
Step 1: Clear expired transients
Expired transients are the safest cleanup, and the right place to start, but be clear about what this step does. A transient that has passed its expiry time is dead data by definition, and clearing it tidies the options table. It does not shrink the autoload total, because a transient with an expiry time was never autoloaded in the first place. WordPress only clears expired transients when they are read again, or during infrequent cleanups, so on many sites they pile up. Clear them for table hygiene, then move on to the steps that actually reduce autoload.
The safe way to clear them is with a database query that removes only transients whose timeout value has already passed, or with a reputable database cleanup plugin that offers an expired-transients option. Either route removes the same kind of row: temporary data whose time has run out. Your site will simply regenerate any transient it still needs the next time it is requested.
The transient rows that do add to autoload are the ones saved without an expiry time. Those load on every request and never expire, so they never become expired transients. If your list of heavy rows shows _transient_ rows with no matching _transient_timeout_ row, those are the ones to look at: find which plugin created them, and if the plugin is gone, delete them as orphans under Step 2.
Do not delete all transients blindly. Active transients with time left are live cached data, and deleting them only forces your site to rebuild them, which can briefly slow things down rather than speed them up. Clear the expired ones, and leave the live ones alone.
Step 2: Remove rows left by plugins you already uninstalled
Once expired transients are gone, look again at your list of heavy rows. For each row, ask one question: does the plugin or theme that created it still exist on this site? If the plugin was deleted months ago and nothing on the site uses its settings, its rows are orphans, and removing them is the cleanup that usually makes the biggest difference.
Confirm the plugin is truly gone before you delete its rows. Check the Plugins screen, including the list of inactive plugins, and check whether another plugin from the same developer might share the same option prefix. When you are sure, delete the orphaned rows, then check the site: visit the homepage, a few inner pages, and the admin area. If everything works, the orphans are gone for good.
If you are unsure what created a row, do not delete it. The next step gives you a safer way to handle uncertain rows, and an uncertain row left in place costs far less than a wrong deletion.
Step 3: Turn off autoload for large rows you still need
Some heavy rows belong to plugins you still use. Deleting them would lose settings, so deletion is the wrong move. But many of those settings are only needed on one screen, such as the plugin’s own settings page, and do not need to load on every page of the site. For those rows, the right change is to switch autoload off, not to delete the row.
Turning autoload off keeps the value in the database, exactly where the plugin expects it, but stops WordPress from loading it on every request. The plugin can still read the value when it actually needs it. If the change causes any problem, turning autoload back on restores the old behavior immediately, which makes this step easy to reverse.
The query for one row looks like this, with the real option name in place of the placeholder:
UPDATE wp_options SET autoload = 'no' WHERE option_name = 'your_plugin_option_name';
Change one row at a time, and check the plugin’s behavior after each change. If a plugin misbehaves with autoload off, turn it back on and leave that row alone. Some options genuinely need to load early, and a plugin that breaks without them is telling you so.
If you are comfortable with a little code, WordPress 6.4 added a dedicated function for this change, wp_set_option_autoload(), which flips the flag without touching the value. It does the same job as the query above, through the proper API. Either route works. The rules are the same: one row at a time, and check the plugin after each change.
Step 4: What you should never delete
A few kinds of rows must never be removed, whatever their size. Rows owned by WordPress core, such as your site address, your home address, your site title, and the list of active plugins, are part of how WordPress runs. Deleting them can take the site down or lock you out of the admin area. Rows owned by plugins and themes still in use fall in the same category: their settings are live configuration, not clutter.
Some large rows are normal and should be left alone. The rewrite_rules row, which holds your permalink rules, is often one of the largest rows on a site, and the active_plugins row is meant to load on every request. Size alone does not make a row a candidate for deletion. Ownership does.
As a simple rule, never delete a row unless you can name what created it and confirm that thing is gone from the site. If the row name means nothing to you, search for the prefix in the plugin directory or in the plugin’s documentation before deciding. If you still cannot identify it, turn its autoload off instead of deleting it, and watch the site for a day. That approach removes the performance cost while keeping the data recoverable.
One more caution: never edit the value inside a row by hand unless you understand its format. Many option values are serialized, which means they store lengths alongside the data, and changing the text without updating those lengths corrupts the value. Deleting a whole orphaned row or flipping its autoload flag are safe operations. Rewriting the contents of a row is not.
Step 5: Keep autoload lean going forward
Cleanup is not a one-time event, and the point is to reduce autoloaded options for good, not just once. A site that is never maintained will slowly accumulate the same bloat again, because every plugin trial and every theme change can leave traces behind.
A light routine keeps the problem small. When you stop using a plugin, delete it properly and check whether its options remain, rather than leaving it deactivated for months. When you test a new plugin, note what it adds, so you can remove its traces if you decide against it. And every few months, repeat the Site Health check from earlier in this guide. If the autoload total is climbing again, you will catch it while it is still a small job.
One more warning sign: if the autoload total climbs back within days of a cleanup, a plugin is writing the data again on every run, and no amount of cleaning will hold. Find the plugin that owns the rows that came back, and either change its settings or replace it. Cleaning the same rows every week is treating the symptom, not the cause.
Regular maintenance of this kind is exactly what a care plan is for. If keeping up with database checks, backups, and updates is not work you want to do yourself, our WordPress maintenance plans include scheduled database cleanup, so bloat is caught before it becomes a slowdown. For a deeper look at why a site slows down in general, see our guide on why a WordPress site gets slow, and for the full routine this check belongs to, see the WordPress maintenance checklist.

When to ask a professional instead
Most of the steps above are safe for a careful site owner with a backup and a staging copy. A few situations call for professional help instead. If your site has no backup you can restore, no staging environment, and no hosting support to fall back on, do not start. If the heaviest rows belong to something you cannot identify, or if the site is already showing errors, a professional can investigate before anything is changed. And if your site is a store, where a broken checkout costs real orders, the stakes of a wrong deletion are higher than the savings of doing it yourself.
In those cases, the honest move is to ask for help before touching the database, not after. A professional will run the same steps in the same order, with a verified backup and a staging copy, and will know which rows are safe to remove on your particular setup. Before you ask, it helps to know what drives the cost of that help. Our guide to WordPress maintenance cost factors explains what you are actually paying for, so you can judge a quote fairly. If that help would be useful, talk to us, and we will look at your site before recommending anything.
Frequently asked questions
Will cleaning autoloaded options speed up my site noticeably?
It depends on how much bloat your site carries and where the slowness comes from. On a site whose autoload total is far above the Site Health warning level, cleanup removes work from every single request, so the improvement is real, especially on pages that are not cached and in the admin area. On a site whose autoload total is already small, the gain will be minor, and the real cause of slowness lies elsewhere, such as hosting or heavy plugins.
Is it safe to delete rows from wp_options?
It is safe when the row belongs to a plugin or theme that no longer exists on the site, and when you have a backup to restore. It is not safe to delete rows you cannot identify, rows owned by WordPress core, or rows owned by plugins still in use. When in doubt, turn autoload off instead of deleting, since that change is easy to reverse.
Do I need a plugin to clean autoloaded options?
No. The checks and changes in this guide can be done with Site Health and phpMyAdmin alone. A database cleanup plugin can make the work easier, especially for expired transients, but it is a convenience, not a requirement. Whichever route you choose, the same rules apply: back up first, work on staging, and never delete a row you cannot identify.
How often should I check autoloaded options?
For most small business sites, checking every few months is enough, and checking after a round of plugin changes is wise. Sites that test many plugins, or that run stores with heavy plugin stacks, benefit from checking more often. The Site Health warning is your early signal. If it appears, cleanup is due. If it does not, autoload is not your current problem.
Can autoload bloat break my site, or only slow it down?
Bloat on its own slows a site down. It does not break pages. Breakage comes from the cleanup itself, when a needed row is deleted by mistake. That is why this guide separates the safe steps from the risky ones, and why a backup and a staging copy matter more than any single query.
What changed in WordPress 6.6 for autoloaded options?
Three things. First, the autoload column can now hold on, off, auto, auto-on, or auto-off, as well as the old yes and no values, which still work. Second, WordPress stopped autoloading a newly saved option larger than 150,000 bytes when the code saving it did not ask for autoload. Third, Site Health added a check that warns when the total passes 800 KB. None of that cleans up old rows, so a site that has run for years still needs the steps in this guide.
Why did clearing expired transients not shrink my autoload total?
Because a transient with an expiry time is never autoloaded in the first place, so clearing it tidies the options table but does not change the autoload total. The transient rows that do add to autoload are the ones saved without any expiry time. Those load on every request and never expire on their own. If your heavy rows include _transient_ rows with no matching _transient_timeout_ row, those are the ones to look at.
Can I check autoload size without running SQL?
Yes. Site Health under Tools shows a warning when the total passes 800 KB, with the count and the total size. The free Performance Lab plugin from the WordPress Performance Team adds a table of the largest autoloaded options to the same screen, with a way to switch autoload off for a row from the dashboard. It does not delete rows, so the same backup and staging rules still apply.
What if the autoload size climbs back after I clean it?
A plugin is writing the data again on every run, and no amount of cleaning will hold until you find it. Look at which rows came back, find the plugin that owns them, and either change its settings or replace it. Cleaning the same rows every week treats the symptom, not the cause.
Does autoload bloat hit WooCommerce stores harder?
In practice, yes. Cart, checkout, admin, and scheduled-task requests are never served from a page cache, so they pay the full autoload cost on every request. Stores also carry shipping zone settings, tax settings, and extension configuration as options, which adds weight. The cleanup rules are the same: find the owner of each heavy row before you change it, and never delete a row that belongs to an extension the store still uses.
Can I just delete every row above a certain size?
No. Size alone does not decide. Some large rows are normal, such as the rewrite_rules row that holds your permalink rules and the active_plugins row. Ownership and use decide. Turn autoload off first for a row you are unsure about, because that change is easy to reverse. Delete only rows you can prove belong to a plugin or theme that no longer exists on the site, and only with a backup you can restore.
A lean database is a faster site
Autoloaded options are easy to overlook because they are invisible. Visitors never see them, and site owners rarely open the database. But every request your site serves starts by loading them, so a bloated set quietly taxes every page, every admin screen, and every checkout. WordPress autoloaded options cleanup is not complicated: check the total, clear expired transients, remove what uninstalled plugins left behind, and switch off autoload for large rows that do not need to load every time.
Done in that order, with a backup and a staging copy, cleanup is low-risk work with a real payoff. And kept as part of a regular maintenance routine, it stays a small job instead of growing into a slowdown. If you would like this kind of routine care handled for you, talk to us through WhatsApp, the contact page, or [email protected], and we will look at your site first and confirm what it needs before anything changes.



