Link to home
Start Free TrialLog in
Avatar of Nathan Riley
Nathan RileyFlag for United States of America

asked on

AWS EC2 & RDS Instance

I'm very new to AWS.  We have the following setup:

1. RDS m4.xlarge
2. EC2 m4.2xlarge

It's sitting behind a classic load balancer for our HTTPS.   It's running centos 7, php 7, https, and mysql.

We're having extremely slow page load times.  I can't figure out where the issue is though.  Both the RDS and EC2 instance show less than 10% utilization on the CPU and about 1-2 gigs of memory used at any given time.  I'm at a loss.  What's the best way to look for the issue here?

Thanks
Avatar of Phil Phillips
Phil Phillips
Flag of United States of America image

What storage type do you have on the RDS database, and how much do you have allocated?  You could be running into an IOPS issue.  I would check both the IOPS graphs and the "disk queue" graphs for the RDS database.  Paste what those look like into here as well. You can find these if you select the RDS instance in the AWS console, then hit the "Show Monitoring" button.

Apart from that, you might want to try something like NewRelic to give you more insight into the bottlenecks: https://docs.newrelic.com/docs/agents/php-agent/getting-started/new-relic-php
Avatar of Nathan Riley

ASKER

Sure here you go.

Instance ClassContains the compute and memory capacity of the DB Instance      db.m4.xlarge
Storage TypeStorage type currently in use with this DB Instance      General Purpose (SSD)
IOPSFixed number of I/O Operations Per Second (IOPS) supported by this DB Instance      disabled
StorageAmount of storage to be initially allocated for the database instance, in gigabytes      500 GB
Untitled-1.png
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Here are the last 12 hours from the EC2.

Installign blackfire now.
Untitled-2.png