Page 1 of 1

Huge MySQL overload + Graph Diagrams

Posted: Thu May 31, 2018 10:47 am
by pepe024
Hi guys,

I have a DigitalOcean droplet:

2 GB Memory / 50 GB Disk + 50 GB / LON1 - Ubuntu 16.04.3 x64

I installed VestaCP on it, and it worked fine since 2018. February, until last Friday.

On that day the MySQL sever started to overload continuously. I tried almost everything to find the problem source, but I can't find anything yet.

I have 6 WordPress websites on it and 3 another websites, which are external article management system. This system uses a few Cron jobs, to move data to the WordPress websites.

My WordPress websites are protected by CloudFlare. If I turn on the DDoS protection it solve the problem temporary.

You can see, that there are 14.39 Million!! querys at the MAX. At that time the website are unreachable:

Despite of this, the Apache and the Bandwidth are on normal level:

How can I detect the problem? Can I detect the MySQL overload from any log?

Please help me!