Itamar
WPML Supporter since 02/2016
Languages:
English (English )
Timezone:
Asia/Jerusalem (GMT+03:00)
|
Hi,
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.
https://wpml.org/forums/topic/split-the-site-does-not-redirect-to-the-stripe-payment-page/
Regards,
Itamar.
|
Itamar
WPML Supporter since 02/2016
Languages:
English (English )
Timezone:
Asia/Jerusalem (GMT+03:00)
|
Hi,
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?
Regards,
Itamar.
|
mbF
|
Hi Itamar,
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?
Thanks again for your help and support.
Best regards,
Josef
|
Itamar
WPML Supporter since 02/2016
Languages:
English (English )
Timezone:
Asia/Jerusalem (GMT+03:00)
|
Hi,
I'm glad that the performance has improved, and you could confirm this.
I passed on your inquiry to our second-tier supporter and will share his reply once I get it.
I appreciate your patience.
Itamar.
|
mbF
|
Hi Itamar,
thank you for the quick reply and for forwarding my question to the second-tier support — I’ll wait to hear back once you have their input.
In the meantime, I really appreciate your ongoing support with this. Let me know if there’s anything else needed from my side.
Best regards,
Josef
|
Itamar
WPML Supporter since 02/2016
Languages:
English (English )
Timezone:
Asia/Jerusalem (GMT+03:00)
|
Hi, Josef.
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.
I hope this information is helpful to you.
Regards,
Itamar.
|
mbF
|
Hi Itamar,
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!
Best regards,
Josef
|
