kc3302

Thanks for the plugin. That will make it much easier to change the value for people who don’t want to change the database directly.

Anyone else having this issue and doesn’t know how/want to run SQL code – there is a plugin that has been updated to work with the new changes and identify large autoloaded options: Autoload Checker by Gerard Blanco.

@helijobs sorry, Site Health page doesn’t allow you to update the value.

AFAIK the only way to do it is directly in the database using phpmyadmin or another database editor which is not something I would recommend to non-technical users.

I had this issue and changed the autoload field to false for this item and it got rid of the error and I have not noticed any issues since doing it.

WordPress V6.6 introduced new values in the autoload field which caused this and many other plugins to show different autoloaded options size to user’s Dashboard/Site Health, but this plugin has been fixed to cater for that change.

• This reply was modified 2 months, 3 weeks ago by kc3302.

Thank you @threadi for your reply.

Your comments led me to find out that WordPress v 6.6 completely overhauled the values used in the autoload field. Unfortunately NONE of the available resources online (non-Wordpress) or the WordPress plugin I installed to help solve the problem are aware of this. The only place I found details was in comments in the actual code! WordPress documentation of this issue is lacking and I find on this support forum that many other people have had this exact issue.

Your SQL enabled me to find that I have a huge autoload item over 1MB which is the cause of my problem. It is named “_transient_dirsize_cache”, and when I search I find it is an issue that was supposedly fixed but it doesn’t seem like it has been………

Please note that these comments are not aimed at you personally, and I appreciate your assistance.

Anyone else having similar issues, below are two SQL commands which may help you find large autoload options. The 1st gives you the total size in KB of all autoloaded options (including all the new options as advised by @threadi), the 2nd lists them with the largest items at the top.

SELECT ROUND(SUM(LENGTH(option_value)) / 1024, 2) AS autoloaded_size_kb
FROM wp_options
WHERE autoload IN (‘yes’, ‘on’, ‘auto-on’, ‘auto’);

SELECT option_id, option_name, autoload, ROUND(LENGTH(option_value)/1024,2) AS Size_in_KB
FROM wp_options
WHERE autoload IN (‘yes’, ‘on’, ‘auto-on’, ‘auto’)
ORDER BY Size_in_KB DESC;

@leosantis the autload options were changed as you mention in WordPress 6.6 but this plugin hasn’t been updated to use them yet. As such it is not helpful to use this plugin on 6.6 or newer.