查看当前实例数据库参数运行值列表

最近更新时间:2018-12-21 15:39:49

DescribeDBInstanceParameters 查看当前实例数据库参数运行值列表

请求参数

Action

调用接口名称

  • 类型:String
  • 备注:取固定值:DescribeDBInstanceParameters
  • 是否必须:是

Version

API版本号。

  • 类型:String
  • 备注:取固定值:2016-07-01
  • 是否必须:是

DBInstanceIdentifier

按实例Id过滤

  • 类型:String
  • 是否必须:否
  • 备注:实例ID(传入实例ID,获取的是该实例的详情,否则则获取list)

Engine

数据引擎名称

  • 类型:String
  • 是否必须:否

EngineVersion

数据库引擎版本

  • 类型:String
  • 是否必须:否

返回值

RequestId

请求ID

  • 类型:String

Engine

数据库引擎

  • 类型:String

EngineVersion

数据库引擎版本

  • 类型:String

Parameters

参数列表 *类型:Object

请求示例

https://krds.api.ksyun.com/?Action=DescribeDBInstanceParameters
&DBInstanceIdentifier=xxxxxxxx
&<公共请求参数>

示例返回

{
"Data": {
"Engine": "MySQL",
"EngineVersion": "5.5",
"Parameters": {
"innodb_thread_concurrency": "0",
"innodb_strict_mode": "OFF",
"slow_launch_time": "2",
"log_bin_trust_function_creators": "OFF",
"innodb_log_buffer_size": "33554432",
"character_set_server": "utf8",
"connect_timeout": "15",
"net_write_timeout": "300",
"auto_increment_increment": "1",
"bulk_insert_buffer_size": "8388608",
"innodb_write_io_threads": "8",
"innodb_open_files": "300",
"innodb_stats_sample_pages": "8",
"table_definition_cache": "400",
"concurrent_insert": "AUTO",
"default_week_format": "0",
"low_priority_updates": "OFF",
"wait_timeout": "28800",
"query_cache_limit": "1048576",
"myisam_sort_buffer_size": "8388608",
"query_alloc_block_size": "8192",
"init_connect": "",
"ft_query_expansion_limit": "20",
"net_retry_count": "10",
"innodb_flush_log_at_trx_commit": "1",
"innodb_stats_method": "nulls_equal",
"query_cache_type": "OFF",
"join_buffer_size": "1048576",
"interactive_timeout": "28800",
"lower_case_table_names": "0",
"log_queries_not_using_indexes": "OFF",
"delayed_queue_size": "1000",
"long_query_time": "1.000000",
"rpl_semi_sync_master_enabled": "ON",
"local_infile": "ON",
"sync_binlog": "1",
"auto_increment_offset": "1",
"max_allowed_packet": "134217728",
"ft_min_word_len": "4",
"delayed_insert_timeout": "300",
"rpl_semi_sync_slave_enabled": "ON",
"innodb_old_blocks_pct": "37",
"innodb_purge_batch_size": "20",
"group_concat_max_len": "1024",
"innodb_concurrency_tickets": "500",
"delay_key_write": "ON",
"innodb_rollback_on_timeout": "OFF",
"key_cache_division_limit": "100",
"innodb_additional_mem_pool_size": "8388608",
"net_read_timeout": "30",
"innodb_table_locks": "ON",
"innodb_buffer_pool_size": "643825664",
"innodb_read_io_threads": "8",
"binlog_format": "MIXED",
"delayed_insert_limit": "100",
"innodb_old_blocks_time": "0",
"div_precision_increment": "4",
"max_connect_errors": "10",
"innodb_stats_on_metadata": "OFF",
"innodb_read_ahead_threshold": "56",
"tmp_table_size": "5368709",
"key_cache_age_threshold": "300",
"innodb_max_dirty_pages_pct": "75",
"tx_isolation": "REPEATABLE-READ",
"query_cache_size": "0",
"innodb_file_format": "Antelope",
"back_log": "1024",
"table_open_cache": "400",
"rpl_semi_sync_master_timeout": "1000",
"innodb_purge_threads": "1",
"innodb_autoinc_lock_mode": "1",
"sort_buffer_size": "1048576",
"query_prealloc_size": "8192",
"autocommit": "ON",
"key_cache_block_size": "1024",
"innodb_thread_sleep_delay": "10000",
"innodb_lock_wait_timeout": "50"
}
},
"RequestId": "9034627818888501875"
}

金山云,开启您的云计算之旅

立即注册