My site seems to be loading slower since the recent update.
From ym host:
I checked the server status, and I am afraid that I was able to see that server was rebooted 2 days ago Jul 20. reason CPU usage spikes.
I found that MySQL service is using most of the resources 184% CPUs, and that was the reason for the server restart on Jul 20. the database is showing a high resource usage.
How to monitor resource usage
https://www.a2hosting.com/kb/developer-corner/linux/monitoring-resource-usage&source=gmail&ust=1627042287404000&usg=AFQjCNG7JOv5AIckoQKRX6emaiH3auw33 A"> https://www.a2hosting.com/kb/developer-corner/linux/monitoring-resource-usage
In this case, MySQL will need to be review by your developer to optimize it and reduce the amount of resource it is using.
The reason in MY case several times was crazy bots/scrapers or some attack. And i was getting warnings about my shared plan "was limited". Cloudlinux does that when you exceed your limits, you are "limited".
Maybe this is the cause then mate. I have all the tools i need to diagnose the issues for sure, just dont know enough about it all to do it. I know some of this stuff, but some of it also gets a bit complicated and i dont know where to start learning more lol
you ALWAYS had. This not a new problem from what i remember, it just became worst for some reason.
i moved to a more powerful server back in march, and have had no issues at all unitll friday last week mate. This is not something i have always had.
For example you could try this:
Ok, the 1.9.9 is released. Update it, delete all caches and wait. If the problem appears, put this hook code in your functions.php file of the current active WordPress theme:
This hook will switch some MySQL 8/MariaDB 10.3 specific SQLs to standard SQLs. We need to see whether your hosting can perform the SQLs built especially for the new versions of MySQL and MariaDB.
Important: it's not necessary to use this hook if the problem doesn't appear after the update.