Trino

Supported OS Mac OS Windows

통합 버전1.0.0

개요

이 점검은 다음 예시와 같은 Trino 메트릭을 수집합니다.

  • 전반적인 활동 메트릭: 완료/실패한 쿼리, 데이터 입력/출력 크기, 실행 시간.
  • 성능 메트릭: 클러스터 메모리, 입력 CPU, 실행 CPU 시간.

설정

설치

Agent v7.33.0+의 경우 아래 지침에 따라 호스트에 Trino 점검을 설치하세요. Docker Agent 또는 구버전의 Agent와 함께 설치하려면 커뮤니티 통합 사용을 참조하세요.

  1. 다음 명령어를 실행해 에이전트 통합을 설치하세요.

    datadog-agent integration install -t datadog-trino==<INTEGRATION_VERSION>

  2. 통합을 코어 통합과 유사하게 설정하세요.

구성

  1. 에이전트 구성 디렉터리의 루트에 있는 conf.d/ 폴더 내 trino.d/conf.yaml 파일을 편집하여 Trino 성능 데이터를 수집하기 시작하세요. 사용 가능한 모든 구성 옵션은 샘플 trino.d/conf.yaml을 참조하세요.

    이 점검은 인스턴스당 350개의 메트릭으로 제한됩니다. 반환되는 메트릭의 수는 Datadog Agent 상태 명령을 실행할 때 표시됩니다. 구성을 편집하여 관심 있는 메트릭을 지정할 수 있습니다. 수집할 메트릭을 사용자 지정하는 방법을 알아보려면 JMX 점검을 참조하세요. 더 많은 메트릭을 모니터링해야 하는 경우 Datadog 지원팀으로 문의하세요.

  2. 에이전트를 재시작합니다.

검증

Agent의 status 하위 명령을 실행하고 확인 섹션에서 Trino를 찾습니다.

수집한 데이터

메트릭

trino.execution.abandoned_queries.one_minute.count
(gauge)		Abandoned queries - one minute count.
Shown as query
trino.execution.abandoned_queries.one_minute.rate
(gauge)		Abandoned queries - one minute rate.
Shown as query
trino.execution.abandoned_queries.total_count
(gauge)		Abandoned queries - total count.
Shown as query
trino.execution.canceled_queries.one_minute.count
(gauge)		Canceled queries - one minute count.
Shown as query
trino.execution.canceled_queries.one_minute.rate
(gauge)		Canceled queries - one minute queries per second.
Shown as query
trino.execution.canceled_queries.total_count
(gauge)		Canceled queries - total count.
Shown as query
trino.execution.completed_queries.one_minute.count
(gauge)		Completed queries - one minute count.
Shown as query
trino.execution.completed_queries.one_minute.rate
(gauge)		Completed queries - one minute queries per second.
Shown as query
trino.execution.completed_queries.total_count
(gauge)		Completed queries - total count.
Shown as query
trino.execution.consumed_cpu_time_secs.one_minute.count
(gauge)		CPU (processing) time consumed - one minute count (seconds).
Shown as second
trino.execution.consumed_cpu_time_secs.one_minute.rate
(gauge)		CPU (processing) time consumed - one minute rate.
Shown as second
trino.execution.consumed_cpu_time_secs.total_count
(gauge)		CPU (processing) time consumed - total count (seconds).
Shown as second
trino.execution.cpu_input_byte_rate.all_time.avg
(gauge)		Distribution of query input data rates (cpu) - all time average bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.all_time.p75
(gauge)		Distribution of query input data rates (cpu) - all time bytes per second - p75.
Shown as byte
trino.execution.cpu_input_byte_rate.all_time.p95
(gauge)		Distribution of query input data rates (cpu) - all time bytes per second - p95.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.avg
(gauge)		Distribution of query input data rates (cpu) - one minute average bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.count
(gauge)		Distribution of query input data rates (cpu) - one minute count.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.max
(gauge)		Distribution of query input data rates (cpu) - one minute max bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.min
(gauge)		Distribution of query input data rates (cpu) - one minute min bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.p75
(gauge)		Distribution of query input data rates (cpu) - one minute bytes per second - p75.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.p95
(gauge)		Distribution of query input data rates (cpu) - one minute bytes per second - p95.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.total
(gauge)		Distribution of query input data rates (cpu) - one minute total bytes per second.
Shown as byte
trino.execution.execution_time.all_time.avg
(gauge)		Query execution time (millisecond) - all time average.
Shown as millisecond
trino.execution.execution_time.all_time.count
(gauge)		Query execution time (millisecond) - all time count.
Shown as millisecond
trino.execution.execution_time.all_time.max
(gauge)		Query execution time (millisecond) - all time max.
Shown as millisecond
trino.execution.execution_time.all_time.min
(gauge)		Query execution time (millisecond) - all time min.
Shown as millisecond
trino.execution.execution_time.all_time.p75
(gauge)		Query execution time (millisecond) - all time - p75.
Shown as millisecond
trino.execution.execution_time.all_time.p95
(gauge)		Query execution time (millisecond) - all time - p95.
Shown as millisecond
trino.execution.execution_time.one_minute.avg
(gauge)		Query execution time (millisecond) - one minute average.
Shown as millisecond
trino.execution.execution_time.one_minute.max
(gauge)		Query execution time (millisecond) - one minute max.
Shown as millisecond
trino.execution.execution_time.one_minute.min
(gauge)		Query execution time (millisecond) - one minute min.
Shown as millisecond
trino.execution.execution_time.one_minute.p75
(gauge)		Query execution time (millisecond) - one minute p75.
Shown as millisecond
trino.execution.execution_time.one_minute.p95
(gauge)		Query execution time (millisecond) - one minute p95.
Shown as millisecond
trino.execution.executor.blocked_splits
(gauge)		Blocked splits count.
Shown as split
trino.execution.executor.running_splits
(gauge)		Running splits count.
Shown as split
trino.execution.executor.total_splits
(gauge)		Total splits count.
Shown as split
trino.execution.executor.waiting_splits
(gauge)		Waiting splits count.
Shown as split
trino.execution.executor.processor_executor.queued_task_count
(gauge)		Queued task count.
Shown as task
trino.execution.external_failures.one_minute.count
(gauge)		Failed queries (external) - one minute count.
Shown as query
trino.execution.external_failures.one_minute.rate
(gauge)		Failed queries (external) - one minute failures per second.
Shown as query
trino.execution.external_failures.total_count
(gauge)		Failed queries (external) - total count.
Shown as query
trino.execution.failed_queries.one_minute.count
(gauge)		Failed queries - one minute count.
Shown as query
trino.execution.failed_queries.one_minute.rate
(gauge)		Failed queries - one minute queries per second.
Shown as query
trino.execution.failed_queries.total_count
(gauge)		Failed queries - total count.
Shown as query
trino.execution.internal_failures.one_minute.count
(gauge)		Failed queries (internal) - one minute count.
Shown as query
trino.execution.internal_failures.one_minute.rate
(gauge)		Failed queries (internal) - one minute queries per second.
Shown as query
trino.execution.internal_failures.total_count
(gauge)		Failed queries (internal) - total count.
Shown as query
trino.execution.insufficient_resources_failures.one_minute.count
(gauge)		Insufficient resources failures one minute count.
trino.execution.insufficient_resources_failures.one_minute.rate
(gauge)		Insufficient resources failures one minute failures per second.
trino.execution.insufficient_resources_failures.total_count
(gauge)		Insufficient resources failures total count.
trino.execution.running_queries
(gauge)		Active queries.
Shown as query
trino.execution.started_queries.one_minute.count
(gauge)		Queries started - one minute count.
Shown as query
trino.execution.started_queries.one_minute.rate
(gauge)		Queries started - one minute queries per second.
Shown as query
trino.execution.started_queries.total_count
(gauge)		Queries started - total count.
Shown as query
trino.execution.user_error_failures.one_minute.count
(gauge)		Failed queries (user error) - one minute count.
Shown as query
trino.execution.user_error_failures.one_minute.rate
(gauge)		Failed queries (user error) - one minute queries per second.
Shown as query
trino.execution.user_error_failures.total_count
(gauge)		Failed queries (user error) - total count.
Shown as query
trino.execution.wall_input_bytes_rate.one_minute.avg
(gauge)		Input data rate (bytes) - one minute average.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.max
(gauge)		Input data rate (bytes) - one minute max.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.min
(gauge)		Input data rate (bytes) - one minute min.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.p75
(gauge)		Input data rate (bytes) - one minute p75.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.p95
(gauge)		Input data rate (bytes) - one minute p95.
Shown as byte
trino.memory.assigned_queries
(gauge)		Memory (assigned queries).
Shown as byte
trino.memory.blocked_nodes
(gauge)		Memory (blocked nodes).
Shown as byte
trino.memory.free_distributed_bytes
(gauge)		Memory (free distributed bytes).
Shown as byte
trino.memory.nodes
(gauge)		Memory (nodes).
Shown as byte
trino.memory.reserved_distributed_bytes
(gauge)		Memory (reserved distributed bytes).
Shown as byte
trino.memory.reserved_revocable_distributed_bytes
(gauge)		Memory (reserved revocable distributed bytes).
Shown as byte
trino.memory.total_distributed_bytes
(gauge)		Memory (total distributed bytes).
Shown as byte

이벤트

Trino 통합에는 이벤트가 포함되지 않습니다.

서비스 점검

Trino 통합에는 서비스 점검이 포함되지 않습니다.

트러블슈팅

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