Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsThe safest cleanup is selective: measure the total autoloaded payload, identify the owner and request frequency of the largest options, then either leave needed values alone, disable autoload for values used only on specific requests, or delete only confirmed leftovers. Do not delete rows simply because their names look unfamiliar or their values are large.
Antihost offers managed WordPress hosting with free migration, one-click staging and a 14-day free trial.
What autoloaded options are—and why they affect performance
WordPress stores configuration and other key-value data in the wp_options table (although a site may use a different database-table prefix). Each row has an autoload decision. During WordPress’s all-options initialization, rows marked for autoload are loaded together so code can read them without issuing a separate database query for every setting.
As an Amazon Associate I earn from qualifying purchases.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
That convenience is useful for values needed throughout a site, such as settings read on most frontend requests. It is wasteful for a value needed only on an occasional administration screen, a particular URL, or a scheduled task. The practical cost is the combined payload loaded into memory and processed on requests, not merely the number of rows. A small number of large values can matter more than many tiny settings.
“Autoloading too many options can lead to performance problems, especially if the options are not frequently used.”
#1 Best Overall
Sale
Gaoye Blue Light Blocking Glasses
- BLUE LIGHT BLOCKING GLASSES: Our blue light glasses for women boast UV400 protection, blocking harmful blue rays from computer screens. With these bluelight glasses women, you can enjoy gaming, reading, or watching TV with no worries of eye strain.
- EYE RELIEF: Our blue light glasses are engineered to reduce blurry vision or strain caused by prolonged screen time. These womens blue light glasses aid in better sleep by preventing blue light from disrupting your natural sleep cycle, helping you fall asleep faster and enjoy a more restful night's sleep, making them the perfect christmas present.
- COMFORTABLE: Crafted from durable material, our trendy blue light glasses for woman or blue light glasses men ensure long-lasting comfort. The high-transmittance lenses accessories, gamer gifts for men, help keep your eyes relaxed. Perfect stocking stuffers, gifts for gamers men, christmas gifts for men, halloween costumes.
- LIGHTWEIGHT: These clear blue light glasses feature a lightweight frame, meaning they’ll stay comfy for long-term wear. Perfect as blue blockers glasses for women or mens blue light glasses, these non-prescription fake glasses for men can be worn throughout the day. The blue light blocking glasses women feature polycarbonate HD lenses, which are anti-reflective and restore true color.
- WORRY-FREE PURCHASE: If you experience any issues, our support team is ready to assist you quickly. These are the perfect costume glasses for cosplay dressing up.
There is no universal byte limit that defines a healthy site. The right target depends on the site’s traffic, code, object-cache behavior, hosting resources, and which settings are genuinely needed on most requests. Cleanup should therefore be evidence-led and reversible rather than based on a fixed threshold.
Prepare a rollback before touching the table
Changing an autoload flag is usually reversible; deleting an option is not unless you can restore it. Complete these checks before editing:
Recommended Free Tools
- Create a current database backup and verify that the backup can actually be restored.
- Know which WordPress installation and database the command line is connected to. Run WP-CLI from the site’s WordPress directory.
- Record the option names you intend to change, their current autoload state, and their owning plugin, theme, or core component.
- Plan a small batch. Changing one or a few related options makes a regression easier to identify than changing hundreds of rows at once.
- Make sure you can clear or refresh the site’s relevant object and page caches after the change.
A backup is not a substitute for understanding ownership. It is the recovery path if a plugin loses a setting, an administrator screen starts throwing errors, or a theme renders incorrectly.
Measure the current autoloaded payload with WP-CLI
Get the total size
From the WordPress installation, run:
wp option list --autoload=on --format=total_bytesThis reports the combined size of options that WP-CLI classifies as autoloaded for the site. Keep the output as your before measurement. Re-run the same command after each cleanup batch rather than judging success from a single option in isolation.
WP-CLI documentation uses 33198 bytes in an example output. That number illustrates the command’s format; it is not a recommended target or a promise that a site at that size is healthy.
Find the largest values
List names and sizes with:
wp option list --autoload=on --fields=option_name,size_bytes --format=csvThe command returns a CSV report containing each option name and its size in bytes. Sort the output in a spreadsheet or with your normal CSV-capable shell tools so the largest values appear first. Do not infer that the first rows are disposable: size identifies candidates for investigation, not permission to delete.
Rank #2
- WINDEX GAMING WIPES: effortlessly clean all your gaming gear and gaming electronics in one easy step with our new Windex Gaming Wipes
- AMMONIA FREE: our ammonia-free formula is safe to use on all of your favorite gaming equipment like consoles, headsets, controllers, screens, keyboards, and more
- PRE-MOISTENED WIPES: each wipe instantly removes dust, dirt, and stubborn smudges and fingerprints leaving a streak-free shine
- ANTI-STATIC: great for cleaning and wiping down your gaming gear and electronics leaving behind no visible residue
- COMPACT RESEALABLE PACKAGE: store your pack of Windex Gaming Wipes anywhere in your home for whenever a quick and easy wipedown is needed
Check one option’s current flag
For a candidate, inspect its state directly:
wp option get-autoload OPTION_NAMEReplace OPTION_NAME with the exact row name. Save the result before changing it. WordPress versions and command implementations have evolved, so an audit should not assume that every installation represents the decision with one literal string.
Identify what each large option belongs to
Names often contain a plugin or theme prefix, but naming conventions are not proof of ownership. A value may be a legitimate configuration blob, a cache, a migration remnant, or a setting left by software that is no longer active. An unfamiliar name alone does not establish that it is stale.
Trace the owner
- Search the active plugin and theme code for the exact option name and for calls that read, update, or delete it.
- Check the component’s documentation and uninstall routine. A documented cleanup procedure is safer than a manual row edit.
- Determine whether the option belongs to WordPress core, the active theme, an active plugin, an inactive component, or software that has been removed.
- Look at the value’s shape. Serialized arrays and structured configuration should not be edited by hand because a small syntax error can make the entire value unreadable.
- Establish where the value is used. A setting read on every frontend request has a different autoload decision from one read only on a plugin’s settings page.
Treat caches differently from configuration
A large option can be a cache generated by a plugin rather than durable configuration. Deleting a cache may be harmless if the owning software documents that behavior, but a cache can also be part of a plugin’s expected data model. Let the owner’s purge or reset feature remove it when one exists. If the value is active configuration, preserve it and change only the autoload decision when that meets the usage pattern.
Choose the least destructive fix
Use the following decision framework for every candidate. The key questions are whether the value is still needed, how often it is read, who owns it, whether the change preserves the value, and whether you can reverse it.
Free tools Windows power users keep installed
One-click scans. No signup required.
| Finding | Preferred action | What happens to the value | Risk and recovery |
|---|---|---|---|
| Needed across most frontend requests | Leave autoload enabled | Value and current loading behavior remain | No cleanup is required; monitor the total payload as the site changes |
| Still needed, but only on limited requests | Turn autoload off | Value is retained; WordPress retrieves it when code requests it | Usually reversible by restoring autoload; test every screen that uses the setting |
| Owned by an active plugin or theme | Use that software’s settings, update, or uninstall routine | The owner controls whether the value is changed or removed | Manual edits can violate the owner’s schema; follow its documented procedure |
| Confirmed leftover from removed software | Delete the specifically verified option after a backup | Row is removed from the table | Deletion requires restoration or recreation if the judgment was wrong |
| Core or site-identity setting | Leave it alone unless the owning documentation directs a change | Value remains unchanged | These values can affect URLs, administration, and basic site behavior |
Disable autoload while keeping the option
This is the normal fix when a setting remains valid but is read only on particular pages or requests. It changes the loading policy, not the stored value.
Use the WordPress API in code
WordPress provides wp_set_option_autoload_values() for changing autoload decisions without changing option values. A narrowly scoped call looks like this:
Rank #3
- Ergonomic & Adjustable Design: Fight "text neck" and improve your posture. Designed for comfort, it offers an adjustable height (7.1in-8.5in) (1.4in adjustable range) and angle (5°-85°) Please note: cell phone stand is only 9 inches tall—the length of a standard pencil
- Without blocking subtitles Perfect for office desk Tiktok Face Time Zoom video—this is the ultimate kitchen desk essential for phones! Perfect viewing experience while reducing neck back strain, A must-have for gamers streamers desk, and anyone who values both style and support!
- Sleek & Stable Design fits Otterbox Case: Say goodbye to bent cables, tangles, and tip-overs! LISEN’s stylish adjustable desk phone holder features a built-in charging hole and smart cable management, keeping your phone secure and your workspace clutter-free cool gadgets for men
- ANTI-SLIP DESIGN free hands: The under 10.00 items easy gadgets back and the bottom of this kitchen essentials for women are fully covered by anti-skid silicone, which LISEN stand up desk decor can provide maximum protection device from any scratches and slides
- Your Perfect Viewing Companion:If your product arrives damaged or breaks within 365 days, reach out to LISEN for a quick and hassle-free solution. Struggling with assembly, like tightening the screw? We’ve got your back! Your experience matters to us. (Product including: phone Holder stand*1, screw*1, hexagon screwdriver*1, specification*1)
$result = wp_set_option_autoload_values(
array(
'OPTION_NAME' => false,
)
);Use the real option name in place of OPTION_NAME. Keep this in an appropriate maintenance routine or deployment step, not in code that runs on every request. Check the return value and confirm that the option’s owner still reads it correctly.
Use WP-CLI
The equivalent command is:
wp option update OPTION_NAME --autoload=offDespite the command name, this operation is being used to update the row’s autoload setting; it does not intentionally replace the option’s value. Run wp option get-autoload OPTION_NAME afterward and retain the before-and-after output in your change notes.
When turning autoload off is appropriate
- The option is needed only on a plugin’s settings screen or a small set of frontend URLs.
- The plugin or theme still owns and understands the value.
- You have tested the code path that reads it directly rather than relying on the all-options cache.
- The site’s WordPress version and WP-CLI version support the command syntax you are using.
Do not use this as a substitute for removing a genuinely abandoned option. A stale row remains stale even if it is no longer autoloaded; it still occupies database space and may confuse future maintenance.
Delete only confirmed leftovers
Deletion is justified when you have evidence that the original software has been removed, no active code reads the option, the value is not a core or site-identity setting, and the backup is current. If any of those points is uncertain, retain the row and investigate further.
Delete one named option
For a verified leftover, use a narrowly targeted WP-CLI command:
wp option delete OPTION_NAMEReplace the placeholder with one exact option name. Review the name before executing. For several confirmed leftovers, process a small, explicit list and verify after each batch. Avoid broad wildcard deletion: a prefix can be shared by current and obsolete components, and a pattern can match a setting you did not intend to remove.
Rank #4
- Easy Installation: Our gaming lights have been designed to enhance your entertainment experience. Simply position the led light bar next to your TV or game console to create a game room environment with ease. They come with USB power and a 60 inch cord for direct mounting and mobility
- Audio Syncing & Extensive Mode: The built-in high-sensitivity music sensor allows you to sync the TV led lights to your favorite music. Lights react and move to the beat of music, film and game audio, creating an incredible immersive sound and light experience – and all without the need for an additional hub. You can choose from 64+ patterns, including strobe, illusion, jump, energy, gradient, running, chasing, fluttering mode etc. Each mode can be applied to different scenes
- 64+ Chasing IC+RGB & W Effect: The independent control design of IC+RGB and white all-in-one multifunctional rgbw led bar lights monitor backlight allows you to easily switch the led lights for desk between IC+RGB and white to enjoy a variety of lighting effects, you can choose white lighting mode with high brightness for better illumination when working, etc. Choose IC+RGB lighting mode when you need to create an entertaining atmosphere for the light show, 16 million colours of Color changing rgb light bar let you dance to the beat and create a dynamic party atmosphere
- Dynamic and Dimmable Lights: 1%-full brightness free brightness adjustment gives you the flexibility to adjust dimmable led light bar for room decorations or a variety of occasions
- USB Powered: USB light bars for room can be powered by powernank, usb charger, TV, Monitor, laptop PC mainframe, making behind TV led lighting bar easy to install in any location.TV led lights are powered by the TV usb interface / PC mainframe, can be turned on/off synchronously with TV / PC
Why manual SQL is a poor shortcut
Direct SQL edits bypass WordPress’s APIs and the ownership checks that protect serialized values and plugin-specific schemas. They also make it easier to update the wrong site or delete multiple rows through an imprecise condition. Use the documented WP-CLI operation or the owning software’s cleanup routine instead.
Understand version-dependent autoload values
Older WordPress installations commonly represent autoload decisions with values such as yes and no. Newer WordPress APIs accept boolean decisions and document those legacy literals as deprecated for the newer interfaces. The exact stored representation and WP-CLI behavior therefore depend on the WordPress and WP-CLI versions in use.
When writing an audit or automation, do not filter for only one literal without checking the site’s version and current command behavior. Prefer the supported API or WP-CLI flag for that installation, then verify the resulting state with wp option get-autoload.
WordPress also has dynamic handling that can disable autoload for excessively large values when options are added or updated. An option that was previously expected to autoload may consequently be stored with autoload disabled after a write. This behavior is a reason to inspect the actual flag rather than assuming it from the option’s history or name.
Use Performance Lab for a deeper audit when needed
The WordPress Performance Team recommends the Performance Lab plugin when a deeper examination of large autoloaded options is needed. Treat it as an investigative aid, not as an automatic deletion tool. Ownership, request frequency, and compatibility still need to be confirmed before changing or removing a row.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Verify every change on a live site
Verification should be part of the change, not an optional final glance.
Best Value
- Compatible with Wide Screens - To ensure compatibility with the dual monitor mount, your each monitor must meet three conditions at the same time: First, computer screens size range: 13 to 32 inches. Second, screen weight range: 4.4 to 19.8 lbs. Third, the back of the monitor screen must have VESA mounting holes with a pitch of 75x75mm or 100x100mm.
- Regarding the compatibility with desks - Your desk must meet three conditions at the same time: First, desk material: Only wooden desks are recommended, plastic or glass desks cannot be used. Second, desk thickness range: 0.59" - 3.54". Third, the bottom of the desk should not have any cross beams or panels, as this will interfere with installation. We recommend carefully checking that your desk and monitors meets all above conditions before purchasing.
- Dual C-Clamp Hold - Worried your dual monitors might wobble or slip? Our upgraded base uses a larger platform plus a dual C-clamp structure to lock the dual monitor arm firmly to your desk. Each arm safely keeps your screens steady while you type, click and game—no shaking, no sliding, just a clean and secure setup you can trust every day. It also provides Grommet Mounting installation choice, both options ensure stable and secure fixation for your 0.59" - 3.54" desk.
- Full-Motion Adjustment For Comfortable View - Pull the screen closer when you’re deep in a spreadsheet, push it back to watch videos, or rotate to portrait for coding — moving everything smoothly with just one hand. The monitor stand offers +85°/-50° tilt, ±90° swivel and 360° rotation. Raise your monitor up to 15.75″ to support a healthy sitting posture. Whether you’re working from home, gaming through the night, or switching between video calls and documents, getting the screens to your natural line of sight helps relieve neck, shoulder and back strain so you can stay focused longer with less fatigue.
- Keep Your Desk Organized: By lifting both screens off the desktop, this dual monitor stand opens up valuable space for your keyboard, notebook, docking station or a simple, clutter-free work area. Built-in cable management guides wires along the arms, keeping cords out of sight and out of the way. Enjoy a tidy, modern workstation that looks as good as it feels to use.
- Run
wp option list --autoload=on --format=total_bytesagain and compare it with the saved baseline. - Re-run
wp option list --autoload=on --fields=option_name,size_bytes --format=csvand confirm that the intended option moved out of the autoloaded report or that the deleted row is gone. - Refresh the relevant object and page caches so old all-options data does not distort the measurement.
- Exercise representative frontend URLs, the administration screens that use the setting, login/logout flows, scheduled tasks, and any integration that depends on the owning plugin or theme.
- Inspect PHP and application logs for notices, missing-setting errors, failed migrations, or fatal errors.
- Record the final autoload state and the test result for each changed option.
If a setting disappears or a page fails, first reverse an autoload-only change by restoring the previous flag. If the row was deleted, restore the database backup or use the owner’s documented re-creation process. Do not continue making unrelated changes while the cause is still unclear.
Common cleanup situations
The largest option is active plugin configuration
A large serialized configuration value may be entirely legitimate. If the plugin reads it on most requests, leave autoload enabled. If it is read only on a narrow route, disable autoload while preserving the value, then test that route and the plugin’s administrative screens.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →The option name belongs to a removed plugin
Confirm that the plugin directory is gone, no active theme or plugin references the name, and the former owner does not provide a cleanup or migration routine. Back up the database, delete only the exact verified row, and rerun the reports.
The value looks like a cache
Use the plugin’s cache purge or reset feature first. A cache that is regenerated by active code is not automatically abandoned, and deleting it manually can remove metadata the plugin expects. If the owner confirms that the cache row is disposable, remove it through the owner’s process or a narrowly targeted WP-CLI command.
The total does not fall after disabling autoload
Check the option’s flag again, clear relevant object and page caches, and repeat the report. A stale cache can continue serving the previous all-options payload. Also confirm that you changed the intended option name and that another large option was not the main contributor.
A new write unexpectedly changes the autoload state
Inspect the flag after the write. WordPress’s dynamic handling may disable autoload for an excessively large value. Review the code that updates the option and the WordPress version’s behavior before forcing a different decision.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →A repeatable maintenance workflow
The following sequence works for a one-time cleanup and for periodic maintenance:
- Back up the database and verify restoration.
- Capture the current total with
wp option list --autoload=on --format=total_bytes. - Export the name-and-size report with
wp option list --autoload=on --fields=option_name,size_bytes --format=csvand sort it for review. - For each large candidate, run
wp option get-autoload OPTION_NAME, identify its owner, and determine where it is read. - Leave frequently used configuration enabled.
- For valid but infrequently used settings, run
wp option update OPTION_NAME --autoload=offor usewp_set_option_autoload_values(). - For confirmed leftovers only, run
wp option delete OPTION_NAMEone named row at a time. - Refresh caches, rerun both reports, test representative pages and administration screens, and inspect logs.
- Document what changed and keep the backup according to your normal retention policy.
Repeat the audit after major plugin changes, migrations, or cleanup routines rather than treating the table as permanently fixed. New installations and updates can add options, and an option’s use pattern can change as a site’s features evolve.
What a successful cleanup actually means
Success is not reaching a particular byte count. It means the all-options payload contains settings that are genuinely needed broadly, infrequently used values are still available without being loaded on every request, abandoned rows have been removed only with evidence, and the site continues to work after caches and representative requests are tested. Keeping that distinction prevents an aggressive “smaller is always better” cleanup from trading a modest memory saving for broken configuration.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
