Learn how to configure Trino worker pods to automatically shutdown during idle
periods, which allows you to optimize the resource utilization.
If your cluster is deployed on the OpenShift Container Platform and you
want to utilize auto-suspend capabilities, you must install Kubernetes Event-driven
Autoscaling (KEDA). KEDA enables dynamic scaling of containers, allowing them to
scale up or down based on demand.
Follow the instructions for "Creating a Virtual Warehouse".
Select a size for the Virtual Warehouse.
From the Trino Specific Settings panel, select the
Enable Auto Suspend checkbox to allow Trino worker
pods to automatically shut down during idle periods.
Specify the Auto-suspended Timeout period (in
seconds).
The auto-suspended timeout period specifies the idle period before scaling
down Trino worker nodes to zero when there are no running queries. By default,
this value is set to 300 seconds and the minimum value that you can specify is
60 seconds.
Specify the Grace Period for Shutting Down Worker.
The graceful shutdown period defines the duration (in seconds) that a Trino
worker waits during a graceful shutdown process. This allows the Trino workers
to complete existing tasks before the process fully terminates. By default, this
value is set to 300 seconds and the minimum value that you can specify is 60
seconds.
