查看数据库当前参数详情

DescribeDBInstanceParameters 查看数据库当前参数详情

查看指定实例的参数。
注意：参数组页面的参数组仅作为模板，可应用于实例。每个实例有对应的唯一参数组，即修改实例参数时，修改的是实例对应的参数组参数值。

请求方式

GET

请求参数

英文名称	中文名称	类型	是否必须	备注
Action	调用接口名称	String	是	取固定值：CreateDBParameterGroup
Version	API版本号	String	是	取固定值：2016-07-01
DBInstanceIdentifier	实例ID	String	是

返回值

英文名称	中文名称	类型	备注
RequestId	请求ID	String	–
Engine	数据库引擎名称	String	-
EngineVersion	数据库引擎版本号	String	-
Parameters	实例参数列表	Map<String,Object>	-

请求示例

http://krds.{{region}}.api.ksyun.com/?Action=DescribeDBInstanceParameters&Version=2016-07-01&DBInstanceIdentifier=4d97f65f-5603-4373-b870-48a280ecc464

示例返回

{
    "Data": {
        "Engine": "MySQL",
        "EngineVersion": "5.7",
        "Parameters": {
            "delay_key_write": "ON",
            "connect_timeout": 15,
            "innodb_purge_batch_size": 20,
            "myisam_sort_buffer_size": 8388608,
            "bulk_insert_buffer_size": 8388608,
            "innodb_concurrency_tickets": 500,
            "div_precision_increment": 4,
            "max_prepared_stmt_count": 16382,
            "tx_isolation": "REPEATABLE-READ",
            "wait_timeout": 28800,
            "table_definition_cache": 400,
            "auto_increment_increment": 1,
            "ft_query_expansion_limit": 20,
            "innodb_stats_sample_pages": 8,
            "innodb_old_blocks_time": 0,
            "innodb_print_all_deadlocks": "OFF",
            "sync_binlog": 1,
            "innodb_stats_method": "nulls_equal",
            "lock_wait_timeout": 1200,
            "net_read_timeout": 30,
            "query_prealloc_size": 8192,
            "max_error_count": 1024,
            "back_log": 1024,
            "key_cache_age_threshold": 300,
            "innodb_log_file_size": 134217728,
            "innodb_thread_concurrency": 0,
            "innodb_flush_log_at_trx_commit": 1,
            "innodb_strict_mode": "OFF",
            "default_time_zone": "SYSTEM",
            "performance_schema": "OFF",
            "innodb_write_io_threads": 8,
            "rpl_semi_sync_master_timeout": 1000,
            "max_connect_errors": 10,
            "join_buffer_size": 1048576,
            "rpl_semi_sync_slave_enabled": "ON",
            "innodb_rollback_on_timeout": "OFF",
            "old_alter_table": "OFF",
            "binlog_row_image": "FULL",
            "key_cache_block_size": 1024,
            "query_cache_type": "OFF",
            "local_infile": "ON",
            "init_connect": "",
            "binlog_format": "MIXED",
            "log_slave_updates": "ON",
            "slow_launch_time": 2,
            "net_write_timeout": 300,
            "innodb_table_locks": "ON",
            "query_alloc_block_size": 8192,
            "tmp_table_size": 10737418,
            "lower_case_table_names": 1,
            "default_week_format": 0,
            "key_cache_division_limit": 100,
            "innodb_lock_wait_timeout": 50,
            "delayed_insert_timeout": 300,
            "net_retry_count": 10,
            "innodb_purge_threads": 1,
            "binlog_cache_size": 524288,
            "low_priority_updates": "OFF",
            "auto_increment_offset": 1,
            "query_cache_limit": 1048576,
            "innodb_read_ahead_threshold": 56,
            "innodb_max_dirty_pages_pct": 75,
            "ft_min_word_len": 4,
            "concurrent_insert": "AUTO",
            "long_query_time": 1.0,
            "slow_query_log": "ON",
            "sort_buffer_size": 1048576,
            "interactive_timeout": 28800,
            "query_cache_size": 0,
            "innodb_read_io_threads": 8,
            "rpl_semi_sync_master_enabled": "ON",
            "max_allowed_packet": 536870912,
            "delayed_insert_limit": 100,
            "innodb_open_files": 2000,
            "character_set_server": "utf8",
            "delayed_queue_size": 1000,
            "max_user_connections": 0,
            "innodb_old_blocks_pct": 37,
            "table_open_cache": 2000,
            "log_slow_admin_statements": "OFF",
            "log_bin_trust_function_creators": "OFF",
            "log_queries_not_using_indexes": "OFF",
            "innodb_stats_on_metadata": "OFF",
            "table_open_cache_instances": 16,
            "group_concat_max_len": 1024,
            "innodb_sort_buffer_size": 1048576
        }
    },
    "RequestId": "20cd8ad3-631f-4af8-baec-66ab3c15a6a1"
}