Answer-first summary for fast verification
Answer: Use Logs Explorer to analyze log data., Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
To identify the root cause of performance degradation in a MySQL workload running in Cloud SQL, the most effective approach involves analyzing both log data and system metrics. Option A, using Logs Explorer, allows you to delve into the log data which can reveal errors or slow queries affecting performance. Option B, using Cloud Monitoring, is crucial for monitoring CPU, memory, and storage utilization metrics, as these are common indicators of performance issues. While Option C, Error Reporting, is useful for aggregating and analyzing errors, it may not directly pinpoint performance degradation causes. Option D, Cloud Debugger, is more suited for inspecting the state of an application in real-time rather than diagnosing database performance issues. Therefore, the correct actions to take are A and B.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you determine the underlying cause of performance issues in a Cloud SQL MySQL database that your organization is using?
A
Use Logs Explorer to analyze log data.
B
Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
C
Use Error Reporting to count, analyze, and aggregate the data.
D
Use Cloud Debugger to inspect the state of an application.
No comments yet.