You can run this command to compare the differences of online cluster parameter settings on different OBServer nodes. A difference report is generated if any differences exist. You can also upload an offline file for analysis. This command can help you troubleshoot issues caused by differences of cluster parameters on different OBServer nodes.
Syntax
obdiag analyze parameter diff [option]
The following table describes the options.
| Option | Required? | Data type | Default value | Description |
|---|---|---|---|---|
| --file | No | string | Empty | The file to be analyzed. In OceanBase Database of a version earlier than V4.2.2, this option is required and the archive file generated when the obdiag gather parameter command was executed earlier is used. |
| --store_dir | No | string | The current path where the command is executed | The local path where the results are stored. |
| -c | No | string | ~/.obdiag/config.yml |
The path of the configuration file. |
| --inner_config | No | string | Empty | The configurations of obdiag. |
| --config | No | string | Empty | The configurations of the cluster diagnosed by obdiag, in the format of --config key1=value1 --config key2=value2. |
Examples
Method 1: Use the command out-of-the-box without a configuration file
Note
For more information about the parameters used in the command in this section, see Configure obdiag.
obdiag analyze parameter diff \
--config db_host=xx.xx.xx.xx \
--config db_port=xxxx \
--config tenant_sys.user=root@sys \
--config tenant_sys.password=***
# Upload an offline file to compare the differences of cluster parameter settings on different OBServer nodes
obdiag analyze parameter diff --file=/home/admin/gather_parameters/obcluster_parameters_20240808202546.csv
Method 2: Use the command with a configuration file
Before you run the command, make sure that you have configured the logon information of the target nodes in the config.yml configuration file of obdiag. For more information, see Configure obdiag.
obdiag analyze parameter diff
# Upload an offline file to compare the differences of cluster parameter settings on different OBServer nodes
obdiag analyze parameter diff --file=/home/admin/gather_parameters/obcluster_parameters_20240808202546.csv