全部文档
当前文档

暂无内容

如果没有找到您期望的内容,请尝试其他搜索词

文档中心

重置数据库参数组

最近更新时间:2021-10-19 16:38:21

ResetDBParameterGroup 重置数据库参数组

重置数据库实例参数值为默认参数值。

注意:若重置前后需重启生效的参数值发生改变,重启后方可生效。

请求方式

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"
}
文档导读
纯净模式常规模式

纯净模式

点击可全屏预览文档内容
文档反馈