最近更新时间:2021-10-19 16:38:21
重置数据库实例参数值为默认参数值。
注意:若重置前后需重启生效的参数值发生改变,重启后方可生效。
GET
英文名称 | 中文名称 | 类型 | 是否必须 | 备注 |
---|---|---|---|---|
Action | 调用接口名称 | String | 是 | 取固定值:ResetDBParameterGroup |
Version | API版本号 | String | 是 | 取固定值:2016-07-01 |
DBParameterGroupId | 参数组ID | String | 是 | 通过参数组-列表(详情)接口获取 |
英文名称 | 中文名称 | 类型 | 备注 |
---|---|---|---|
RequestId | 请求ID | String | – |
Data.DBParameterGroups | 参数组列表 | List | - |
DBParameterGroups:
英文名称 | 中文名称 | 类型 | 备注 |
---|---|---|---|
DBParameterGroupId | 参数组ID | String | – |
DBParameterGroupName | 参数组名称 | String | - |
EngineVersion | 数据库引擎版本 | String | |
Engine | 数据库引擎 | String | |
Description | 参数组描述 | String | |
Parameters | 参数组参数值 | Map<String,Object> |
http://krds.{{region}}.api.ksyun.com/?Action=ResetDBParameterGroup&Version=2016-07-01&DBParameterGroupId=60c3de60-033f-4101-af78-24b12974ad78
{
"Data": {
"DBParameterGroup": {
"DBParameterGroupId": "60c3de60-033f-4101-af78-24b12974ad78",
"DBParameterGroupName": "default",
"EngineVersion": "5.7",
"Description": "mysql 5.7 default",
"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,
"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
},
"Engine": "mysql"
}
},
"RequestId": "FE8a86a670-0f85-11ec-95a9-f70957371b48"
}
纯净模式