Assistance Needed for Reducing Size of 'yng_icl_translate' and 'yng_icl_transl

Ce sujet est résolu. Voici une description du problème et de la solution.

Problem:
The client is experiencing an increase in database size due to large 'yng_icl_translate' and 'yng_icl_translation_status' tables within the WPML plugin.
Solution:
We recommend downloading the "WPML Delete Jobs" plugin using this link: WPML Delete Jobs plugin.
After installation, follow these steps:
1. Navigate to "Outils > WPML Delete Jobs".
2. The IDs will be pre-filled with the 50 job IDs to delete first. You can modify this list and remove certain jobs if you wish to keep them.
3. Click on "Delete" and wait for the operation to finish.
4. Click on "Optimize _icl_translation_status table" once you have finished.
5. Deactivate and delete the plugin.
Please ensure you have a backup of your database before proceeding with these steps, as it is crucial for safety.

If this solution does not seem relevant to your issue, please do not hesitate to open a new support ticket with us for further assistance. You can do so by visiting our support forum.

Il s'agit du forum d'assistance technique de WPML, le plug-in multilingue pour WordPress.

Il est accessible à tous, toutefois seuls les clients de WPML peuvent y publier leurs messages. L'équipe du WPML répond sur le forum 6 jours par semaine, 22 heures par jour.

Marqué : Known issue

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

Dernière mise à jour par Nicolas V. Il y a 1 année et 4 mois.

Assisté par: Nicolas V..

Auteur	Articles
Novembre 16, 2023 at 9:56 pm #14830863
hiboouD	Hello WPML Support Team, I am reaching out for assistance regarding an issue with my WooCommerce site, which is currently experiencing a significant increase in database size. This increase is primarily due to the large sizes of the 'yng_icl_translate 177.67 MB' and 'yng_icl_translation_status 146.55 MB' tables within the WPML plugin. From my understanding, these tables can grow large in size due to extensive data in the 'wp_posts' and 'wp_postmeta' tables, especially when using page builders or the Gutenberg block editor. My concern is to reduce the size of these tables without risking data integrity or site functionality. I would greatly appreciate if you could provide the following: 1. Specific instructions or a reliable script/plugin to safely reduce the size of these tables. 2. Any additional steps or precautions I should take to ensure the stability and performance of my site during this process. I have already backed up my site's database and files as a precaution. Thank you for your assistance and looking forward to your guidance. Best regards, EVREN AYAZ
Novembre 16, 2023 at 10:14 pm #14830919
Nicolas V. Supporter Les langues: Anglais (English ) Français (Français ) Fuseau horaire: America/Lima (GMT-05:00)	Bonjour, Bienvenue sur le support de WPML. Voici le lien pour télécharger le plugin "WPML Delete Jobs": lien caché Installez le puis suivez les instructions de cet errata: https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/ En résumé: - Allez dans "Outils > WPML Delete Jobs" - Les IDs seront pré-remplies avec les 50 job IDs à éliminer en premier. Vous pouvez changer cette list et retirer certains jobs si vous souhaitez les garder - Cliquez sur "Delete" et attendez que l'opération se termine - Cliquez sur "Optimize _icl_translation_status table" une fois que vous avez terminé - Désactivez et éliminez le plugin Je sais que vous l'avez déjà mentionné mais je dois l'écrire 😀 IMPORTANT: faites un backup de votre base de données avant.