Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
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.
Performance degradation in a Cloud SQL MySQL instance is often tied to resource utilization. Cloud Monitoring provides real-time insights into CPU, memory, and storage usage, which are critical factors that affect database performance. Analyzing these metrics helps identify issues such as:
High CPU usage due to inefficient queries or excessive connections.
Low available memory causing performance bottlenecks.
Storage nearing capacity or IOPS limitations impacting performance.
B.
No actual errors are mentioned so using Error reporting would be irrelevant. That eliminates C. Inspecting the state of an application is also irrelevant since so mention of any application changes is made. Eliminate D. That leave A and B and B is the best answer. In Cloud SQL you get monitoring built right in (which you don't by default with GCE VMs). Cloud SQL monitoring metrics include CPU utilization, storage usage, memory usage, r/w operations and egress/ingress bytes. Has to be B.
If your instance stops responding to connections or performance is degraded, make sure it conforms to the Operational Guidelines
https://cloud.google.com/sql/docs/mysql/diagnose-issues#:~:text=If%20your%20instance%20stops%20responding%20to%20connections%20or%20performance%20is%20degraded%2C%20make%20sure%20it%20conforms%20to%20the%20Operational%20Guidelines
And then checking resource constraints:
Storage full
CPU overloaded
Too many database tables
https://cloud.google.com/sql/docs/mysql/operational-guidelines#resource_constraints
Cloud Monitoring seems like the only way to check 2/3 of those, so for me answer is B
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Zakky_09
4 months agodynamic_dba
7 months, 2 weeks agopk349
10 months, 1 week agoGCP72
10 months, 1 week agochelbsik
10 months, 1 week agoH_S
10 months, 1 week agojitu028
10 months, 1 week ago