Google Spanner

개요

Google Cloud Spanner는 강력한 일관성과 수평적 확장성을 전부 갖춘 최초이자 유일한 관계형 데이터베이스 서비스입니다.

Google Spanner 메트릭을 수집하면 다음을 할 수 있습니다.

  • Spanner 데이터베이스 성능을 가시화합니다.
  • Spanner 데이터베이스의 성능과 애플리케이션의 상관 관계를 파악합니다.

설정

메트릭 수집

설치

아직 설치하지 않았다면 먼저 Google 클라우드 플랫폼 통합을 설정합니다. 그 외 다른 설치가 필요하지 않습니다.

로그 수집

Google Cloud Spanner 로그는 Google Cloud Logging으로 수집하여 클라우드 Pub/Sub 토픽을 통해 데이터 플로우 작업으로 전송됩니다. 아직 설정하지 않았다면 Datadog 데이터 플로우 템플릿으로 로깅을 설정하세요.

해당 작업이 완료되면 Google Cloud Logging에서 Google Cloud Spanner 로그를 다음 Pub/Sub 주제로 내보냅니다.

  1. Google Cloud Logging 페이지로 이동해 Google Cloud Spanner 로그를 필터링하세요.

  2. Create Sink를 클릭하고 그에 따라 싱크 이름을 지정합니다.

  3. “Cloud Pub/Sub"를 대상으로 선택하고 해당 목적으로 생성된 Pub/Sub 주제를 선택합니다. 참고: Pub/Sub 주제는 다른 프로젝트에 있을 수 있습니다.

    Google Cloud Pub/Sub 로그를 Pub Sub로 내보내기

  4. Create를 클릭하고 확인 메시지가 나타날 때까지 기다립니다.

수집한 데이터

메트릭

gcp.spanner.api.received_bytes_count
(count)		Uncompressed request bytes received by Cloud Spanner.
Shown as byte
gcp.spanner.api.sent_bytes_count
(count)		Uncompressed response bytes sent by Cloud Spanner.
Shown as byte
gcp.spanner.api.api_request_count
(count)		Cloud Spanner API requests.
Shown as second
gcp.spanner.api.request_count
(rate)		Rate of Cloud Spanner API requests.
Shown as request
gcp.spanner.api.request_latencies.avg
(gauge)		Average server request latencies for a database.
Shown as second
gcp.spanner.api.request_latencies.samplecount
(gauge)		Sample count of server request latencies for a database.
Shown as second
gcp.spanner.api.request_latencies.sumsqdev
(gauge)		Sum of Squared Deviation of server request latencies for a database.
Shown as second
gcp.spanner.api.request_latencies_by_transaction_type
(count)		Distribution of server request latencies by transaction types.
Shown as second
gcp.spanner.instance.cpu.utilization
(gauge)		Utilization of provisioned CPU, between 0 and 1.
Shown as fraction
gcp.spanner.instance.cpu.smoothed_utilization
(gauge)		24-hour smoothed utilization of provisioned CPU between 0.0 and 1.0.
Shown as fraction
gcp.spanner.instance.cpu.utilization_by_operation_type
(gauge)		Percent utilization of provisioned CPU, by operation type between 0.0 and 1.0.
Shown as fraction
gcp.spanner.instance.cpu.utilization_by_priority
(gauge)		Percent utilization of provisioned CPU, by priority between 0.0 and 1.0.
Shown as fraction
gcp.spanner.instance.node_count
(gauge)		Total number of nodes.
Shown as node
gcp.spanner.instance.session_count
(gauge)		Number of sessions in use.
Shown as session
gcp.spanner.instance.storage.used_bytes
(gauge)		Storage used in bytes.
Shown as byte
gcp.spanner.instance.storage.limit_bytes
(gauge)		Storage limit for instance in bytes
Shown as byte
gcp.spanner.instance.storage.limit_bytes_per_processing_unit
(gauge)		Storage limit per processing unit in bytes.
Shown as byte
gcp.spanner.instance.storage.utilization
(gauge)		Storage used as a fraction of storage limit.
Shown as fraction
gcp.spanner.instance.backup.used_bytes
(gauge)		Backup storage used in bytes.
Shown as byte
gcp.spanner.instance.leader_percentage_by_region
(gauge)		Percentage of leaders by cloud region between 0.0 and 1.0.
Shown as fraction
gcp.spanner.instance.processing_units
(gauge)		Total number of processing units.
gcp.spanner.lock_stat.total.lock_wait_time
(count)		Total lock wait time for lock conflicts recorded for the entire database.
Shown as second
gcp.spanner.query_count
(count)		Count of queries by database name, status, query type, and used optimizer version.
Shown as query
gcp.spanner.query_stat.total.bytes_returned_count
(count)		Number of data bytes that the queries returned
Shown as byte
gcp.spanner.query_stat.total.cpu_time
(count)		Number of seconds of CPU time Cloud Spanner spent on operations to execute the queries.
Shown as second
gcp.spanner.query_stat.total.execution_count
(count)		Number of times Cloud Spanner saw queries during the interval.
Shown as query
gcp.spanner.query_stat.total.failed_execution_count
(count)		Number of times queries failed during the interval.
Shown as query
gcp.spanner.query_stat.total.query_latencies
(gauge)		Distribution of total length of time, in seconds, for query executions within the database.
Shown as second
gcp.spanner.query_stat.total.returned_rows_count
(count)		Number of rows that the queries returned.
Shown as row
gcp.spanner.query_stat.total.scanned_rows_count
(count)		Number of rows that the queries scanned excluding deleted values.
Shown as row
gcp.spanner.read_stat.total.bytes_returned_count
(count)		Total number of data bytes that the reads returned excluding transmission encoding overhead.
Shown as byte
gcp.spanner.read_stat.total.client_wait_time
(count)		Number of seconds spent waiting due to throttling.
Shown as second
gcp.spanner.read_stat.total.cpu_time
(count)		Number of seconds of CPU time Cloud Spanner spent execute the reads excluding prefetch CPU and other overhead.
Shown as second
gcp.spanner.read_stat.total.execution_count
(count)		Number of times Cloud Spanner executed the read shapesduring the interval.
gcp.spanner.read_stat.total.leader_refresh_delay
(count)		Number of seconds spent coordinating reads across instances in multi-regionconfigurations.
Shown as second
gcp.spanner.read_stat.total.locking_delays
(gauge)		Distribution of total time in seconds spent waiting due to locking.
Shown as second
gcp.spanner.read_stat.total.returned_rows_count
(count)		Number of rows that the read returned.
Shown as row
gcp.spanner.row_deletion_policy.deleted_rows_count
(count)		Count of rows deleted by the policy since the last sample.
Shown as row
gcp.spanner.row_deletion_policy.processed_watermark_age
(gauge)		Time between now and the read timestamp of the last successful execution.
Shown as second
gcp.spanner.row_deletion_policy.undeletable_rows
(count)		Number of rows in all tables in the database that can't be deleted.
Shown as row
gcp.spanner.transaction_stat.total.bytes_written_count
(count)		Number of bytes written by transactions.
Shown as byte
gcp.spanner.transaction_stat.total.commit_attempt_count
(count)		Number of commit attempts for transactions.
gcp.spanner.transaction_stat.total.commit_retry_count
(count)		Number of commit attempts that are retries from previously aborted transaction attempts.
gcp.spanner.transaction_stat.total.participants
(gauge)		Distribution of total number of participants in each commit attempt.
gcp.spanner.transaction_stat.total.transaction_latencies
(gauge)		Distribution of total seconds takenfrom the first operation of the transaction to commit or abort.
Shown as second

이벤트

Google Cloud Spanner 통합은 이벤트를 포함하지 않습니다.

서비스 점검

Google Cloud Spanner 통합은 서비스 점검을 포함하지 않습니다.

트러블슈팅

도움이 필요하신가요? Datadog 지원팀에 문의하세요.