A DevOps engineer is troubleshooting a performance issue with an Amazon RDS for MySQL database. The engineer suspects that slow queries are causing high CPU utilization. Which TWO actions can the engineer take to identify the slow queries?
Trap 1: Create an RDS event subscription for 'low storage' events.
Event subscriptions notify about database events like storage, not slow queries.
Trap 2: Monitor the 'CPUUtilization' metric in CloudWatch.
CPUUtilization shows overall CPU usage but does not identify individual slow queries.
Trap 3: Enable Enhanced Monitoring to view process list and SQL queries.
Enhanced Monitoring provides OS-level metrics like CPU and memory, but not query details.
- A
Create an RDS event subscription for 'low storage' events.
Why wrong: Event subscriptions notify about database events like storage, not slow queries.
- B
Monitor the 'CPUUtilization' metric in CloudWatch.
Why wrong: CPUUtilization shows overall CPU usage but does not identify individual slow queries.
- C
Enable the slow query log and publish it to CloudWatch Logs.
Slow query logs capture queries that exceed a specified time threshold, and sending them to CloudWatch Logs enables querying and analysis.
- D
Enable Performance Insights to visualize database load and identify top SQL statements.
Performance Insights provides a database load chart and details on top queries by load.
- E
Enable Enhanced Monitoring to view process list and SQL queries.
Why wrong: Enhanced Monitoring provides OS-level metrics like CPU and memory, but not query details.