Problem:
The client is experiencing issues with many autoloaded options in the WordPress database related to WPML, as indicated by the WordPress Site Health Status.
Solution:
We recommend checking the "Autoloaded" data from the wp_options table using the following SQL query to identify the size of each autoloaded option (size will be in KB):
SELECT option_id, option_name, sum(char_length(`option_value`))/1024 as size FROM `wp_options` WHERE `autoload` = 'yes' GROUP BY option_id ORDER BY size DESC
After running this query, share the results with us for further analysis. It's important to note that WPML requires its autoloaded data for proper functionality, so we do not recommend disabling autoload for WPML-related options. For other plugins or themes, only consider removing options if they are no longer in use, and always ensure you have a recent backup before making any changes.
If this solution does not apply to your case, or if it seems outdated, please check for related known issues at https://wpml.org/known-issues/, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. If issues persist, we highly recommend opening a new support ticket for personalized assistance.
