[Resolved] The backend performance has degraded severely
This thread is resolved. Here is a description of the problem and solution.
Problem: The client reported slow page generation times in the admin panel, particularly when using the VikBooking plugin or general admin pages. They noted significant memory usage and load on WPML-related calls via Query Monitor, despite having Redis Object Cache and WP Rocket active. The client also inquired about integrating VikBooking with WPML for multilingual support, including translating booking texts and emails.
Solution: We addressed the performance issues by suggesting the client enable WordPress's debug mode to identify specific errors causing the slowdown. Instructions were provided to modify the
wp-config.php
file to enable detailed logging. For the integration of VikBooking with WPML, we clarified that VikBooking is not officially compatible with WPML. We provided links to developer guides on achieving WPML compatibility and a list of officially compatible booking plugins as alternatives. Additionally, we offered a sandbox site for testing VikBooking with WPML.
If this solution does not resolve your issue, or if it seems outdated or irrelevant to your specific case, we highly 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 further assistance is needed, please open a new support ticket at WPML support forum.
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.
Thanks for approving the installation of the Adminer script. I asked the second-tier supporter to proceed. We will update you here on any news regarding this issue.
We try to focus on one issue per ticket in our technical support forum. Otherwise, tickets can get cluttered and confusing for both users and supporters. Therefore, I've split the other ticket and created a new ticket with this issue. Please see the new ticket here.
Our second-tier supporter has made several changes to the tables, and he reported that as a result, the performance of your site's admin has improved significantly. I was unable to check it because I received this message: "Zakazan pristup mimo SK a CZ. skrze .htaccess povolte svou IP."
Could you please confirm that this problem is now resolved?
thank you for the update and for proceeding with the optimizations.
We have temporarily lifted the IP restriction in .htaccess, so you should now be able to access the admin panel if needed.
I can confirm that the performance of the WordPress backend has improved noticeably — thank you for the adjustments made to the tables.
While checking further, I noticed two entries listed under “Slow Queries” in Query Monitor.
One of them is related to:
SELECT language, value, status FROM wp_icl_string_translations WHERE string_id=...
Could you please clarify what this query does and whether it could be optimized or prevented from recurring?
Also, since you're already familiar with the site’s structure, would you personally recommend any additional adjustments (plugins, DB cleanups, WPML tweaks, etc.) to improve speed or reduce backend load?
Here are the comments from our second-tier supporters on the “Slow Queries” you presented. He wrote:
I checked the site backend.
For me, the query (seems related to RankMath and the titles of the site?)
SELECT language, value, status
FROM wp_icl_string_translations
WHERE string_id=189
takes 0.0006sec.
Why the user is taking more - should be diagnosed probably by the user's hosting provider, or if he has access to the server, he should check for load during the time when he tested.
The query about the action scheduler is either by RankMath or by WooCommerce.
It may indicate that something is wrong in the database tables(WooCommerce issue) for the action scheduler or an action that is not working properly (MailPoet, RankMath, WP Rocket, or some other plugin too!)
If it is the table's issue, then there might be missing indexes there as well.
Running:
SELECT * FROM `wp_actionscheduler_actions` WHERE `status` = 'in-progress'
via adminer, shows rocket_preload_job_check_finished, which is an action by WP Rocket for preloading cache.
Probably something is wrong there? Or maybe it is just normal. The client should contact WP Rocket support for assistance.
Thank you so much for the detailed explanation and for checking everything so thoroughly.
Everything seems to be working correctly now, and your insights were very helpful in narrowing things down. I’ve also contacted WP Rocket support as suggested, and I’m continuing to monitor performance on the hosting side.
I really appreciate your time and support — thank you again!
