Hi, I need some help. I need to optimize wp_options table and more precisely the autoloaded data. I see some records from WPML with large size
– 'wpml_strings_need_links_fixed',
- 'icl_sitepress_settings' ,
- 'ATE_RETURNED_JOBS_QUEUE',
- 'wpml_language_switcher_template_objects',
Do they need to be loaded automatically.
Will it harm the operation of the plugin if I set autoload to 'no'?
Thank you for the answer! I tried this optimization but nothing has changed. The size is really big. It is clear to me that this data is needed. But my question is do they need to load automatically every time?
Unfortunately, the data needs to be autoloaded in order for WPML to function so in short it is not recommended to turn autoload off.
a longer format answer as to what this is related to:
I can see you are using wp engine which has a known issue regarding the size of autoloaded data.
The issue happens due to WPEngine performance autoload data limitations. I am sure if they check logs they will see cron removed these tables due to their larger size.
I am sharing more info and a reply from WPEngine from a related ticket:
To answer WPMLs question is that we do remove large options from a database with a daily cron that runs.
In our environment, a large option is defined as having more than 1MB for autoload content and 4MB for non-autoload content. Rows in wp_options with autoload set to "yes" are considered large at 1MB because all of it is loaded up on every single page load.
