trino-resource-group-governance

What problem does it solve?

This Skill solves uncontrolled Trino resource contention by defining workload governance for concurrent queries across users, sources, and query types.

Core Features & Use Cases

• Hierarchical resource groups: Build group trees (tiers) to enforce memory, concurrency, queue limits, and CPU quotas for each workload class (e.g., admin, pipeline, adhoc, batch, reporting).
• Selector-based routing and multi-tenant isolation: Assign queries to groups using selectors (user, source regex, queryType, clientTags, queryText regex) with a catch-all fallback to prevent routing failures.
• Scheduling policy control: Apply policies like fair, weighted, weighted_fair, or query_priority to match SLA tiers and prioritize critical workloads.
• Monitoring via JMX: Enable JMX export selectively and use JMX endpoints to inspect running/queued utilization and query-to-group assignment.

Quick Start

Use the trino-resource-group-governance skill to generate a resource-groups.json that routes admin, pipeline, adhoc, and batch workloads into separate hierarchical groups with per-group concurrency, memory, and CPU quota limits.