Good morning everyone, I write to you because I'm desperate and I can't find the solution: I have mysql CPU going over 200-400% causing me to slow down and almost crash the only website hosting the virtual machine. I have a virtual machine with 32 CPUs and 16Gb of Ram with two HDDs in SSD. Right now I have Ubuntu 18.04.6 LTS with Kernel 4.15.0-212-generic mysql version is 8.0.33 for linux on x86_64 ( MySQL Community Server - GPL)
Can you advise me on how to mitigate and bring the cpu back into limits? I tried different solutions but I'm starting to raise the white flag. Two days ago the situation was under control, the mysql version was 8.0.32 and everything works correctly, after the automatic update the server performance went crazy.