Stop one bad query from taking the whole Trino cluster down

A single unconstrained join in Trino can exhaust worker heap and take down nodes that dozens of other queries depend on. AceMQ remediates the immediate instability and then puts the resource controls in place that keep one analyst's query from becoming everyone's outage.

Starburst Enterprise on Kubernetes or VMs, serving mixed ad-hoc and scheduled analytical workloads.

AceMQ starts from the JVM and query logs to identify the specific operators and queries responsible, then applies per-query and per-node memory limits so the offending query fails cleanly instead of killing the worker. Spill-to-disk is configured for the joins and sorts that legitimately exceed memory, and resource groups partition capacity so scheduled work is insulated from ad-hoc exploration.

• 1
  JVM heap, GC log, and query event analysis to attribute crashes to specific operators and query shapes
• 2
  query.max-memory, query.max-memory-per-node, and memory.heap-headroom tuning matched to real concurrency
• 3
  Spill-to-disk configuration with appropriate local storage for joins, aggregations, and sorts that legitimately exceed memory
• 4
  Resource group definitions separating scheduled pipelines, BI tools, and ad-hoc analyst queries with hard concurrency caps
• 5
  Join distribution and reordering review, including broadcast threshold correction where statistics are misleading the optimizer
• 6
  Coordinator sizing and worker node profile review, with graceful shutdown configured for autoscaling clusters