How to Optimize WordPress Performance by Cleaning Up Autoloaded Options
Print
  • opciones autocargadas en WordPres, Rendimiento
  • 12583

How to Optimize WordPress Performance by Cleaning Up Autoloaded Options

If your WordPress website is running slow despite using caching plugins like WP Rocket or server-level tools such as LiteSpeed, one hidden culprit could be the autoloaded options stored in your database. In this article, we explain what these options are, why they matter, and how to safely clean them up to improve your site’s performance.

 

ad = yes,” meaning they load on every page request, regardless of whether they are needed.

When this table gets too large (especially above 500 KB in total autoload size), it can slow down your entire website, increase memory usage, and create unnecessary load on your server.


How to Identify Heavy Autoloaded Options

If you have access to phpMyAdmin, follow these steps:

  1. Go to your WordPress database and open the wp_options table.

  2. Run the following SQL query to find the heaviest autoloaded options:

sql
 
SELECT option_name, LENGTH(option_value) AS size FROM wp_options WHERE autoload = 'yes' ORDER BY size DESC LIMIT 50;
  1. Review the results. Common offenders are leftover data from uninstalled plugins such as wpml, elementor, woocommerce, redux, or rank_math.


Safer Method: Use a Plugin

If you prefer a safer and user-friendly method, use a tool like Advanced Database Cleaner:

  • Install and activate the plugin from the WordPress plugin directory.

  • Navigate to: WP DB Cleaner > Autoload Options.

  • Sort entries by size.

  • Delete only options associated with plugins or themes that are no longer active.

Important: Never delete entries unless you are absolutely sure. Always perform a full backup before making changes.


After Cleanup: What to Do

  1. Clear any caching systems, such as WP Rocket and LiteSpeed Cache.

  2. Use tools like Query Monitor or GTmetrix to check your performance before and after the cleanup.

  3. Monitor your server resource usage to ensure your website is running efficiently.


Autoloaded options are often overlooked in WordPress performance optimization. Cleaning them up can lead to faster load times, reduced server stress, and an overall better experience for your visitors. Regular database maintenance should be part of your long-term website management strategy.

Was this answer helpful?

Related Articles