帮助与文档

我们为你提供丰富、详尽的使用指南以及产品文档

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
}