Sometimes my server gets slow because the CPU goes into idle mode it seems.
Usually it only goes back to normal when I restart the server, but sometimes it goes back to normal by itself.
It appears that the source of the problem is MySQL.
The server remains slow even when only common requests are arriving. However, the problem usually appears after stress on the server.
Is there any configuration I can do in either Apache or MySQL to resolve this problem?
I tried to put some cache on the site and other things that would alleviate cpu usage to try to prevent this situation from occurring. However, every now and then it still happens.
Some infos: Mysql: 8.0.18 - MySQL Community Server - GPL Apache: Apache/2.4.41 (Unix) I run my server on Google Cloud using the LAMP stack provided by Bitnami