Background of the issue:
I need to clean the autoloaded options from WPML on my site hidden link. The options include wp_installer_settings (122kb), icl_sitepress_settings (42kb), and _icl_cache (38kb) and so on. I saw online a special plugin for that, but it was recommended to ask for support.
Symptoms:
Autoloaded options are impacting performance
Questions:
How can I clean the autoloaded options from WPML?
Hello!
We have plans on our roadmap to improve and decrease the size of wp_installer_settings and our devs are investigating the possibility.
You can monitor the erratum page for the fixes: https://wpml.org/errata/big-size-for-wp_installer_settings/
About the other keys - they both depend on the amount of contents - like custom fields, posts, taxonomies, plugins that your site is using and this cannot be safely decreased without affecting the functionality of the site.
Any idea about the timing to reduce the wp_installer_settings?
Also, I don't only have those 3, altogether they represent:
- CMS: 278.58 KB over 58 options
- WCML: 12,58 kb over 28 options
- WPML String: 1,33 kb over 7 options
- SEO ML: 5,33 kb over 2 tables
Plus, some uncategorized, WPML represents about 40% of the autoloaded options of my site.
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
Hello,
Our developers are working on implementing a solution to reduce its size.
I would suggest you wait for the WPML update that will include a fix for this issue.
The only thing I can suggest for now is the following repo that another client recommended on a ticket about the same issue, but I suggest you take a database backup before making use of it: hidden link
