AWS RDS server intermittent 100% cpu problem
$25-50 AUD / hora
I have an EC2/RDS setup for a website in AWS. The DB is MySQL, and the front end is managed via an old install of Symfony. It’s been running okay for many years but recently - for reasons I can’t determine - the RDS server gets to around 130 connections and the server starts running at 100% cpu. It can do this for days. Rebooting makes no difference. It will return to 100% cpu usage immediately upon rebooting.
This can happen at any time of day or night - it doesn’t appear to be the result of a cron job. When it happens it can last an hour, or up to three days. Sometimes it works fine for weeks or days, sometimes not. You can see in the attached chart that it ran fine for a week but for the past week has been running above 90%cpu almost constantly.
I recently had the instance moved to a bigger server, and it ran fine for three days before returning to familiar behaviour.
It’s a low-traffic site, and this is now on an [login to view URL] machine - it shouldn’t need more resources.
This job is to analyze all the various processes running on the RDS server when it’s running at >90% cpu to see what’s consuming the resources.
Enhanced monitoring is available.
Nº del proyecto: #23045324
Sobre el proyecto
8 freelancers están ofertando un promedio de $34 / hora por este trabajo
I have 12+ years experience as an IT Infrastructure Manager, I have Strong Experience in AWS, Azure, Windows Server, Linux, Network, Firewall, Office 365, Google Gsuite, Zoho mail, VoIP Tools Like Asterisk, 3CX, Sip fo Más
Hi after reading your request it looks like query related issues and i might be able to help you out, i am working with clients on AWS for past three years with multiple services and have a very good knowledge of mysql Más
Hi, I will short out your problems. First we check the code with code analysis tools, after we planned to setup auto scalling in AWS. Thanks.