Trino

Supported OS

Versión de la integración1.0.0

Información general

Este check recopila métricas Trino, como las siguientes:

  • Métricas de actividad global: consultas completadas/fallidas, tamaño de la entrada/salida de datos, tiempo de ejecución.
  • Métricas de rendimiento: memoria de clúster, CPU de entrada, tiempo de ejecución de CPU.

Configuración

Instalación

Para el Agent v7.33.0 o posteriores, sigue las instrucciones a continuación para instalar el check Trino en tu host. Para instalarlo con el Agent Docker o versiones anteriores del Agent, consulta Uso de integraciones de la comunidad.

  1. Ejecuta el siguiente comando para instalar la integración del Agent:

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

  2. Configura tu integración como una integración de base.

Configuración

  1. Edita el archivo trino.d/conf.yaml, que se encuentra en la carpeta conf.d/ en la raíz del directorio de configuración del Agent para empezar a recopilar tus datos de rendimiento de Trino. Para conocer todas las opciones de configuración disponibles, consulta el trino.d/conf.yaml de ejemplo.

    Este check tiene un límite de 350 métricas por instancia. El número de métricas devueltas se indica al ejecutar el comando de estado del Datadog Agent. Puedes especificar las métricas que te interesan editando la configuración.. Para saber cómo personalizar la recopilación de métricas, consulta los checks JMX. Si necesitas monitorizar más métricas, ponte en contacto con el servicio de asistencia de Datadog.

  2. Reinicia el Agent.

Validación

Ejecuta el subcomando status del Agent y busca Trino en la sección Checks.

Datos recopilados

Métricas

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

Eventos

La integración Trino no incluye eventos.

Checks de servicio

La integración Trino no incluye checks de servicios.

Solucionar problemas

¿Necesitas ayuda? Ponte en contacto con el servicio de asistencia de Datadog.