This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Viewing individual database metrics

Posted on 09-17-2022 06:22 AM
Io
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

The product is cloudsql mysql with individual databases running on the cluster. 

How do we view load from each individual database on the cluster?

This seems like a trivial operation however I cannot find a way to view this data anywhere. I found the queryinsights for postgres but that is not available for mysql. 

I looked in log explorer. We have slow query logs turned on. This doesn't get us there. 

I looked in Monitoring. The only options are for the cluster as a whole not individual databases. 

 

 

0 1 166
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
comaro
Staff
Reply posted on --/--/---- --:-- AM

Currently Metric Explorer is the only tool for monitoring the instances.

Please note Cloud SQL is a managed service so it has some limitations. If you want to have full control over MySQL (ie. monitor performance of an individual database), the option is to use Google Compute Engine.

Also, for query history, you can enable a variety of extra logs like the slow query log, general log, binary log, and audit log.

0 Likes
Top Solution Authors
View all