We would like to request your assistance in investigating and resolving an issue related to slow queries and high CPU utilization on our website.
We have observed that under normal conditions, without WooCommerce enabled, our server CPU usage remains around 50% to 60%. However, once WooCommerce is activated (along with WPML), the CPU utilization significantly increases, reaching 90% to 100%. This spike is causing performance issues and is currently blocking further deployment.
We suspect that some queries related to WPML and WooCommerce integration may be contributing to the slowdown and high resource usage.
Could you please advise on the following:
Are there known performance issues or heavy queries related to WPML when used with WooCommerce?
Are there recommended configurations, optimizations, or best practices to reduce query load and CPU usage?
Any tools or debugging steps we can use to identify problematic queries?
Server Specs: Google Cloud Platform (GCP)
OS/Image: debian-11-bullseye-v20241112
Disk: 10GB (Balanced persistent disk)
Architecture: x86/64
Machine Type: e2-standard-8 (8 vCPUs, 32 GB Memory)
CPU platform: Intel Broadwell
Zone: asia-southeast1-a
We would appreciate any guidance or recommendations you can provide to help us resolve this issue.
I recommend following these steps to isolate the cause of the performance issue and gather more information:
- Create a full site backup or create a staging site with a copy of the production site
- Flush any cache memory that might exist
- Update all outdated plugins and themes, especially the WPML plugins
- If the issue persists, then:
-- Deactivate all plugins, including the WPML ones
-- Activate a default WordPress theme, like Twenty Twenty
-- Activate the WPML plugins, WooCommerce and WCML
-- If the issue disappeared, start by activating the theme and then the rest of the plugins, one by one, until the issue appears again and you find the culprit
