重置数据库参数组

最近更新时间:2018-12-21 15:41:07

ResetDBParameterGroup 重置数据库参数组

请求参数

Action

调用接口名称

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

Version

API版本号。

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

DBParameterGroupId

参数组ID

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

返回值

RequestId

请求ID

  • 类型:String

DBParameterGroup

参数组

  • 类型:DBParameterGroup

请求示例

https://krds.api.ksyun.com/?Action=ResetDBParameterGroup

DBParameterGroupId=xxxxx

&<公共请求参数>

示例返回

{
"Data": {
"DBParameterGroup": {
"DBParameterGroupId": "78f67f14-55cd-40fb-b8be-8ca8bd3d8078",
"DBParameterGroupName": "test",
"EngineVersion": "5.6",
"Description": "123",
"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,
"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,
"innodb_table_locks": "ON",
"net_read_timeout": 30,
"innodb_read_io_threads": 8,
"innodb_buffer_pool_size": "instance_memory * 60%",
"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": "instance_memory * 0.5%",
"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,
"autocommit": "ON",
"query_prealloc_size": 8192,
"key_cache_block_size": 1024,
"innodb_lock_wait_timeout": 50
},
"Engine": "mysql"
}
},
"RequestId": "1116140130490094700"
}
  "RequestId": "2037195728352694561",
  "Error": {}
}

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

注册有礼