查询 TiDB 变量和参数
接口URL
/api/v1/cluster/tidbs/{clusterID}/parameters
请求方式
GET
Content-Type
json
认证方式
noauth
成功响应示例
{
"Data": {
"Configs": [
{
"InstanceType": "pd",
"Instance": "",
"Name": "DisableStrictReconfigCheck",
"CurrentValue": "false",
"Type": 2,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.batch_cop_pool_size",
"CurrentValue": "0",
"Type": 0,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.priority",
"CurrentValue": "0",
"Type": 0,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.dt_storage_pool_meta_gc_min_file_num",
"CurrentValue": "10",
"Type": 0,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.auto_memory_revoke_trigger_threshold",
"CurrentValue": "0.0",
"Type": 3,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.remote_read_queue_size",
"CurrentValue": "0",
"Type": 0,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "flash.proxy.config",
"CurrentValue": "",
"Type": 1,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "logger.level",
"CurrentValue": "debug",
"Type": 1,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.min_compress_block_size",
"CurrentValue": "DEFAULT_MIN_COMPRESS_BLOCK_SIZE",
"Type": 0,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.max_ast_elements",
"CurrentValue": "50000",
"Type": 0,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "profiles.default.dt_segment_stable_pack_rows",
"CurrentValue": "DEFAULT_MERGE_BLOCK_SIZE",
"Type": 0,
"Popular": false
},
{
"InstanceType": "tiflash",
"Instance": "",
"Name": "storage.io_rate_limit.foreground_write_weight",
"CurrentValue": "25",
"Type": 0,
"Popular": false
}
],
"Variables": [
{
"Name": "lower_case_table_names",
"Scope": "NONE",
"CurrentValue": "2",
"DefaultValue": "2",
"Type": 0,
"Range": "",
"Popular": false
},
{
"Name": "secure_auth",
"Scope": "GLOBAL",
"CurrentValue": "ON",
"DefaultValue": "ON",
"Type": 1,
"Range": "",
"Popular": false
},
{
"Name": "tidb_stats_load_sync_wait",
"Scope": "SESSION,GLOBAL",
"CurrentValue": "100",
"DefaultValue": "100",
"Type": 0,
"Range": "[0-2147483647]",
"Popular": true
},
{
"Name": "tidb_mem_oom_action",
"Scope": "GLOBAL",
"CurrentValue": "CANCEL",
"DefaultValue": "CANCEL",
"Type": 1,
"Range": "[CANCEL,LOG]",
"Popular": false
},
{
"Name": "tidb_stmt_summary_internal_query",
"Scope": "GLOBAL",
"CurrentValue": "OFF",
"DefaultValue": "OFF",
"Type": 1,
"Range": "",
"Popular": false
},
{
"Name": "ndb_recv_thread_cpu_mask",
"Scope": "NONE",
"CurrentValue": "",
"DefaultValue": "",
"Type": 1,
"Range": "",
"Popular": false
},
{
"Name": "innodb_log_file_size",
"Scope": "NONE",
"CurrentValue": "50331648",
"DefaultValue": "50331648",
"Type": 0,
"Range": "",
"Popular": false
},
{
"Name": "session_track_state_change",
"Scope": "SESSION,GLOBAL",
"CurrentValue": "",
"DefaultValue": "",
"Type": 1,
"Range": "",
"Popular": false
}
]
},
"Success": true
}
| 参数名 | 示例值 | 参数类型 | 参数描述 |
|---|---|---|---|
| Data | - | Object | - |
| Data.Configs | - | Array | 配置信息 |
| Data.Configs.InstanceType | pd | String | 实例类型，[TiDB, TiKV, PD, TiFlash] |
| Data.Configs.Instance | - | String | - |
| Data.Configs.Name | DisableStrictReconfigCheck | String | 配置名称 |
| Data.Configs.CurrentValue | false | String | 配置当前值 |
| Data.Configs.Type | 2 | Integer | 配置参数类型，[0: int, 1: string, 2: bool, 3: float, 4: array] |
| Data.Configs.Popular | false | Boolean | 是否为常用配置 |
| Data.Variables | - | Array | 变量信息 |
| Data.Variables.Name | innodb_file_format | String | 变量名称 |
| Data.Variables.Scope | GLOBAL | String | 变量范围 |
| Data.Variables.CurrentValue | Barracuda | String | 变量当前值 |
| Data.Variables.DefaultValue | Barracuda | String | 变量默认值 |
| Data.Variables.Type | 1 | Integer | 变量参数类型，[0: int, 1: string, 2: bool, 3: float, 4: array] |
| Data.Variables.Range | [Antelope,Barracuda] | String | 变量范围 |
| Data.Variables.Popular | false | Boolean | 是否为常用变量 |
| Success | true | Boolean | 调用是否成功 |