Google Cloud SQL monitoring

  • How-to guide
  • 4-min read
  • Published Jan 17, 2022

Dynatrace Google Cloud integration leverages data collected from the Google Operation API to constantly monitor health and performance of Google Cloud Services. While combining all relevant data into dashboards, it also enables alerting and event tracking.

Prerequisites

Set up integration

Add services and feature sets optional

After integration, Dynatrace automatically monitors a number of preset Google Cloud services and feature sets (metrics). Besides these, you can add more services or feature sets to monitoring. For details, see Add or remove services.

For a list of feature sets available for this service, see Metric table.

View metrics

After deploying the integration, you can see metrics from monitored services in the Metrics browser, Data Explorer, and your dashboard tiles.

Metric table

The following feature sets are available for Google Cloud SQL.

Feature set
Name
Unit
GCP metric identifier
cloudsql_database/default_metrics
Auto-failover Requests
Count
cloudsql.googleapis.com/database/auto_failover_request_count
cloudsql_database/default_metrics
Available for failover
Count
cloudsql.googleapis.com/database/available_for_failover
cloudsql_database/default_metrics
CPU reserved cores
Count
cloudsql.googleapis.com/database/cpu/reserved_cores
cloudsql_database/default_metrics
CPU usage
Second
cloudsql.googleapis.com/database/cpu/usage_time
cloudsql_database/default_metrics
CPU utilization
Percent
cloudsql.googleapis.com/database/cpu/utilization
cloudsql_database/default_metrics
Bytes used
Byte
cloudsql.googleapis.com/database/disk/bytes_used
cloudsql_database/default_metrics
Disk quota
Byte
cloudsql.googleapis.com/database/disk/quota
cloudsql_database/default_metrics
Disk read IO
Count
cloudsql.googleapis.com/database/disk/read_ops_count
cloudsql_database/default_metrics
Disk utilization
Count
cloudsql.googleapis.com/database/disk/utilization
cloudsql_database/default_metrics
Disk write IO
Count
cloudsql.googleapis.com/database/disk/write_ops_count
cloudsql_database/default_metrics
Instance state
Unspecified
cloudsql.googleapis.com/database/instance_state
cloudsql_database/default_metrics
Memory quota
Byte
cloudsql.googleapis.com/database/memory/quota
cloudsql_database/default_metrics
Total memory usage
Byte
cloudsql.googleapis.com/database/memory/total_usage
cloudsql_database/default_metrics
Memory usage
Byte
cloudsql.googleapis.com/database/memory/usage
cloudsql_database/default_metrics
Memory utilization
Count
cloudsql.googleapis.com/database/memory/utilization
cloudsql_database/default_metrics
InnoDB dirty pages
Count
cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_dirty
cloudsql_database/default_metrics
InnoDB free pages
Count
cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_free
cloudsql_database/default_metrics
InnoDB total pages
Count
cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_total
cloudsql_database/default_metrics
InnoDB fsync calls
Count
cloudsql.googleapis.com/database/mysql/innodb_data_fsyncs
cloudsql_database/default_metrics
InnoDB log fsync calls
Count
cloudsql.googleapis.com/database/mysql/innodb_os_log_fsyncs
cloudsql_database/default_metrics
InnoDB pages read
Count
cloudsql.googleapis.com/database/mysql/innodb_pages_read
cloudsql_database/default_metrics
InnoDB pages written
Count
cloudsql.googleapis.com/database/mysql/innodb_pages_written
cloudsql_database/default_metrics
Queries
Count
cloudsql.googleapis.com/database/mysql/queries
cloudsql_database/default_metrics
Questions
Count
cloudsql.googleapis.com/database/mysql/questions
cloudsql_database/default_metrics
Network bytes received by MySQL
Byte
cloudsql.googleapis.com/database/mysql/received_bytes_count
cloudsql_database/default_metrics
Available for failover (Deprecated)
Count
cloudsql.googleapis.com/database/mysql/replication/available_for_failover
cloudsql_database/default_metrics
Last I/O thread error number
Count
cloudsql.googleapis.com/database/mysql/replication/last_io_errno
cloudsql_database/default_metrics
Last SQL thread error number
Count
cloudsql.googleapis.com/database/mysql/replication/last_sql_errno
cloudsql_database/default_metrics
Replica lag
Second
cloudsql.googleapis.com/database/mysql/replication/seconds_behind_master
cloudsql_database/default_metrics
Slave I/O thread running state
Unspecified
cloudsql.googleapis.com/database/mysql/replication/slave_io_running_state
cloudsql_database/default_metrics
Slave SQL thread running state
Unspecified
cloudsql.googleapis.com/database/mysql/replication/slave_sql_running_state
cloudsql_database/default_metrics
Network bytes sent by MySQL
Byte
cloudsql.googleapis.com/database/mysql/sent_bytes_count
cloudsql_database/default_metrics
Cloud SQL Connections
Count
cloudsql.googleapis.com/database/network/connections
cloudsql_database/default_metrics
Received bytes
Byte
cloudsql.googleapis.com/database/network/received_bytes_count
cloudsql_database/default_metrics
Sent bytes
Byte
cloudsql.googleapis.com/database/network/sent_bytes_count
cloudsql_database/default_metrics
Execution time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/aggregate/execution_time
cloudsql_database/default_metrics
IO time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/aggregate/io_time
cloudsql_database/default_metrics
Latency
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/aggregate/latencies
cloudsql_database/default_metrics
Aggregated lock time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/aggregate/lock_time
cloudsql_database/default_metrics
Affected rows
Count
cloudsql.googleapis.com/database/postgresql/insights/aggregate/row_count
cloudsql_database/default_metrics
Shared blocks cache access
Count
cloudsql.googleapis.com/database/postgresql/insights/aggregate/shared_blk_access_count
cloudsql_database/default_metrics
Per query execution times
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/perquery/execution_time
cloudsql_database/default_metrics
Per query IO time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/perquery/io_time
cloudsql_database/default_metrics
Per query latency
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/perquery/latencies
cloudsql_database/default_metrics
Per query lock time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/perquery/lock_time
cloudsql_database/default_metrics
Per query affected rows
Count
cloudsql.googleapis.com/database/postgresql/insights/perquery/row_count
cloudsql_database/default_metrics
Per query Shared blocks cache access
Count
cloudsql.googleapis.com/database/postgresql/insights/perquery/shared_blk_access_count
cloudsql_database/default_metrics
Per tag execution time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/pertag/execution_time
cloudsql_database/default_metrics
Per tag IO time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/pertag/io_time
cloudsql_database/default_metrics
Per tag latency
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/pertag/latencies
cloudsql_database/default_metrics
Per tag lock time
MicroSecond
cloudsql.googleapis.com/database/postgresql/insights/pertag/lock_time
cloudsql_database/default_metrics
Per tag affected rows
Count
cloudsql.googleapis.com/database/postgresql/insights/pertag/row_count
cloudsql_database/default_metrics
Per tag shared blocks cache accessed
Count
cloudsql.googleapis.com/database/postgresql/insights/pertag/shared_blk_access_count
cloudsql_database/default_metrics
PostgreSQL Connections
Count
cloudsql.googleapis.com/database/postgresql/num_backends
cloudsql_database/default_metrics
Lag bytes
Byte
cloudsql.googleapis.com/database/postgresql/replication/replica_byte_lag
cloudsql_database/default_metrics
Number of transactions
Count
cloudsql.googleapis.com/database/postgresql/transaction_count
cloudsql_database/default_metrics
Replica lag
Second
cloudsql.googleapis.com/database/replication/replica_lag
cloudsql_database/default_metrics
Server up
Count
cloudsql.googleapis.com/database/up
cloudsql_database/default_metrics
Uptime
Second
cloudsql.googleapis.com/database/uptime
Related tags
Infrastructure Observability