Google Cloud SQL Processor Monitoring

Question

I am working on setting up some monitoring on the Google Cloud SQL node and do not see how to do it. I was able to install a monitoring agent on my instances of Google Compute Engine to monitor CPU, network, etc. I was not able to figure out how to do this on an instance of Cloud SQL. I have access to these types of monitoring:

• Storage Usage (GB)
• The number of read / write operations
• Exit bytes
• Active Connections
• MySQL Queries
• MySQL Questions
• InnoDB Read / Write Pages (pages / sec)
• InnoDB data fsyncs data (operations / sec)
• InnoDB Log fsyncs protocol (operations / sec)

I'm sure these are great options, but for now all I want to pay attention to is that my node works in terms of CPU / RAM, as they seem to determine performance in the first place.

If something is missing or misunderstood what I'm trying to do, any advice will be appreciated.

Thanks!

Answer 1

You can view them all directly from the Overview tab of the Cloud SQL console:

Answer 2

I added this as a function request as question 110. https://code.google.com/p/googlecloudsql/issues/detail?id=110

Answer 3

Google has Stackdriver, which is designed to register and monitor Google’s cloud infrastructure and AWS. He can control every thing present on the GCP. You can create visualizations to monitor an instance of Cloud SQL in one panel. You just need ----> 1. Log in to stackdriver and go to any existing dashboard if you did not create it .----> 2. Add a diagram and select Cloud SQL in the resource name .----> 3 Select the CPU usage from the metric and save. You can also monitor the memory, I / O disk, the number of cases in Delta or servers. Opening hours and more.

if you want to track any other computing mechanisms of GCP, App-Engine, Kubernetese Engine, storage bucket, Bigtable or pub / sub, you just need to select the corresponding resource name from the list. I hope you got your answer.