:Modify the values of parameters for an instance

Usage notes

• If the Parameter is not supported for current version error message occurs when you modify the values of specific instance parameters, you must update the instance to the latest minor version. For more information, see Update the minor version of an instance.

• You cannot run commands to modify the values of specific instance parameters for Tair. For example, after you run the CONFIG SET TIMEOUT 60 command, the command does not take effect even if OK is returned. To modify the values of specific instance parameters, you must log on to the console or call the ModifyInstanceConfig operation.

Procedure

1. Log on to the Tair console and go to the Instances page. In the top navigation bar, select the region in which the instance that you want to manage resides. Then, find the instance and click the instance ID.

2. In the left-side navigation pane, click Parameter Settings.

3. Modify the values of one or more parameters.

   You can use one of the following methods to modify the values of specific instance parameters. For more information about the parameters, see Parameters that can be configured for Tair.

   Warning

   After you submit a modification to a specific parameter, the instance restarts. During the restart, the instance may encounter transient connections within seconds. Proceed with caution. Before you modify the value of a parameter, check the Restart and Take Effect column of the parameter to ensure that an instance restart is not required for the modification to take effect.

   • Modify the value of a single parameter for the instance.

     1. On the System Parameters page, find the parameter that you want to modify and click Modify in the Actions column.

     2. Click OK.

   • Modify the values of multiple parameters for the instance.

     1. Click Batch Modify.

     2. Find the parameters for which you want to modify the values and modify the values in the Running Value column.

     3. Click Modify.

   • Import parameters from a file for modification.

     To apply the parameter configurations of another instance to the current instance, you can use this method. Before you apply the parameter configurations to the current instance, go to the System Parameters page of the source Tair instance and click the icon in the upper-right corner to download the parameter configuration file.

     Note

     These two instances must use the same engine version and instance architecture. Otherwise, specific parameter modifications cannot take effect. For example, the query_cache_enabled parameter is supported only for DRAM-based instances.

     1. Click Import from File.

     2. In the Batch Import panel, click the icon to upload the downloaded file.

     3. In the Parameter Details section, select the parameters for which you want to modify the values.

        Note

        You can turn on Display Only Changed Parameters to filter parameters that are set to values different from Running Value.

     4. Click Modify.

Related operations