Trino¶

Collect Trino Metrics information.

Installation Configuration¶

Trino is an application written in the Java LANGUAGE, and its Metrics information can be obtained through the jmx method.

JMX Exporter is an open-source tool used to export JMX (Java Management Extensions) metrics from Java applications into Prometheus-formatted measurement data.

By using the JMX Exporter to obtain Trino Metrics information, and enabling DataKit’s prom collector to collect jmx Metrics information.

Download JMX Exporter¶

Download address https://github.com/prometheus/jmx_exporter/releases

Coordinator Node¶

coordinator is a type of Server in Trino, responsible for parsing statements, query planning, and managing workers.

• Write jmx_config.yaml

rules:
- pattern: ".*"

• Adjust the startup command

...
-javaagent:/opt/apache/trino/lib/jmx_prometheus_javaagent-0.19.0.jar=3900:/opt/apache/trino/etc/jmx_config.yaml \
-Dnode.environment=test \
-Dnode.id=trino-coordinator \
...

Here, 3900 is the port exposed externally. After starting, you can access Metrics information via http://localhost:3900.

DataKit Collector Configuration¶

Since Trino can directly expose metrics url through JMX Exporter, it can be collected directly via the prom collector.

Perform the following steps:

cd datakit/conf.d/prom
cp prom.conf.sample trino.conf

Adjust the content of trino.conf as follows:

  urls = ["http://localhost:3900"]

  source = "trino"

  [inputs.prom.tags]
    component="trino"
  interval = "10s"

Other configurations should be adjusted as needed

, Parameter adjustment description:

• urls: The prometheus Metrics address; fill in the Metrics url exposed by the corresponding component here.
• source: Alias for the collector; differentiation is recommended.
• interval: Collection interval

Restart DataKit¶

Restart DataKit

Metrics¶

Metrics Set Trino¶

Metrics Set Java¶