Trino

Supported OS Mac OS Windows

통합 버전1.0.0

To find out if this integration is available in your organization, see your Datadog Integrations page or ask your organization administrator.

To initiate an exception request to enable this integration for your organization, email support@ddog-gov.com.

개요

이 점검은 다음 예시와 같은 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 지원팀에 문의하세요.