StarRocks Resource Management

Control how StarRocks consumes compute and storage: session limits, resource groups, and storage volumes.

When to Use

• Isolating workloads (ETL vs interactive dashboards)
• Capping per-query memory, CPU, or concurrency
• Controlling query parallelism or enabling disk spill
• Setting up remote/tiered storage with storage volumes

Related skills: [starrocks-cluster-setup] for the underlying node topology; [starrocks-query-optimization] for tuning parallelism on specific queries; [starrocks-monitoring] for observing resource usage.

Session-Level Resource Control

-- Set query timeout
SET query_timeout = 300;