Problem: The client has installed the WPML plugin and followed steps to reduce the size of the icl_translate_job and other WPML tables by removing suggested job IDs and optimizing the tables. Despite these efforts, the table remains over 200MB, causing issues with database copying.
Solution: We reviewed the situation and found that a table size of 200MB for a site with 26 languages and extensive content is reasonable.
Upon further investigation, we used a sample query to analyze the contents of the translation_id and confirmed that the large size is justified due to the substantial content stored, with no duplicate elements found.
If this solution does not apply or is outdated, or if the problem persists, we recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If needed, please open a new support ticket at WPML support forum.
