Configure static parameters for BE or CN

Under certain circumstances, you may need to configure the static parameters of the BE or CN nodes to fine-tune them to achieve better query or loading performance or satisfy certain requirements. Unlike dynamic parameters, which take effect with no downtime, modifications to static parameters can take effect only after the cluster (or warehouse in terms of an elastic cluster) is restarted. To facilitate this process, CelerData Cloud BYOC allows cluster administrators to configure static parameters from the CelerData Cloud BYOC console.

NOTE

• Only members with the Edit cluster privilege can perform this operation.
• You can configure static parameters for clusters that are in the Running or Suspended state.

Configure static parameters for BE nodes in a classic cluster

Follow these steps to configure static parameters for BE nodes in a classic cluster:

1. Sign in to the CelerData Cloud BYOC console.
2. On the Clusters page, click the classic cluster that you want to configure.
3. On the cluster details page, click the Cluster parameters tab.
4. In the BE Node static configuration section, click View all parameter list.
5. In the dialog box that appears, click New parameter.
6. Enter the name of the static parameter you want to configure in the Parameter key field, and the parameter value you want to set in the Value field. For the details of the parameters you can configure, see Usage notes.
7. Click the save button next to the Value field to save the record of the parameter change.
8. After configuring all the parameters you want to change, click Save changes to save the changes.
9. To allow the changes to take effect, you can either manually suspend and resume the cluster whenever you find suitable, or click Apply to all nodes in the BE Node static configuration section to restart the cluster instantly.

Configure static parameters for CN nodes in a warehouse of an elastic cluster

Follow these steps to configure static parameters for CN nodes in a warehouse of an elastic cluster:

1. Sign in to the CelerData Cloud BYOC console.
2. On the Clusters page, click the elastic cluster that you want to configure.
3. On the cluster details page, click the Warehouses tab.
4. On the Warehouses tab, click the warehouse that you want to configure.
5. On the warehouse details page, click the Warehouse parameters tab.
6. In the Compute node static configuration section, click View all parameter list.
7. In the dialog box that appears, click New parameter.
8. Enter the name of the static parameter you want to configure in the Parameter key field, and the parameter value you want to set in the Value field. For the details of the parameters you can configure, see Usage notes.
9. Click the save button next to the Value field to save the record of the parameter change.
10. After configuring all the parameters you want to change, click Save changes to save the changes.
11. To allow the changes to take effect, you can either manually suspend and resume the cluster whenever you find suitable, or click Apply to all nodes in the Compute node static configuration section to restart the cluster instantly.

Usage notes

• You can view all supported parameters from StarRocks BE configuration.
  • Parameters marked as Is mutable: No are static parameters.
  • The parameter value type is marked in the Type field of the description.
• Currently, CelerData does not support validation checks for the Parameter key and Value fields. You are responsible for the validation of the configuration and any risks and consequences that are caused by invalid configurations.
• Modifications to infrastructure-related parameters (for example, ports and storage paths) are not allowed.