Help Center/ Distributed Database Middleware/ User Guide (Kuala Lumpur Region)/ Parameter Template Management/ Editing a Parameter Template
Updated on 2022-08-17 GMT+08:00
View PDF
Share

Editing a Parameter Template

You can modify parameters in custom parameter templates to improve DDM performance.

You can change parameter values in custom parameter templates only and cannot change parameter values in default parameter templates.

The following are the key points you should know when using parameters from a parameter template:

  • When you change a parameter value in a parameter template and save the change, the change will take effect only after you apply the parameter template to a DDM instance and manually restart the instance. For details, see Applying a Parameter Template.
  • In conclusion, after you modify a parameter, the time when the modification takes effect is determined by the type of the parameter.

Parameters in default parameter templates cannot be modified. You can view these parameters by clicking template names. If a custom parameter template is set incorrectly and causes an instance restart to fail, you can re-configure the custom parameter template according to configurations of the default parameter template.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Distributed Database Middleware.
  4. Choose Parameter Templates, click the Custom Templates tab, locate the required parameter template, and click its name.
  5. On the Parameter Details page, modify parameters as needed.

    Available operations are as follows:

    • To save the modifications, click Save.
    • To cancel the modifications, click Cancel.

  6. After the parameter values are modified, you can click Template History to view details.

    The modifications take effect only after you apply the parameter template to DDM instances. For details, see Applying a Parameter Template.

    If you have modified certain parameters or collations, you need to manually restart the DDM instance for the modifications to take effect because the restart caused by instance class changes (if any) will not make these modifications take effect.