Background of the issue:
I installed WPML on my site, which uses WooCommerce, and noticed an increase in the load on the central processor. My hosting provides 100 processor minutes per day, and even without any activity on the site, it exceeds this limit in a short time. I can't use the website translation because of this problem. Link to a page where the issue can be seen: hidden link
Symptoms:
The site loads slowly, and there is high usage of processor minutes, which was not the case before installing WPML.
Welcome to WPML support. I will answer this ticket before it is assigned to one of my colleagues.
This needs to be checked in the context of pure WPML and woocommerce usage to see what is the impact.
What I suggest is to copy your website to a staging version so you will have no problems troubleshooting and do as follows:
- Switch to the default theme such as "TwentyTwenty" by going to "WordPress Dashboard > Appearance > themes".
- Go to "WordPress Dashboard > Plugins" and deactivate all plugins except:
. WPML Multilingual CMS
. WPML String Translation
. Woocommerce
. Woocommerce Multilingual
- Check if you can still recreate the issue.
- If not, re-activate your plugins one by one and check the issue each time to find out the plugin that causes the problem.
Also it will help if you can ask for detailed log what was the CPU usage cause, usually hostings have logs that give the exact PHP code or maybe database query causing the issue.
Christopher to test the opposite if it's possible for you.
**IMPORTANT:** Please try this in a staging environment or at least with a backup of your site files and database before continuing.
Disable all plugins except WooCommerce and WPM-related and temporarily change the theme to a default WordPress such as Twenty Twenty-five.
Is the issue resolved with these settings? If so, please reactivate one by one to see which conflicts.
This test will allow us to check if there is a compatibility issue causing the heavy load.
I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue.
It would be better to a testing site where the issue is replicated.
The information you will enter is private which means only you and I can see and have access to it.
Maybe I'll need to replicate your site locally. For this, I'll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site.
This will allow me to create a copy of your site and your content.
Once the problem is resolved I will delete the local site.
**IMPORTANT**
- Please make a backup of site files and database before providing us access.
- If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields.
Most WooCommerce stores see CPU spikes after activating WPML because large String-Translation tables and un-cached multilingual page variants multiply database calls. After it finishes processing all the strings the load should be back to normal.
Your site runs LiteSpeed Cache (LSC), so the fix focuses on (a) cleaning up WPML’s data tables, (b) configuring LSC to respect WPML’s cookies and to avoid aggressive crawls or purges.
❌ Please make a full website backup before proceeding ❌
1.
Please update WooCommerce to it's latest version, there were several performance improvements lately.
2.
• Back up the site and database.
• Go to WPML → Support → Troubleshooting and run “Cleanup and optimize string tables.”, and "Clear invalid strings" options. It might also be helpful to "Remove ghost entries from WPML tables". 
• In WPML → String Translation:
• Disable “Track where strings appear” and “Auto-register strings.” 
• Use Remove strings by domain to delete the default domain and any obsolete plugin domains. 
• If wp_icl_strings remains oversized, run
DELETE FROM wp_icl_strings WHERE status = 0;
to purge untranslated leftovers (don't ignore the backup warning, please)
Did you disable LiteSpeed cache? Did that make any improvement? If you enable it again, make sure you disable this:
Litespeed Cache > Cache > ESI tab > Enable ESI
I noted that WPML -> Translation Management is not working and that there are too many API calls when visiting some pages.
I disabled:
Litespeed Cache > Cache > ESI tab > Enable ESI
Then moved around your site's back and front end and Query Monitor didn't show any errors or warnings, as far as I can see. There were plenty before. Do you see any page where Query Monitor hints an issue?
Can you relate the CPU spikes to any action on your site? I mean, visiting a page or creating a product? Is there any way to reproduce the spike? Any hints in the server logs?
Best Regards,
Otto
The topic ‘[Closed] WPML puts a heavy load on the site’ is closed to new replies.
