samedi 3 janvier 2015

RDS Migration - MySQL Queries have slowed down

We recently moved to Amazon Web Services from colo hosting. We have two EC2 servers and a RDS instance. Initally everything was running quite smoothly but recently queries that used to take seconds to run are now taking minutes.


We tried upgrading to a larger instance but that does not seemed to have helped. Also, Ive reached the limit of my knowledge and we are stil in the process of trying to find a new DBA after the last one left.


Our RDS is a m3.xlarge and we are using SSD storage. Below is a screenshot of max Read and Write ops as well as CPU usage


Any suggestions or guidance on paramaters that I should check or should change would be much appreciated.


enter image description here


enter image description here





Aucun commentaire:

Enregistrer un commentaire