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.

  • Automatic update? is it cloud based?
    – Mannoj
    Jun 9 at 8:14
  • it's not on the cloud. I found myself this update which ran automatically
    – user274959
    Jun 9 at 8:17
  • Do you have datapoints or graph that can exactly correlate the upgrade time and perf degraded time at the same time? If yes, then something to do with upgrade, if not there are many faced to this problem (like any app changes, sudden traffic, config settings, etc.,).
    – Mannoj
    Jun 9 at 8:22
  • I answered below, I couldn't attach more than 15 characters to you
    – user274959
    Jun 9 at 8:42
  • Please edit your question to add more details. Jun 9 at 9:38


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.