Technologies/Trino/trino.memory.cluster_memory_bytes
TrinoTrinoMetric

trino.memory.cluster_memory_bytes

Total cluster memory
Dimensions:None
Available on:DatadogDatadog (1)
Interface Metrics (1)
DatadogDatadog
Total cluster memory available for query processing
Dimensions:None
Sources
trino.memory.cluster_memory_bytesdocs.datadoghq.com

Technical Annotations (12)

Configuration Parameters (7)
exchange.deduplication-buffer-sizerecommended: >32MB or use exchange manager
Controls coordinator buffer for query stage output
exchange-manager.namerecommended: filesystem or hdfs
Enables external storage for spooled data
spill_enabledrecommended: true
Enables spilling intermediate results to disk when memory is exhausted
spiller-spill-pathrecommended: /tmp/trino-spill
Directory path for temporary spill files
query.max-memoryrecommended: 50GB
Maximum memory per query to prevent single query from consuming all cluster memory
aggregation_operator_unspill_memory_limitrecommended: 4GB
Memory threshold for aggregation operators before unspilling
query_max_memory_per_noderecommended: 8GB
Maximum memory per node for each query
Error Signatures (1)
Exchange manager must be configured for the failure recovery capabilities to be fully functionalexception
CLI Commands (1)
SELECT query_id, user, peak_memory_bytes / 1024 / 1024 AS peak_memory_mb FROM trino_events.trino_queries WHERE create_time >= now() - interval '7' day ORDER BY peak_memory_mb DESC LIMIT 10;diagnostic
Technical References (3)
trino_events.trino_queriescomponentpeak_memory_bytescomponentOOMconcept
Related Insights (6)
Query fails when result set exceeds buffer size without exchange managercritical
▸
High memory queries risk OOM and cluster instabilitycritical
▸
Insufficient resources cause query failurescritical
▸
Out-of-memory conditions kill running queriescritical
▸
Memory exhaustion causes query failures in complex analytical workloadswarning
▸
High memory usage causes out-of-memory failurescritical
▸