Home PageDatabase Autonomy ServiceUser GuideUser GuideInspection And ScoringPractices of parameter inspection and comparison
Search for Help Content

Practices of parameter inspection and comparison

Updated at: 2025-03-24 08:59
Product
Community

This topic describes how to use the parameter inspection and comparison feature of Database Autonomy Service (DAS) to check the parameter settings of a specific database instance.

Prerequisites

  • Your database instance runs one of the following database engines:

    • ApsaraDB RDS for MySQL

    • PolarDB for MySQL

  • Your database instance is connected to DAS and is in the Normal Access state. For more information, see Connect a database instance to DAS.

  • For more information, see Limits.

Procedure

Create an rule

  1. Log on to the DAS console.

  2. In the left-side navigation pane, choose Tools > Inspection and Scoring.

  3. On the page that appears, click the Parameter Inspection and Comparison tab.

  4. Click Settings. On the Rule Templates page, click Rule Management. In the panel that appears, click Create Rule. Specify the parameters and click OK.

    Note

    In this example, a parameter comparison rule is created for a MySQL instance and a specific parameter value (innodb_adaptive_hash_index=OFF) is configured for the rule.

    image

  5. After the rule is created, you can view the rule on the Rule Management page.

    image

Create a template

  1. On the Rule Templates page, click Create Template. Turn on the Status switch, associate the template with the innodb_adaptive_hash_index rule that you created, and then select the instance that you want to inspect. Click OK.

    image

  2. After the template is created, you can view the template on the Rule Templates page.

    image

Initiate a task

  1. On the Parameter Inspection and Comparison tab, select an engine type and click Initiate Task.

  2. In the panel that appears, select the type of task that you want to initiate.

    • In this example, a MySQL parameter comparison template is created. On the Parameter Comparison tab, click Select Template, select the template that you created, and then click Initiate Task.

      image

    • You can also select instances to compare the differences in parameter settings between the instances.

      image

View results

  1. On the Parameter Inspection and Comparison tab, you can view historical tasks. Find the desired task and click View Report in the Actions column to view the report details.

    image

  2. In this example, the report is generated for the MySQL parameter comparison task and contains the following information:

    • Basic Information: the basic information about the inspection task.

    • Task Template Details: the configurations of the rule and template.

    • Instance Parameter Comparison: the differences between the instance parameter values and the configured values.

      image

      Click Select Instance to select the instances whose parameter values you want to compare.

      image

      In the search box in the upper-right corner, you can search by parameter name. The parameters that are configured in the rule are displayed in the Compared Parameter column.

      image

References

Parameter inspection and comparison

Previous: Parameter inspection and comparisonNext: SQL Analysis
  • On this page （1）
  • Prerequisites
  • Procedure
  • Create an rule
  • Create a template
  • Initiate a task
  • View results
  • References
Feedback