Huge wp_icl_translate and wp_icl_translation_status

Marqué : Exception

Ce sujet contient 0 réponse, a 1 voix.

Dernière mise à jour par erikM-19 Il y a 1 année.

Assisté par: Shekhar Bhandari.

Auteur	Messages
juin 19, 2024 à 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?

Auteur

Messages

juin 19, 2024 à 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?