introlux
asked on
AWS RDS MySQL 100% CPU
Hi,
At the moment we are seeing 100% CPU Utilization on an RDS instance. I have logged onto the instance and run:
show full processlist;
However the list is far too long i cant view it all using putty. We really need to get to the bottom of this and figure out why this is happening. Any ideas?
At the moment we are seeing 100% CPU Utilization on an RDS instance. I have logged onto the instance and run:
show full processlist;
However the list is far too long i cant view it all using putty. We really need to get to the bottom of this and figure out why this is happening. Any ideas?
ASKER
Hi Stu,
The instance is: db.m3.xlarge
Currently showing 103 connections
Its a constant line with 100% CPU
We have restarted it and still no joy. Any ideas?
The instance is: db.m3.xlarge
Currently showing 103 connections
Its a constant line with 100% CPU
We have restarted it and still no joy. Any ideas?
Hi,
If you just restarted rather than stopped it then the instance would restart on the same piece of hardware. I would suggest stopping it and starting it again as the instance would likely spin up on different hardware in case you are experiencing physical host hardware issues.
Also, do you have any Status failures or error messages. See here
If you just restarted rather than stopped it then the instance would restart on the same piece of hardware. I would suggest stopping it and starting it again as the instance would likely spin up on different hardware in case you are experiencing physical host hardware issues.
Also, do you have any Status failures or error messages. See here
ASKER
By doing this will it lose its IP, name etc? anything that is linked to it?
ASKER
Status: Available
Maintenance: required
No option to stop other than reboot.
Maintenance: required
No option to stop other than reboot.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
seems to be a bot that caused the issue. All resolved now.
Thanks!
Thanks!
Does CloudWatch show this as a sudden increase or a steady CPU increase? Has the demands on your Database increased recently? What size instance are you using? It could be a hardware issue so you could stop your instance and restart it and it may restart on different hardware.
Cheers,
Stu...