GCP Cloud SQL metrics
Google Cloud SQL is a fully managed relational database service that provides secure, scalable, and reliable MySQL, PostgreSQL, and SQL Server databases on Google Cloud. Ensure your cloud platform is configured in SolarWinds Observability SaaS to collect this service's data. See Add a GCP cloud account.
Many of the collected metrics from Google Cloud SQL entities are displayed as widgets in SolarWinds Observability explorers; additional metrics may be collected and available in the Metrics Explorer. You can also create an alert for when an entity's metric value moves out of a specific range. See Entities in SolarWinds Observability SaaS for information about entity types in SolarWinds Observability SaaS.
The following table lists cloudsql.googleapis.com in the search box.
| Metric | Unit | Description |
|---|---|---|
sw.metrics.healthscore
|
Percent (%) |
Health state. The health state provides real-time insight into the overall health and performance of your monitored entities. The health state is determined based on anomalies detected for the entity, alerts triggered for the entity's metrics, and the status of the entity. The health state is displayed as one of the following four states and colors: Good, Moderate, Bad, or Unknown. You can determine the impact of the alerts, anomalies, and statuses on the health of an entity type by going to Settings > Health, and selecting a specific entity type. You can also customize the impact. To view the health of Google Cloud SQL entities in the Metrics Explorer, filter the |
gcp.cloudsql.googleapis.com.database.cpu.utilization
|
Percent (%) | Percentage of reserved CPU utilization currently in use. |
gcp.cloudsql.googleapis.com.database.disk.utilization
|
Count | Disk usage percentage |
gcp.cloudsql.googleapis.com.database.instance_state
|
|
The Cloud SQL metric measures the current serving state of an instance, with each possible state having a corresponding boolean value (true or false). |
gcp.cloudsql.googleapis.com.database.memory.utilization
|
Count | Fraction of used memory quota. |
gcp.cloudsql.googleapis.com.database.uptime
|
seconds (s) | The number of seconds that have elapsed since the Google Compute Engine instance began running. |
gcp.cloudsql.googleapis.com.database.cpu.usage_time
|
Second of CPU time | Total amount of CPU time used by a resource, accumulated over the specified interval. |
gcp.cloudsql.googleapis.com.database.disk.bytes_used
|
bytes | Total number of bytes used on the Cloud SQL instance's disks. |
gcp.cloudsql.googleapis.com.database.memory.usage
|
bytes | Server RAM usage (in bytes). |
gcp.cloudsql.googleapis.com.database.mysql.max_connections
|
Count | The value of the MySQL max_connections configuration. |
gcp.cloudsql.googleapis.com.database.replication.state
|
State of replication between primary and secondary Cloud SQL instances. | |
gcp.cloudsql.googleapis.com.database.active_directory.domain_reachable
|
A boolean value indicating if the managed instance in Google Cloud Platform can ping a domain controller within its Managed Active Directory domain. | |
gcp.cloudsql.googleapis.com.database.mysql.innodb.deadlocks_count
|
Count | Deadlocks occurrence count over a period of 2 minutes. |
gcp.cloudsql.googleapis.com.database.mysql.replication.seconds_behind_master
|
seconds (s) | The difference between the current timestamp and the most recent known write time of read replica data, approximated and sampled every 60 seconds. |
gcp.cloudsql.googleapis.com.database.mysql.slow_queries_count
|
Count | Total count of long-running queries (> long_query_time seconds). |
gcp.cloudsql.googleapis.com.database.postgresql.deadlock_count
|
Count | The number of detected deadlocks in a Google Cloud SQL database instance per sampling interval (60 seconds). |
gcp.cloudsql.googleapis.com.database.auto_failover_request_count
|
Count | The number of automatic failover requests initiated by Cloud SQL between primary and standby instances. |
gcp.cloudsql.googleapis.com.database.mysql.aborted_clients_count
|
Count | Number of aborted connections due to client disconnects. |
gcp.cloudsql.googleapis.com.database.mysql.aborted_connects_count
|
Count | Failed connection attempts to a MySQL server in 60-second interval. |
gcp.cloudsql.googleapis.com.database.replication.log_archive_failure_count
|
Count | Number of unsuccessful attempts to archive replication log files in a given time interval. |
gcp.cloudsql.googleapis.com.database.sqlserver.connections.connection_reset_count
|
Count | The total count of login events initiated from the SQL Server connection pool over a period of 60 seconds. |
gcp.cloudsql.googleapis.com.database.cpu.reserved_cores
|
Count | The number of reserved cores for a Google Cloud SQL database. |
gcp.cloudsql.googleapis.com.database.data_cache.quota
|
bytes | Maximum size (in bytes) of the Cloud SQL data cache at a given moment in time. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.active_transactions
|
Count | Number of active InnoDB transactions. |
gcp.cloudsql.googleapis.com.database.postgresql.transaction_count
|
Count | The difference in the number of transactions between consecutive 60-second periods. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.active_trx_longest_time
|
Count | The maximum duration of an active InnoDB transaction during a 60-second interval. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.active_trx_total_time
|
seconds (s) | Innodb active transaction duration (seconds) |
gcp.cloudsql.googleapis.com.database.mysql.innodb.buffer_pool_pages
|
Count | The number of InnoDB buffer pool pages in each state. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.buffer_pool_reads_count
|
Count | InnoDB buffer pool logical read misses per second. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.buffer_pool_write_requests_count
|
Count | The number of writes committed to the InnoDB buffer pool during a 60 second interval. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.dictionary_memory
|
bytes | Memory usage of InnoDB dictionary cache in bytes. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.operation_disk_io_count
|
Count | Disk I/O operations (InnoDB) per minute. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.os_log_fsyncs_count
|
Count | The number of InnoDB log write operations that have occurred since the last metric sample. |
gcp.cloudsql.googleapis.com.database.mysql.innodb.os_log_pending_fsyncs
|
Count | The number of pending fsync() operations for the InnoDB redo log files in a MySQL server. |
gcp.cloudsql.googleapis.com.database.mysql.innodb_buffer_pool_pages_dirty
|
Count | The number of unflushed (not yet written to disk) InnoDB buffer pool pages. |
gcp.cloudsql.googleapis.com.database.mysql.queries
|
Count | The number of SQL statements executed by a Cloud SQL MySQL instance within a given interval. |
gcp.cloudsql.googleapis.com.database.mysql.replication.slave_io_running
|
Indicates whether the I/O thread for reading the primary's binary log is active. Values: 'Yes', 'No', or 'Connecting'. | |
gcp.cloudsql.googleapis.com.database.mysql.replication.slave_sql_running
|
Indicates whether the SQL thread that is processing replication events is running on the replica. Values: 'Yes' or 'No'. | |
gcp.cloudsql.googleapis.com.database.sqlserver.databases
|
Count | Number of user-created databases on a Google Cloud SQL instance. |
gcp.cloudsql.googleapis.com.database.postgresql.backends_in_wait
|
Count | The number of PostgreSQL backend processes that are waiting to be served by the database instance. |
gcp.cloudsql.googleapis.com.database.postgresql.blocks_read_count
|
Count | Number of disk blocks read by the database. |
gcp.cloudsql.googleapis.com.database.postgresql.checkpoint_count
|
Count | The number of checkpoints that have been triggered in a given time interval. |
gcp.cloudsql.googleapis.com.database.postgresql.new_connection_count
|
Count | New connections count per minute for PostgreSQL instance. |
gcp.cloudsql.googleapis.com.database.postgresql.statements_executed_count
|
Count | The number of statements executed in a PostgreSQL instance during a 60-second interval. |
gcp.cloudsql.googleapis.com.database.postgresql.replication.replica_byte_lag
|
bytes | Replication lag in bytes: Amount of data that has been written to the master instance but not yet replicated to a specified replica in bytes. |
gcp.cloudsql.googleapis.com.database.postgresql.vacuum.oldest_transaction_age
|
Count | The age of the oldest unvacuumed transaction on a Google Cloud SQL PostgreSQL instance, expressed as the number of transactions since the oldest one. |
gcp.cloudsql.googleapis.com.database.postgresql.write_ahead_log.flushed_bytes_count
|
Count | Total byte size of write-ahead log (WAL) data flushed for a Cloud SQL instance. |
gcp.cloudsql.googleapis.com.database.postgresql.write_ahead_log.written_bytes_count
|
Count | The total number of bytes written to the write-ahead log (WAL) by an instance per second. |