Trino

Supported OS Linux Mac OS Windows

インテグレーションバージョン1.0.0

概要

このチェックでは、以下の例のような Trino メトリクスを収集します。

  • 全体的なアクティビティメトリクス: 完了/失敗したクエリ、データ入力/出力サイズ、実行時間。
  • パフォーマンスメトリクス: クラスターメモリ、入力 CPU 時間、実行 CPU 時間。

セットアップ

インストール

Agent v7.33.0 以降の場合は、下記の手順に従い Trino チェックをホストにインストールします。Docker Agent または 上記バージョン以前の Agent でインストールする場合は、コミュニティインテグレーションの使用をご参照ください。

  1. 以下のコマンドを実行して、Agent インテグレーションをインストールします。

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

  2. コアのインテグレーションと同様にインテグレーションを構成します。

コンフィギュレーション

  1. Agent の構成ディレクトリのルートにある conf.d/ フォルダーの trino.d/conf.yaml ファイルを編集して、 Trino パフォーマンスデータの収集を開始します。 使用可能なすべての構成オプションの詳細については、サンプル trino.d/conf.yaml を参照してください。

    このチェックは、1 インスタンスあたり 350 メトリクスの制限があります。返されたメトリクスの数は、Datadog Agent の status コマンドを実行したときに表示されます。 構成を編集することで、関心があるメトリクスを指定できます。 収集するメトリクスをカスタマイズする方法については、JMX チェックを参照してください。 制限以上のメトリクスを監視する必要がある場合は、Datadog のサポートチームまでお問い合わせください。

  2. Agent を再起動します。

検証

Agent の status サブコマンドを実行し、Checks セクションで 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 のサポートチームまでお問合せください。