Trino

Trino is a high-performance, distributed SQL query engine built for interactive analytics across diverse data sources. It enables querying across Hadoop, RDBMSs, object stores, and more, without needing data movement.

Prerequisites

Ensure Trino is configured to display metrics in the Pulse UI. For detailed steps, see:

• ODP Trino — for configuring Trino JMX metrics and placing Hook JARs on the cluster.
• Configure Trino in Pulse — for making Trino-specific configuration changes in Pulse.

Trino Monitoring with Pulse

Pulse provides deep visibility into Trino’s operations and performance through intuitive dashboards and detailed metrics:

• Query Health: Monitor query volume, states (running, finished, failed), and user activity
• System Usage: Track heap memory, CPU time and load, JVM thread count (Coordinator and Workers)
• Cluster Composition: View active Coordinators and Workers to understand cluster topology
• Performance Trends: Analyze query types, states, and latency through real-time and historical charts
• Node Stability: Identify resource pressure and health issues with logs and node-level metrics

Key Benefits

Some of the key benefits of using Pulse include:

• Faster Issue Detection: Identify slow or failed queries, overloaded workers, or system bottlenecks
• Optimized Performance: Monitor JVM resource usage and fine-tune based on usage trends
• Improved Stability: Stay ahead of failures with CPU, memory, and thread monitoring
• Better Capacity Planning: Use real-time data to understand workload patterns and scaling needs
• Smarter Troubleshooting: Access logs and metrics from one interface for quicker resolution

Trino Logs and Node Health

In the Pulse UI, navigate to the Logs and Nodes pages to monitor Trino operations and infrastructure:

• Logs Page: View detailed Trino logs (info, warning, error) to troubleshoot failures and track service behavior. For more details, see Logs.
• Nodes Page: View real-time metrics like CPU, memory, and disk usage, and application status for each node running Trino. For more details, see Nodes.

These pages provide operational insights to ensure performance, identify degradation, and maintain uptime.

Trino Alerts

Pulse continuously monitors the health of the Trino service and raises alerts when services become unavailable. Also, you can create custom alerts for the metrics you want to monitor closely with specific conditions. For more information, see Monitor Trino with Pulse Alerts.

Trino Metrics in Pulse UI

In the Pulse UI, select Trino from the left navigation panel. Key metrics and charts appear instantly. This gives you a complete view of service behavior.

Pulse shows Trino metrics through summary panels and charts covering key system and query details:

• Trino Dashboard: Displays system-level metrics for Trino Coordinators and Workers to monitor resource usage and performance.
• Trino Queries: Enables tracking, filtering, and analysis of real-time query activity across users and workloads.
• Trino Queries Details: Provides a detailed breakdown of each executed query, including timing, state, and resource usage.