Trino

Supported OS Linux 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. 以下のコマンドを実行して、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 のサポートチームまでお問い合わせください。