Updated on 2023-11-21 GMT+08:00

Modifying a Parameter Template

You can modify parameters in a custom parameter template so that your instance can deliver spectacular performance.

Note that parameter values in default parameter templates cannot be changed.

Though parameter values in a default template cannot be changed, you can view details about a default parameter template. If a custom parameter template is set incorrectly, the database startup may fail. You can re-configure the custom parameter template according to the configurations of the default parameter template.

Modifying Parameters in a Custom Parameter Template

  1. Log in to the management console.
  2. In the service list, choose Databases > GeminiDB.
  3. In the navigation pane on the left, choose Parameter Templates.
  4. Click the Custom Templates tab, locate the parameter template whose parameters you want to modify, and click its name.
  5. Change parameter values as required.

    Figure 1 Modifying parameters in the parameter template
    • To save the modifications, click Save.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.
      Figure 2 Previewing changes

  6. After parameters are modified, click Change History to view parameter modification details.

    For details about how to view parameter modification details, see Viewing Parameter Change History.
    • The modifications take effect only after you apply the parameter template to instances. For details, see Applying a Parameter Template.
    • The change history page displays only the modifications of the last seven days.

Modifying Parameters of a Specified Instance

  1. Log in to the management console.
  2. In the service list, choose Databases > GeminiDB.
  3. In the navigation pane on the left, choose Instances. In the instance list, locate the instance whose parameters you want to modify and click its name.
  4. In the navigation pane on the left, choose Parameters. On the displayed page, modify parameters as required.

    Figure 3 Modifying parameters of the instance
    • To save the modifications, click Save.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.

  5. After parameters are modified, click Change History.

    For details about how to view parameter modification details, see Viewing Parameter Change History.

    After you modify instance parameters, the modifications immediately take effect for the instance.

    Check the value in the Effective upon Restart column.
    • If the value is Yes and the instance status on the Instances page is Pending restart, restart the instance for the modifications to take effect.
    • If the value is No, the modifications take effect immediately.