{"id":37223,"date":"2025-03-19T04:24:45","date_gmt":"2025-03-19T04:24:45","guid":{"rendered":"https:\/\/www.wpstaq.com\/?post_type=knowledgebase&p=37223"},"modified":"2025-03-19T04:24:45","modified_gmt":"2025-03-19T04:24:45","slug":"how-to-optimize-autoloaded-options-in-wordpress-for-better-performance","status":"publish","type":"knowledgebase","link":"https:\/\/www.wpstaq.com\/sg\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/","title":{"rendered":"How to Optimize Autoloaded Options in WordPress for Better Performance"},"content":{"rendered":"

Overview<\/h2>\n

Autoloaded options in WordPress are stored in the database and loaded on every page request. While these options improve performance when used correctly, excessive or unnecessary autoloaded options can slow down your site, causing longer query execution times, increasing memory usage, and even affecting backend performance.<\/p>\n

To improve site speed and reduce database bloat, follow this guide to identify and remove unnecessary autoloaded options.<\/p>\n

Before You Begin<\/h2>\n

Before making any database modifications, it\u2019s strongly recommended to take a backup of the database<\/a> to ensure you can restore data if needed.<\/p>\n

Step 1: Check for Autoloaded Options in Site Health<\/h2>\n

In your WordPress backend, go to Tools > Site Health<\/strong>. If autoloaded options are impacting performance, you may see the following warning under “Recommended improvements”:<\/p>\n

\"\"<\/p>\n

Step 2: Identify the Largest Autoloaded Options<\/h2>\n

To find the largest autoloaded options in your WordPress database, follow these steps:<\/p>\n

1. Copy and Modify the SQL Query<\/h3>\n

Paste the following SQL query into a text editor like Notepad or Sublime Text:<\/p>\n

SELECT option_name, LENGTH(option_value) AS option_size\r\nFROM wp_options\r\nWHERE autoload = 'yes'\r\nORDER BY option_size DESC\r\nLIMIT 50;\r\n<\/pre>\n
Important:<\/strong> The database prefix may not be wp_<\/code> on your site. You’ll need to confirm and update it accordingly.<\/p>\n
2. Find the Database Prefix<\/h3>\n
To determine the correct database prefix, go to your site’s Staq Panel<\/strong> and navigate to Database > Table<\/strong>:<\/p>\n
\"\"<\/p>\n
In this example, the database prefix is ol1ao_<\/strong>:<\/p>\n
\"\"<\/p>\n
Update the SQL query in your text editor, replacing wp_<\/code> with your actual database prefix:<\/p>\n
\"\"<\/p>\n
3. Run the SQL Query<\/h3>\n
Back in the Staq Panel, under Database<\/strong>, click Run SQL Query<\/strong>:<\/p>\n
\"\"<\/p>\n
Paste the modified SQL query into the query box and click Execute<\/strong>:<\/p>\n
\"\"<\/p>\n
4. Analyze the Results<\/h3>\n
The query will return the largest autoloaded options, similar to the following:<\/p>\n
\"\"<\/p>\n
Identify unnecessary autoloaded options, such as those belonging to inactive or deleted plugins.<\/p>\n
Step 3: Remove Unnecessary Autoloaded Options<\/h2>\n
Once you identify unnecessary autoloaded options, you can delete them safely.<\/p>\n
1. Note Down Unnecessary Options<\/h3>\n
For example, in the results above, Beehive Pro<\/strong> plugin entries were found, even though the plugin is not active. These should be removed:<\/p>\n
\"\"<\/p>\n
2. Run a SQL Query to Delete Unnecessary Autoloaded Options<\/h3>\n
Modify the queries below to match the entries you want to remove and execute them in the Run SQL Query<\/strong> tool.<\/p>\n
Delete a Single Autoloaded Option<\/h4>\n
DELETE FROM ol1ao_options WHERE option_name LIKE '_transient_beehive_%';\r\n<\/pre>\n
Delete Multiple Autoloaded Options<\/h4>\n
DELETE FROM ol1ao_options\r\nWHERE option_name IN (\r\n'_transient_beehive_29764f09266adcea77126e85f9353733',\r\n'_transient_beehive_eb95769b5da0de5dc5cd8771c080459b',\r\n'beehive_settings'\r\n);\r\n<\/pre>\n
If successful, you should see the message “Query was successfully executed in X seconds.”<\/strong><\/p>\n
Step 4: Verify Improvements<\/h2>\n
After deleting unnecessary autoloaded options:<\/p>\n
    \n
  • Flush Redis Object Cache<\/strong> if enabled.<\/li>\n
  • Verify that the website functions correctly.<\/li>\n
  • Check Site Health again to confirm that “Autoloaded options could affect performance” is now under the Passed tests<\/strong> section.<\/li>\n<\/ul>\n
    Conclusion<\/h2>\n
    By optimizing autoloaded options, you can significantly improve backend performance and reduce database load. Regularly reviewing and cleaning autoloaded options ensures your WordPress site remains fast and responsive.<\/p>\n","protected":false},"featured_media":0,"parent":0,"template":"","class_list":["post-37223","knowledgebase","type-knowledgebase","status-publish","hentry","categories-optimize-scale"],"acf":[],"yoast_head":"\nHow to Optimize Autoloaded Options in WordPress for Better Performance - Managed Hosting Platform for WordPress<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Optimize Autoloaded Options in WordPress for Better Performance - Managed Hosting Platform for WordPress\" \/>\n<meta property=\"og:description\" content=\"Overview Autoloaded options in WordPress are stored in the database and loaded on every page request. While these options improve performance when used correctly, excessive or unnecessary autoloaded options can slow down your site, causing longer query execution times, increasing memory usage, and even affecting backend performance. To improve site speed and reduce database bloat,…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Managed Hosting Platform for WordPress\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/staqhosting\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2025\/03\/1-autoloaded-options-warning.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/\",\"name\":\"How to Optimize Autoloaded Options in WordPress for Better Performance - Managed Hosting Platform for WordPress\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/1-autoloaded-options-warning.png\",\"datePublished\":\"2025-03-19T04:24:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/#breadcrumb\"},\"inLanguage\":\"en-sg\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-sg\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/1-autoloaded-options-warning.png\",\"contentUrl\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/1-autoloaded-options-warning.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.wpstaq.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Optimize Autoloaded Options in WordPress for Better Performance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#website\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/\",\"name\":\"Managed Hosting Platform for WordPress\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wpstaq.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-sg\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#organization\",\"name\":\"Staq\",\"alternateName\":\"WPStaq\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-sg\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/cropped-LogoNoText.png\",\"contentUrl\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/cropped-LogoNoText.png\",\"width\":512,\"height\":512,\"caption\":\"Staq\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/staqhosting\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/wpstaq\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Optimize Autoloaded Options in WordPress for Better Performance - Managed Hosting Platform for WordPress","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/","og_locale":"en_US","og_type":"article","og_title":"How to Optimize Autoloaded Options in WordPress for Better Performance - Managed Hosting Platform for WordPress","og_description":"Overview Autoloaded options in WordPress are stored in the database and loaded on every page request. While these options improve performance when used correctly, excessive or unnecessary autoloaded options can slow down your site, causing longer query execution times, increasing memory usage, and even affecting backend performance. To improve site speed and reduce database bloat,…","og_url":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/","og_site_name":"Managed Hosting Platform for WordPress","article_publisher":"https:\/\/www.facebook.com\/staqhosting\/","og_image":[{"url":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2025\/03\/1-autoloaded-options-warning.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/","url":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/","name":"How to Optimize Autoloaded Options in WordPress for Better Performance - Managed Hosting Platform for WordPress","isPartOf":{"@id":"https:\/\/www.wpstaq.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/#primaryimage"},"image":{"@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2025\/03\/1-autoloaded-options-warning.png","datePublished":"2025-03-19T04:24:45+00:00","breadcrumb":{"@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/#breadcrumb"},"inLanguage":"en-sg","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/"]}]},{"@type":"ImageObject","inLanguage":"en-sg","@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/#primaryimage","url":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2025\/03\/1-autoloaded-options-warning.png","contentUrl":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2025\/03\/1-autoloaded-options-warning.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-optimize-autoloaded-options-in-wordpress-for-better-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.wpstaq.com\/"},{"@type":"ListItem","position":2,"name":"How to Optimize Autoloaded Options in WordPress for Better Performance"}]},{"@type":"WebSite","@id":"https:\/\/www.wpstaq.com\/#website","url":"https:\/\/www.wpstaq.com\/","name":"Managed Hosting Platform for WordPress","description":"","publisher":{"@id":"https:\/\/www.wpstaq.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wpstaq.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-sg"},{"@type":"Organization","@id":"https:\/\/www.wpstaq.com\/#organization","name":"Staq","alternateName":"WPStaq","url":"https:\/\/www.wpstaq.com\/","logo":{"@type":"ImageObject","inLanguage":"en-sg","@id":"https:\/\/www.wpstaq.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/05\/cropped-LogoNoText.png","contentUrl":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/05\/cropped-LogoNoText.png","width":512,"height":512,"caption":"Staq"},"image":{"@id":"https:\/\/www.wpstaq.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/staqhosting\/","https:\/\/www.linkedin.com\/company\/wpstaq"]}]}},"_links":{"self":[{"href":"https:\/\/www.wpstaq.com\/sg\/wp-json\/wp\/v2\/knowledgebase\/37223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wpstaq.com\/sg\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/www.wpstaq.com\/sg\/wp-json\/wp\/v2\/types\/knowledgebase"}],"wp:attachment":[{"href":"https:\/\/www.wpstaq.com\/sg\/wp-json\/wp\/v2\/media?parent=37223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}