Modifying Instance Parameters

Scenarios

You can change parameter values in a custom parameter template and apply it to optimize FlexusRDS database performance.

Modifying a Single Parameter

1. In the instance list, click the target instance name.
2. Click the Parameters tab.
3. In the parameter list, locate the parameter you want to modify and click Modify in the Operation column.
   

   After you modify a parameter, check the value in the Effective upon Reboot column.

   • If the value is Yes and the instance status in the instance list is Parameter change. Pending reboot, a reboot is required for the modifications to take effect.

     If you have modified parameters of a primary DB instance, you need to reboot the primary DB instance for the modifications to take effect. (For primary/standby DB instances, the parameter modifications are also applied to the standby DB instance.)

   • If the value is No, the modifications take effect immediately.
   Figure 1 Parameters
   
   • To save the modifications, click Confirm. In the displayed dialog box, click Yes.
   • To cancel the modifications, click Cancel.

   To view the change history, click Change History above the parameter list. The change history of the last seven days is displayed.

Modifying Parameters in Batches

1. In the instance list, click the target instance name.
2. Click the Parameters tab.
3. Switch on the batch modification switch . A maximum of 30 parameters can be modified at a time.
   

   After you modify a parameter, check the value in the Effective upon Reboot column.

   • If the value is Yes and the instance status in the instance list is Parameter change. Pending reboot, a reboot is required for the modifications to take effect.

     If you have modified parameters of a primary DB instance, you need to reboot the primary DB instance for the modifications to take effect. (For primary/standby DB instances, the parameter modifications are also applied to the standby DB instance.)

   • If the value is No, the modifications take effect immediately.
   Figure 2 Modifying parameters
   
   • To save your modifications, click Save. In the displayed dialog box, click Yes.
   • To cancel your modifications, click Cancel. In the displayed dialog box, click Yes.

   To view the change history, click Change History above the parameter list. The change history of the last seven days is displayed.