DescribeRDBParameters¶
获取指定 RDB 的配置信息。
Request Parameters
| Parameter name | Type | Description | Required |
|---|---|---|---|
| rdb | String | RDB ID | Yes |
| offset | Integer | 数据偏移量，默认为 0 | No |
| limit | Integer | 返回数据长度，默认为 20 | No |
| zone | String | 区域 ID，注意要小写 | Yes |
Response Elements
| Name | Type | Description |
|---|---|---|
| action | String | 响应动作 |
| parameter_set | Array | JSON 格式的配置数据列表，每项参数可见下面 ResponseItemType |
| total_count | Integer | 根据过滤条件得到的路由器总数 |
| ret_code | Integer | 执行成功与否，0 表示成功，其他值则为错误代码 |
ResponseItemType
| Name | Type | Description |
|---|---|---|
| is_static | Integer | 是否是静态配置项；1 表示静态配置项，修改后会重启 RDB；0 表示动态配置项，修改后不会重启 RDB |
| min_value | Integer | 最小值 |
| family | String | RDB 版本 |
| is_readonly | Integer | 该配置项是否为只读，1 表示只读配置项；0 表示非只读配置项 |
| var_value | String | 配置值 |
| max_value | Integer | 最大值 |
| opt_name | String | 用于配置文件中的配置项名称，空表示与 var_name 相同 |
| var_type | String | 配置项数据类型 |
| var_name | String | 配置项名称 |
| section_name | String | 配置项分组 |
Example
Example Request:
https://api.qingcloud.com/iaas/?action=DescribeRDBParameters
&rdbs.1=rdb-azjolu1b
&zone=pek1
&COMMON_PARAMS
Example Response:
{
"action":"DescribeRDBParametersResponse",
"total_count":56,
"parameter_set":[
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"32M",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"tmp_table_size",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"30",
"max_value":null,
"opt_name":"slave-net-timeout",
"var_type":"int",
"var_name":"slave_net_timeout",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"2",
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"innodb_log_files_in_group",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"0",
"max_value":null,
"opt_name":"",
"var_type":"bool",
"var_name":"log_queries_not_using_indexes",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"1000",
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"sync_relay_log",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"1",
"max_value":null,
"opt_name":"",
"var_type":"bool",
"var_name":"skip-slave-start",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":60,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"3600",
"max_value":2147483,
"opt_name":"",
"var_type":"int",
"var_name":"interactive_timeout",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"32M",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"max_heap_table_size",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":1,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"8",
"max_value":64,
"opt_name":"",
"var_type":"int",
"var_name":"innodb_write_io_threads",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"1",
"max_value":null,
"opt_name":"skip-name-resolve",
"var_type":"bool",
"var_name":"skip_name_resolve",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"gb2312",
"max_value":null,
"opt_name":"character-set-server",
"var_type":"string",
"var_name":"character_set_server",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":3306,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"3306",
"max_value":65535,
"opt_name":"",
"var_type":"int",
"var_name":"port",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"/data/mysql",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"tmpdir",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":150,
"family":"mysql5.5",
"is_readonly":1,
"var_value":1024,
"max_value":2048,
"opt_name":"",
"var_type":"int",
"var_name":"max_connections",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":0,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"5",
"max_value":1024,
"opt_name":"",
"var_type":"int",
"var_name":"sync_binlog",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"ROW",
"max_value":null,
"opt_name":"binlog-format",
"var_type":"string",
"var_name":"binlog_format",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"1536M",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"innodb_buffer_pool_size",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"mysql-relay-bin.index",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"relay_log_index",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"O_DIRECT",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"innodb_flush_method",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"1000",
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"sync_master_info",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":0,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"0",
"max_value":2,
"opt_name":"",
"var_type":"int",
"var_name":"lower_case_table_names",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"16M",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"max_allowed_packet",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"FORCE",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"innodb",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"/data/mysql",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"datadir",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"/data/mysql/mysql-error.log",
"max_value":null,
"opt_name":"log-error",
"var_type":"string",
"var_name":"log_error",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"1",
"max_value":null,
"opt_name":"slow-query-log",
"var_type":"bool",
"var_name":"slow_query_log",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"32M",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"innodb_log_buffer_size",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"/data/mysql/mysql-slow.log",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"slow_query_log_file",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":0,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"75",
"max_value":99,
"opt_name":"",
"var_type":"int",
"var_name":"innodb_max_dirty_pages_pct",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"1024",
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"table_open_cache",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"0",
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"query_cache_type",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"1",
"max_value":null,
"opt_name":"log-slave-updates",
"var_type":"bool",
"var_name":"log_slave_updates",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"/data/mysql/mysql-relay-bin",
"max_value":null,
"opt_name":"relay-log",
"var_type":"string",
"var_name":"relay_log",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":50,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"2048",
"max_value":4096,
"opt_name":"",
"var_type":"int",
"var_name":"back_log",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":1,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"512",
"max_value":1048576,
"opt_name":"",
"var_type":"int",
"var_name":"max_connect_errors",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"128M",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"innodb_log_file_size",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"1000",
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"sync_relay_log_info",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":1,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"4",
"max_value":4,
"opt_name":"",
"var_type":"int",
"var_name":"ft_min_word_len",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"idempotent",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"slave_exec_mode",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"0.0.0.0",
"max_value":null,
"opt_name":"bind-address",
"var_type":"string",
"var_name":"bind_address",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"mysql",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"user",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":0,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"128",
"max_value":256,
"opt_name":"",
"var_type":"int",
"var_name":"thread_cache_size",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":0,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"0",
"max_value":2,
"opt_name":"",
"var_type":"int",
"var_name":"innodb_flush_log_at_trx_commit",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"mysql-bin.index",
"max_value":null,
"opt_name":"",
"var_type":"string",
"var_name":"log-bin-index",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"0",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"query_cache_size",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"/data/mysql/mysql-bin",
"max_value":null,
"opt_name":"log-bin",
"var_type":"string",
"var_name":"log_bin",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"InnoDB",
"max_value":null,
"opt_name":"default-storage-engine",
"var_type":"string",
"var_name":"default_storage_engine",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":1,
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"innodb_buffer_pool_instances",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":0,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"14",
"max_value":99,
"opt_name":"",
"var_type":"int",
"var_name":"expire_logs_days",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":1,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"8",
"max_value":64,
"opt_name":"",
"var_type":"int",
"var_name":"innodb_read_io_threads",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":60,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"3600",
"max_value":2147483,
"opt_name":"",
"var_type":"int",
"var_name":"wait_timeout",
"section_name":"mysqld"
},
{
"is_static":1,
"min_value":1024,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"65535",
"max_value":65535,
"opt_name":"open-files-limit",
"var_type":"int",
"var_name":"open_files_limit",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":0,
"family":"mysql5.5",
"is_readonly":0,
"var_value":"3",
"max_value":10,
"opt_name":"",
"var_type":"int",
"var_name":"long_query_time",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"200",
"max_value":null,
"opt_name":"",
"var_type":"int",
"var_name":"innodb_io_capacity",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"1",
"max_value":null,
"opt_name":"",
"var_type":"bool",
"var_name":"innodb_file_per_table",
"section_name":"mysqld"
},
{
"is_static":0,
"min_value":null,
"family":"mysql5.5",
"is_readonly":1,
"var_value":"32M",
"max_value":null,
"opt_name":"",
"var_type":"mb",
"var_name":"key_buffer_size",
"section_name":"mysqld"
}
],
"ret_code":0
}