Huge wp_icl_translate and wp_icl_translation_status

Tagged: Exception

This topic contains 0 reply, has 1 voice.

Last updated by erikM-19 1 year, 6 months ago.

Assisted by: Shekhar Bhandari.

Author	Posts
June 19, 2024 at 9:54 am #15754557
erikM-19	Background of the issue: I am trying to reduce the size of the database tables 'wp_icl_translate' and 'wp_icl_translation_status', which have become very large. I have already completed all the steps from the temporary plugin provided at https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/, all jobs are deleted and the table is optimized but the table sizes remain unchanged. Symptoms: The 'wp_icl_translate' table is 386.1 MiB (142k rows) and the 'wp_icl_translation_status' table is 199.0 MiB (3.7k rows), which is much larger than expected compared to the 'wp_posts' table which is 182.2 MiB (59k rows). Questions: Could you please advise on further steps to drastically reduce the size of these tables to normal proportions?

Author

Posts

June 19, 2024 at 9:54 am #15754557

erikM-19

Background of the issue:
I am trying to reduce the size of the database tables 'wp_icl_translate' and 'wp_icl_translation_status', which have become very large. I have already completed all the steps from the temporary plugin provided at https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/, all jobs are deleted and the table is optimized but the table sizes remain unchanged.

Symptoms:
The 'wp_icl_translate' table is 386.1 MiB (142k rows) and the 'wp_icl_translation_status' table is 199.0 MiB (3.7k rows), which is much larger than expected compared to the 'wp_posts' table which is 182.2 MiB (59k rows).

Questions:
Could you please advise on further steps to drastically reduce the size of these tables to normal proportions?