We are experience a quite extreme slowdown on a semi-large site using WPML.
Investigating the database, we are seeing a quite large amount of values in the WPML tables:
- icl_translate = 25.6 million records, 4.2GB
- icl_translate_job = 4.2 million records, 720MB
We are importing products semi-regularly from a CRM application using WP All Import. I think WPML is automatically translating these and is encountering some kind of loop or issue, causing an extreme number of jobs/translations and slowing down the site. Or at least, the admin interface.
My name is Eduard and I will help you with problem.
Before starting checking the issue I have a question, what option do we have to proceed?
1) Can we get access to some staging site where we can check out for the problem? As an alternative you can create a Duplicator package, so we can replicate for the issue locally.
2) If you have only production site available, we have some separate debugging plugin available, which we can setup and wait for some time to collect some metrics and investigate later how the data grows in the database and what are the sources of the growth.
Please let me know which option you would prefer follow.
Sure let's process with option 2. I can process installing the plugin and we will keep it activated for some days. It collects some metrics related to WPML work and changes made to the database.
Would you mind sharing access to your site so I can install the plugin and monitor it for some time? I've enabled the private box for you, so you can securely share the login details there.
Just so you know, all access information is completely secure – only our support team can see it, and once we've got everything sorted out and the issue resolved, you're free to remove that access anytime.
Thanks for your update. No problem, thanks, I will login tomorrow, check the site, install the plugin and update you if it is working and collecting metrics correctly.
Small update from my side
Thanks for providing access details. I logged in and checked the database. I think it will be better if I check locally first if I can find some pattern in the data and why such big amount of data was created in WPML tables. So, I downloaded the database, installed locally and will research it in the nearest days.
I will update after that with the next steps on this week.
As I mentioned in the previous reply, I cleaned the database on the March 12 and the involved tables had the following amount of data:
icl_translations -> 95.576
icl_translate -> 333.194
I rechecked just now and see the following amount of data:
icl_translations -> 95.586
icl_translate -> 333.194
So, it looks like the issue does not happen anymore. Based on the left data in the database it looks like some time ego Translate Everything was enabled and many 'acf-field-group' fields were sent for translation from that process for translation and that process was repeated many times. So, it should be fixed after some of the plugins updates. I also checked that 'acf-field-group' is set to not translatable field on the WPML settings page.
If anything similar comes up again, just let us know—we’ll be happy to help.
