PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #186
Your application uses a Cloud SQL for MySQL instance. Recently, you have noticed performance degradation during peak hours, leading to slow response times and frustrated users. You suspect that…
The correct answer is C. Enable and use Query Insights. Enabling Query Insights on your Cloud SQL for MySQL instance gives you detailed diagnostics on slow and high-impact SQL statements, including execution times, frequency, and wait statistics. You can then export or share these precise query profiles with your application team…
Question
Your application uses a Cloud SQL for MySQL instance. Recently, you have noticed performance degradation during peak hours, leading to slow response times and frustrated users. You suspect that inefficient queries might be contributing to these issues. You want to pinpoint and analyze these problematic queries and pass them to the application team for optimizations. What should you do-
Options
- AUse the underprovisioned instance recommender.
- BIncrease the Cloud SQL instance read_buffer_size flag.
- CEnable and use Query Insights.
- DCreate a Cloud Monitoring alert based on the database/mysql/queries metric.
How the community answered
(55 responses)- A5% (3)
- B15% (8)
- C76% (42)
- D4% (2)
Explanation
Enabling Query Insights on your Cloud SQL for MySQL instance gives you detailed diagnostics on slow and high-impact SQL statements, including execution times, frequency, and wait statistics. You can then export or share these precise query profiles with your application team for targeted optimization.
Topics
Community Discussion
No community discussion yet for this question.