Resolved MySQL has 100+ % CPU time for a couple of seconds

[Martin Weil]

Hi there,

recently my MySQL started to get slow. I run a root server (not a virtual one) with Plesk Onyx 17.8.11 #42 on Ubuntu 16.04 and two Websites. One is Typo3, the other WordPress.

Sometime within the last two weeks I've noticed that both Plesk and Typo3 began to be slow. Not all the time, but often.

"htop" showed that two instances of MySQL take 100% (or more) CPU time on two cores for up to 10 Seconds. At the same time HDD is "busy 100%".

Any suggestions what that might be? Any known issues for Plesk regarding this?

I hope my question is not totally misplaced in this forum.

Thanks
Martin

 

[Martin Weil]

It seems that a faulty HDD in my Raid-1 (Software Raid) was causing the delays.

Tip: Check your disks for bad blocks once in a while
Like so: "sudo badblocks -v /dev/sda1 > /tmp/badsectors_sda1.txt"