Configure Static Parameters

Under certain circumstances, you may need to configure Coordinator Node or Compute Node static parameters to achieve better query or loading performance or satisfy certain requirements. Unlike dynamic parameters, which can be configured and adjusted by running SQL commands and take effect with no downtime, modifications to static parameters can take effect only after the cluster or warehouse is restarted. To facilitate this process, CelerData allows cluster administrators to configure static parameters from the CelerData Cloud BYOC console.

Besides, dynamic parameters will become invalid if you restart the cluster or warehouse. Therefore, we recommend that you also modify dynamic parameters in the CelerData Cloud BYOC console to prevent the loss of modifications.

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 Coordinator Nodes

Follow these steps to configure Coordinator Node parameters in the CelerData Cloud BYOC console:

1. Sign in to the CelerData Cloud BYOC console.
2. On the Clusters page, click the cluster that you want to configure.
3. On the cluster details page, click the Cluster parameters tab.
4. In the Coordinator 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 parameter you want to configure in the Parameter key field, and the parameter value you want to set in the Value field.
   note

   CelerData provides validation checks on parameter keys and value types. Only valid parameter keys and values can be applied. 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 Coordinator Node static configuration section to restart the cluster instantly.

Configure static parameters for Compute Nodes in a warehouse

Follow these steps to configure Compute Node parameters of a warehouse in the CelerData Cloud BYOC console:

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 parameter you want to configure in the Parameter key field, and the parameter value you want to set in the Value field.
   note

   CelerData provides validation checks on parameter keys and value types. Only valid parameter keys and values can be applied. 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 warehouse whenever you find it suitable, or click Apply to all nodes in the Compute Node static configuration section to restart the warehouse instantly. For default_warehouse, you can only restart the cluster.

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.
• Modifications to infrastructure-related parameters (for example, ports and storage paths) are not allowed.