You can query cluster parameters by using an SQL statement.
Query cluster parameters by using an SQL statement
Cluster parameters define cluster-level configurations. You can query a parameter to check whether it is a cluster-level or tenant-level parameter.
Execute the following statement to check the category of a parameter:
SHOW PARAMETERS [SHOW_PARAM_OPTS];
You can set [SHOW_PARAM_OPTS] to [LIKE 'pattern' | WHERE expr]. Column attributes specified in WHERE expr are the same as those returned by the SHOW PARAMETERS statement.
The following table describes the column attributes returned by the SHOW PARAMETERS statement.
Column name |
Description |
|---|---|
| zone | The zone where the parameter exists. |
| svr_ip | The IP address of the server. |
| svr_port | The port of the server. |
| name | The name of the parameter. |
| data_type | The data type of the parameter. Valid values: STRING, CAPACITY, and so on. |
| value | The value of the parameter. Note You can modify the parameter value for a specified zone or server. Therefore, the value of the parameter may vary with zones and servers. |
| info | The description of the parameter. |
| section | The category of the parameter. Valid values:
|
| scope | The application scope of the parameter. Valid values: Tenant and Cluster.
|
| source | The source of the current value. Valid values:
|
| edit_level | Defines the modification behavior of the parameter. Valid values:
|
As described in the table, a parameter whose scope value is CLUSTER is a cluster-level parameter.
Both the sys tenant and user tenants can query cluster-level parameters.
Example:
obclient> SHOW PARAMETERS LIKE 'stack_size';
obclient> SHOW PARAMETERS WHERE edit_level='static_effective' AND name='stack_size';
For more information about cluster-level parameters in OceanBase Database, see System parameters.