andyZ-4

Problem:

How to reduce the size of WPML database tables?

Solution:

Please, back up everything before proceeding. And test the following on a staging area first.

For the icl_sitepress_settings option, you can keep it to be not autoloaded. Furthermore, you can reduce the wp_options table size by following these steps:

These option names have high amount of data and here's how you can reduce it:

- wpml_notices: can be deleted
- wpml_strings_need_link_fixed: can be reduced by running the Translate Link Targets option under WPML → Settings.
- _wpml_tp_api_logger: can be deleted
- WPML(logs) can be deleted
- wpml_tp_com_logs can be cleared from WPML > Support > communication log