wp_icl_translate - 2GB size

This thread is resolved. Here is a description of the problem and solution.

Problem:
The wp_icl_translate table is way too big.

Solution:
Follow the instructions from the following errata:
https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/

Relevant Documentation:
https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: Known issue

This topic contains 1 reply, has 2 voices.

Last updated by Eran Helzer 1 year, 6 months ago.

Assisted by: Eran Helzer.

Author	Posts
July 15, 2023 at 6:27 am #14041861
janisV	please help to reduce wp_icl_translate and other table size. currently 2gb. according to your forum, i should submit a ticket to solve this and get plugin.
July 16, 2023 at 3:15 pm #14045169
Eran Helzer Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+02:00)	Hi, I see you are aware of the errata, just in case adding the link here: https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/ Since you are asking for the plugin, here it is: hidden link Keep in mind that this is not an official plugin and you should run it by your own responsibility. Please make sure to have a working backup of your site before proceeding. Follow the steps exactly as they are described in the errata. Also, I want to point out that your debug information shows you do not meet WPML's minimum requirements (and many other plugins). - The WordPress memory limit is set to 40MB. You should increase this to 128MB, following our documentation on how to do that here: https://wpml.org/faq/checklist-before-opening-a-ticket-in-wpml-support/#how-to-increase-your-sites-memory-limit - The MySQL version you are using is lower than 5.6. Please update this yourself, or reach out to your provider and ask that he update the MySQL server you are using You can see all of the minimum requirements here: https://wpml.org/home/minimum-requirements/ Please update me if you manage to solve the size issue without any problems.