Datadog-Google CloudSQL Integration

Overview

Google Cloud SQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your MySQL databases in the cloud.

Get metrics from Google CloudSQL to:

  • Visualize the performance of your CloudSQL databases
  • Correlate the performance of your CloudSQL databases with your applications

Setup

Installation

If you haven’t already, set up the Google Cloud Platform integration first. There are no other installation steps that need to be performed.

Data Collected

Metrics

gcp.cloudsql.database.disk.bytes_used
(gauge)
Disk space used.
shown as byte
gcp.cloudsql.database.disk.write_ops_count
(count)
Disk write IO operations.
shown as operation
gcp.cloudsql.database.mysql.innodb_data_fsyncs
(count)
InnoDB fsync calls.
shown as operation
gcp.cloudsql.database.mysql.innodb_os_log_fsyncs
(count)
InnoDB fsync calls to the log file.
shown as operation
gcp.cloudsql.database.mysql.innodb_pages_read
(count)
InnoDB pages read.
shown as page
gcp.cloudsql.database.mysql.innodb_pages_written
(count)
InnoDB pages written.
shown as page
gcp.cloudsql.database.mysql.queries
(count)
Number of query statements executed by the server.
shown as query
gcp.cloudsql.database.mysql.questions
(count)
Number of question statements executed by the server. Includes only statements sent to the server by clients and not statements executed within stored programs
shown as question
gcp.cloudsql.database.mysql.replication.available_for_failover
(gauge)
Failover operation is available on the master instance if greater than 0.
shown as
gcp.cloudsql.database.mysql.replication.seconds_behind_master
(gauge)
Approximate number of seconds the read replica is behind its' master.
shown as second
gcp.cloudsql.database.network.connections
(gauge)
Number of connections to the Cloud SQL instance.
shown as connection
gcp.cloudsql.database.network.sent_bytes_count
(count)
Number of bytes sent through the network.
shown as byte
gcp.cloudsql.database.up
(gauge)
Indicates if the server is up or not.
shown as
gcp.cloudsql.database.uptime
(gauge)
Number of seconds the instance has been running.
shown as second
gcp.cloudsql.database.state
(gauge)
The current serving state of the Cloud SQL instance
shown as
gcp.cloudsql.database.cpu.reserved_cores
(gauge)
Number of cores reserved for the database.
shown as core
gcp.cloudsql.database.cpu.usage_time
(gauge)
Cumulative CPU usage time
shown as second
gcp.cloudsql.database.cpu.utilization
(gauge)
Fraction of the reserved CPU that is currently in use.
shown as fraction
gcp.cloudsql.database.disk.quota
(gauge)
Maximum data disk size in bytes.
shown as byte
gcp.cloudsql.database.disk.read_ops_count
(count)
Disk read IO operations.
shown as operation
gcp.cloudsql.database.disk.utilization
(gauge)
The fraction of the disk quota that is currently in use.
shown as fraction
gcp.cloudsql.database.memory.quota
(gauge)
Maximum RAM in bytes
shown as byte
gcp.cloudsql.database.memory.usage
(gauge)
RAM usage in bytes
shown as byte
gcp.cloudsql.database.memory.utilization
(gauge)
Fraction of memory quota currently in use
shown as fraction
gcp.cloudsql.database.mysql.innodb_buffer_pool_pages_dirty
(gauge)
Number of unflushed pages in the InnoDB buffer pool.
shown as page
gcp.cloudsql.database.mysql.innodb_buffer_pool_pages_free
(gauge)
Number of unused pages in the InnoDB buffer pool.
shown as page
gcp.cloudsql.database.mysql.innodb_buffer_pool_pages_total
(gauge)
Total number of pages in the InnoDB buffer pool.
shown as page
gcp.cloudsql.database.mysql.replication.slave_io_running
(gauge)
Indicates whether the I/O thread for reading the master's binary log is running. Possible values are Yes, No and Connecting.
shown as
gcp.cloudsql.database.mysql.replication.slave_sql_running
(gauge)
Indicates whether the SQL thread for executing events in the relay log is running
shown as