You are a developer for a company that has been given the responsibility to debug performance issues for an existing application. The application connects to a MySQL RDS Instance in AWS. There is suspicion that there are performance issues in the underlying queries. Which of the following can help diagnose these issues?

Answer options:

A.The Cloudtrail logs for the region.
B.Get the slow query logs for the RDS service.
C.Use the AWS Config service to diagnose the problem areas.
D.Use the AWS Inspector service to diagnose the problem areas.

Answer – B
The AWS RDS Service contains several logs, such as the ones given below.
Error log – contains diagnostic messages generated by the database engine, along with startup and shutdown times.
General query log – contains a record of all SQL statements received from clients and client connect and disconnect times.
Slow query log – contains a record of SQL statements that took longer to execute than a set amount of time and that examined more than a defined number of rows. Both thresholds are configurable.
Option A is incorrect because this is used to monitor API activity.
Option C is incorrect because this is used as a configuration service.
Option D is incorrect because this is used to inspect EC2 Instances for vulnerabilities.
For more information on monitoring Amazon RDS, please refer to the below URL-
https://aws.amazon.com/blogs/database/monitor-amazon-rds-for-mysql-and-mariadb-logs-with-amazon-cloudwatch/