This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Our wait time is higher than usual, please make sure you are meeting the minimum requirement - https://wpml.org/home/minimum-requirements before you report issues, and if you can take a look at current Known Issues - https://wpml.org/known-issues/. Thank you.
Background of the issue:
I am trying to address server performance issues during high traffic periods. We noticed that MySQL is consuming excessive CPU resources, and slow queries from WPML are a significant factor. We previously raised a complaint about this issue, but the ticket was closed due to inactivity. The link to the previous ticket is: https://wpml.org/forums/topic/very-slow-queries/. The issue can be seen on this page: hidden link.
Symptoms:
The server experiences slowdown due to excessive CPU usage caused by slow queries, with a high number of sleeping MySQL connections.
Questions:
How can I reopen the previous ticket regarding slow queries from WPML?
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
Hello,
I would like to request temporary access (wp-admin and FTP) to the website to investigate the issue further.
You can find the required fields below the comments section when you log in to leave the next reply. The information you provide is private, meaning only you and I can see and access it.
IMPORTANT
Please be sure to back up your website and database before granting us access.
If you can't see the "wp-admin / FTP" fields, your post and website credentials will be set to "PUBLIC." DO NOT publish the data unless you see the required wp-admin / FTP fields.
I may need to install a plugin called "All In One WP Migration" to create a copy of the website so I can investigate the issue further.
However, I would also be very grateful if you could provide a staging site or a copy of the website from your server for this purpose.
If you have any questions about creating such a staging site, you can consult your hosting provider. Please note that WPML must also be registered on this staging site at https://wpml.org/account/websites/.
If you are unable to provide such a copy of the website for testing, please let me know on this ticket.
The private reply form looks like this: hidden link
Click "I still need assistance" the next time you reply.
Video: hidden link
Please note that we are required to request this information individually on each ticket. We are not permitted to access any credentials that were not specifically submitted on this ticket using the private response form.
I wanted to inform you that I am now back from my annual leave and have completed the new theme, incorporating adjustments to the archive templates by using a post query dedicated to the specific template. This implementation is currently being tested on the staging site.
Given these updates, could we resume from where we paused earlier and continue troubleshooting the slow WPML queries? Please let me know the next steps.
Our DevOps team has identified that sleep queries and large queries are causing excessive CPU and MySQL consumption, leading to server downtime. They have suggested that implementing database indexing could help reduce the MySQL load and improve performance.
Since the slow queries originate from WPML, could you provide guidance on how we can optimize or index them for better performance and efficiency? Please let me know the best approach to proceed with this.
It would be best to start this ticket from scratch as old one was a bit complicated, so let's try to have a clear case here and if needed escalate further for 2nd tier to help.
1) I cannot suggest anything at this time, but once we check further, I can escalate and then we will be glad to help further and suggest any improvements.
2) Does the issue happen when you are using some other theme, or only with your custom theme?
3) Does the issue still happen when you are using only WPML plugins, for example? Maybe there are some conflicts with custom code/plugins.
4) Go to Plugins > Add New > Commercial > Click “Check for updated" and update WPML plugins to latest versions (4.7.2).
Please make sure to create a backup, before doing any actions, just in case.
5) If issue still happens after steps above, can you share with me document of slow queries and what are their loading time, only one affected by WPML, please.
This issue occurs not only with our custom theme but also with any theme. If we deactivate WPML, the slow queries disappear. This was already identified by your team in the previous ticket by Andreas and the team. For reference, you can check the previous ticket I mentioned earlier.
We are not using any custom plugins at the moment. All the plugins in use are compatible with WPML. As mentioned before, we tested the staging environment by deactivating other plugins and switching themes, but the issue persisted. However, when we deactivate WPML, the slow queries and slowness are resolved. Your team also confirmed this in the previous ticket.
We have now updated all plugins to the latest versions, including WPML.
Regarding the last ticket, the task was to modify the archive templates with a dedicated post query. Initially, we used the archive.php file to display all category and tag pages. Your team suggested creating separate templates such as author.php, category.php, and tag.php, and using individual post queries in each template instead of a common class. We have now implemented these changes, and the website is running with the new theme reflecting these updates. Due to the time required for these modifications, the old ticket was closed because of a communication gap. This is why I had to create a new ticket to continue the investigation.
Even after implementing these changes, we are still experiencing slow queries from WPML. How can we securely share these queries with you for further analysis?
Additionally, I would like to ask why the ticket resolution process is so slow, with responses taking hours or even days. This delay is causing difficulties on our end. Please let us know how we can expedite the process.
As you can see my replies are pretty quick, but from 2nd tier it takes time for them to check the issue and get back, it is not just a simple reply.
I also understand and am aware of your last ticket, but since it was closed, and that last approach / process did not help much, I am trying to set up a new more clearer new case here in order to speed things up and in the end help you out faster with the issue, hopefully giving and conclusion to your troubles.
So, you say: "As mentioned before, we tested the staging environment by deactivating other plugins and switching themes, but the issue persisted. ", if that is the case then this great, as we can easily further check and escalate any troubleshooting query.
Please share with me steps to check this query / page and wp-admin/ FTP access in next private reply and I will check and further escalate.
