Huge MySQL overload + Graph Diagrams
Posted: Thu May 31, 2018 10:47 am
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!
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!