全部文档
当前文档
最近更新时间：2021-10-19 16:38:20
接口说明：查询不同数据库版本下的默认参数组详情。
接口功能：
新建参数组作为默认模板使用
数据库参数是否变更及实例修改参数是否需要重启依照。
接口返回：
返回参数列表。
返回参数默认值。
返回修改区间(数值类型为最大/最小值，固定参数为枚举)。
返回修改参数是否需要重启实例(RestartRequired)。
GET
| 英文名称 | 中文名称 | 类型 | 是否必须 | 备注 |
|---|---|---|---|---|
| Action | 调用接口名称 | String | 是 | 取固定值：DescribeEngineDefaultParameters |
| Version | API版本号 | String | 是 | 取固定值：2016-07-01 |
| Engine | 数据库引擎名称 | String | 是 | 引擎名称和版本必须对应 |
| EngineVersion | 数据库引擎版本 | String | 是 | 引擎名称和版本必须对应 |
数据库引擎名称/版本对应关系：
| Engine(数据库引擎名称) | EngineVersion(数据库引擎版本) |
| mysql | 5.5 |
| 5.6 | |
| 5.7 | |
| 8.0 | |
| percona | 5.6 |
| consistent_mysql | 5.7 |
| ebs_mysql | 5.6 |
| 5.7 |
| 英文名称 | 中文名称 | 类型 | 备注 |
|---|---|---|---|
| RequestId | 请求ID | String | – |
| Data | - | - | - |
Data：
| 英文名称 | 中文名称 | 类型 | 备注 |
|---|---|---|---|
| Engine | 引擎名称 | String | – |
| EngineVersion | 引擎版本 | String | - |
| Parameters | 参数列表 | Map<String,Object> |
注意： Parameters为Map类型
| 英文名称 | 中文名称 | 类型 | 备注 | |
| key | 参数名称 | String | ||
| value | Max | 参数最大值 | Integer | |
| Min | 参数最小值 | Integer | ||
| Default | 参数默认值 | String | ||
| RestartRequired | 修改是否需要重启 | Boolean | ||
| Type | 参数类型 | String | ||
| Enums | 枚举参数列表 | Enum | ||
| Alias | 参数别名 | String | "tx_isolation": { "Default": "REPEATABLE-READ", "RestartRequired": false, "Type": "string", "Alias": "transaction_isolation", "Enums": [ "READ-UNCOMMITTED", "READ-COMMITTED", "REPEATABLE-READ", "SERIALIZABLE" ] } |
|
http://krds.{{region}}.api.ksyun.com/?Action=DescribeEngineDefaultParameters&Version=2016-07-01&Engine=mysql&EngineVersion=5.7
{
"Data": {
"Engine": "mysql",
"EngineVersion": "5.7",
"Parameters": {
"connect_timeout": {
"Min": 2,
"Default": 15,
"Max": 31536000,
"RestartRequired": false,
"Type": "integer"
},
"delay_key_write": {
"Default": "ON",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF",
"ALL"
]
},
"innodb_purge_batch_size": {
"Min": 1,
"Default": 20,
"Max": 5000,
"RestartRequired": false,
"Type": "integer"
},
"myisam_sort_buffer_size": {
"Min": 4096,
"Default": 8388608,
"Max": 16777216,
"RestartRequired": false,
"Type": "integer"
},
"bulk_insert_buffer_size": {
"Min": 0,
"Default": 8388608,
"Max": 67108864,
"RestartRequired": false,
"Type": "integer"
},
"div_precision_increment": {
"Min": 0,
"Default": 4,
"Max": 30,
"RestartRequired": false,
"Type": "integer"
},
"innodb_concurrency_tickets": {
"Min": 1,
"Default": 500,
"Max": 4294967295,
"RestartRequired": false,
"Type": "integer"
},
"max_prepared_stmt_count": {
"Min": 0,
"Default": 16382,
"Max": 1048576,
"RestartRequired": false,
"Type": "integer"
},
"wait_timeout": {
"Min": 1,
"Default": 28800,
"Max": 31536000,
"RestartRequired": false,
"Type": "integer"
},
"tx_isolation": {
"Default": "REPEATABLE-READ",
"RestartRequired": false,
"Type": "string",
"Alias": "transaction_isolation",
"Enums": [
"READ-UNCOMMITTED",
"READ-COMMITTED",
"REPEATABLE-READ",
"SERIALIZABLE"
]
},
"table_definition_cache": {
"Min": 400,
"Default": 400,
"Max": 8096,
"RestartRequired": false,
"Type": "integer"
},
"auto_increment_increment": {
"Min": 1,
"Default": 1,
"Max": 65535,
"RestartRequired": false,
"Type": "integer"
},
"ft_query_expansion_limit": {
"Min": 0,
"Default": 20,
"Max": 1000,
"RestartRequired": true,
"Type": "integer"
},
"innodb_old_blocks_time": {
"Min": 0,
"Default": 0,
"Max": 1000,
"RestartRequired": false,
"Type": "integer"
},
"innodb_stats_sample_pages": {
"Min": 1,
"Default": 8,
"Max": 2048,
"RestartRequired": false,
"Type": "integer"
},
"innodb_print_all_deadlocks": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"sync_binlog": {
"Min": 0,
"Default": 1,
"Max": 4294967295,
"RestartRequired": false,
"Type": "integer"
},
"innodb_stats_method": {
"Default": "nulls_equal",
"RestartRequired": false,
"Type": "string",
"Enums": [
"nulls_equal",
"nulls_unequal",
"nulls_ignored"
]
},
"lock_wait_timeout": {
"Min": 1,
"Default": 1200,
"Max": 31536000,
"RestartRequired": false,
"Type": "integer"
},
"net_read_timeout": {
"Min": 1,
"Default": 30,
"Max": 500,
"RestartRequired": false,
"Type": "integer"
},
"query_prealloc_size": {
"Min": 8192,
"Default": 8192,
"Max": 8388608,
"RestartRequired": false,
"Type": "integer",
"Step": 1024
},
"back_log": {
"Min": 1,
"Default": 1024,
"Max": 65535,
"RestartRequired": true,
"Type": "integer"
},
"max_error_count": {
"Min": 0,
"Default": 1024,
"Max": 65535,
"RestartRequired": false,
"Type": "integer"
},
"key_cache_age_threshold": {
"Min": 100,
"Default": 300,
"Max": 2000,
"RestartRequired": false,
"Type": "integer",
"Step": 100
},
"innodb_log_file_size": {
"Min": 1048576,
"Default": 134217728,
"Max": 4294967296,
"RestartRequired": true,
"Type": "integer",
"Step": 1048576
},
"innodb_thread_concurrency": {
"Min": 0,
"Default": 0,
"Max": 1000,
"RestartRequired": false,
"Type": "integer"
},
"innodb_strict_mode": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"innodb_flush_log_at_trx_commit": {
"Min": 0,
"Default": 1,
"Max": 2,
"RestartRequired": false,
"Type": "integer"
},
"default_time_zone": {
"Default": "SYSTEM",
"RestartRequired": true,
"Type": "string",
"Enums": [
"SYSTEM",
"+08:00",
"-06:00",
"+09:30",
"-04:00"
]
},
"performance_schema": {
"Default": "OFF",
"RestartRequired": true,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"innodb_write_io_threads": {
"Min": 1,
"Default": 8,
"Max": 64,
"RestartRequired": true,
"Type": "integer"
},
"rpl_semi_sync_master_timeout": {
"Min": 0,
"Default": 1000,
"Max": 10000,
"RestartRequired": false,
"Type": "integer"
},
"max_connect_errors": {
"Min": 1,
"Default": 10,
"Max": 4294967295,
"RestartRequired": false,
"Type": "integer"
},
"join_buffer_size": {
"Min": 128,
"Default": 1048576,
"Max": 8388608,
"RestartRequired": false,
"Type": "integer",
"Step": 128
},
"rpl_semi_sync_slave_enabled": {
"Default": "ON",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"innodb_rollback_on_timeout": {
"Default": "OFF",
"RestartRequired": true,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"old_alter_table": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"binlog_row_image": {
"Default": "FULL",
"RestartRequired": false,
"Type": "string",
"Enums": [
"FULL",
"MINIMAL",
"noblob"
]
},
"key_cache_block_size": {
"Min": 512,
"Default": 1024,
"Max": 16384,
"RestartRequired": false,
"Type": "integer",
"Step": 512
},
"query_cache_type": {
"Default": "OFF",
"RestartRequired": true,
"Type": "string",
"Ignore": true,
"Enums": [
"ON",
"OFF",
"DEMAND"
]
},
"init_connect": {
"Default": "",
"RestartRequired": false,
"Type": "string",
"Enums": [
"SET NAMES utf8;",
"SET NAMES latin1;",
"SET NAMES gbk;",
"SET NAMES utf8mb4;",
""
]
},
"local_infile": {
"Default": "ON",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"binlog_format": {
"Default": "MIXED",
"RestartRequired": false,
"Type": "string",
"Enums": [
"MIXED",
"ROW",
"STATEMENT"
]
},
"log_slave_updates": {
"Default": "ON",
"RestartRequired": true,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"slow_launch_time": {
"Min": 0,
"Default": 2,
"Max": 10,
"RestartRequired": false,
"Type": "integer"
},
"innodb_table_locks": {
"Default": "ON",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"net_write_timeout": {
"Min": 1,
"Default": 300,
"Max": 500,
"RestartRequired": false,
"Type": "integer"
},
"query_alloc_block_size": {
"Min": 1024,
"Default": 8192,
"Max": 32768,
"RestartRequired": false,
"Type": "integer",
"Step": 1024
},
"lower_case_table_names": {
"Min": 0,
"Default": 1,
"Max": 1,
"RestartRequired": true,
"Type": "integer"
},
"tmp_table_size": {
"Min": 1024,
"Default": "instance_memory * 0.5%",
"Max": "instance_memory * 10%",
"RestartRequired": false,
"Type": "expression",
"DefaultScaleFactor": "0.5%",
"MaxScaleFactor": "10%",
"Variable": "instance_memory"
},
"default_week_format": {
"Min": 0,
"Default": 0,
"Max": 7,
"RestartRequired": false,
"Type": "integer"
},
"key_cache_division_limit": {
"Min": 1,
"Default": 100,
"Max": 100,
"RestartRequired": false,
"Type": "integer"
},
"innodb_lock_wait_timeout": {
"Min": 1,
"Default": 50,
"Max": 28800,
"RestartRequired": false,
"Type": "integer"
},
"delayed_insert_timeout": {
"Min": 1,
"Default": 300,
"Max": 500,
"RestartRequired": false,
"Type": "integer"
},
"net_retry_count": {
"Min": 1,
"Default": 10,
"Max": 1000,
"RestartRequired": false,
"Type": "integer"
},
"innodb_purge_threads": {
"Min": 1,
"Default": 1,
"Max": 32,
"RestartRequired": true,
"Type": "integer"
},
"binlog_cache_size": {
"Min": 4096,
"Default": 524288,
"Max": 4294967295,
"RestartRequired": false,
"Type": "integer"
},
"low_priority_updates": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"auto_increment_offset": {
"Min": 1,
"Default": 1,
"Max": 65535,
"RestartRequired": false,
"Type": "integer"
},
"innodb_max_dirty_pages_pct": {
"Min": 0,
"Default": 75,
"Max": 99,
"RestartRequired": false,
"Type": "integer"
},
"innodb_read_ahead_threshold": {
"Min": 0,
"Default": 56,
"Max": 64,
"RestartRequired": false,
"Type": "integer"
},
"query_cache_limit": {
"Min": 0,
"Default": 1048576,
"Max": 8388608,
"RestartRequired": false,
"Type": "integer"
},
"ft_min_word_len": {
"Min": 1,
"Default": 4,
"Max": 10,
"RestartRequired": true,
"Type": "integer"
},
"concurrent_insert": {
"Default": "AUTO",
"RestartRequired": false,
"Type": "string",
"Enums": [
"NEVER",
"AUTO",
"ALWAYS"
]
},
"long_query_time": {
"Min": 0,
"Default": 1.0,
"Max": 5000,
"RestartRequired": false,
"Type": "float"
},
"slow_query_log": {
"Default": "ON",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"sort_buffer_size": {
"Min": 32768,
"Default": 1048576,
"Max": 4294967295,
"RestartRequired": false,
"Type": "integer"
},
"interactive_timeout": {
"Min": 1,
"Default": 28800,
"Max": 31536000,
"RestartRequired": false,
"Type": "integer"
},
"query_cache_size": {
"Min": 0,
"Default": 0,
"Max": 104857600,
"RestartRequired": false,
"Type": "integer",
"SecondMin": 50176,
"Step": 1024
},
"innodb_read_io_threads": {
"Min": 1,
"Default": 8,
"Max": 64,
"RestartRequired": true,
"Type": "integer"
},
"max_allowed_packet": {
"Min": 1024,
"Default": 536870912,
"Max": 1073741824,
"RestartRequired": false,
"Type": "integer",
"Step": 1024
},
"rpl_semi_sync_master_enabled": {
"Default": "ON",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"delayed_insert_limit": {
"Min": 1,
"Default": 100,
"Max": 2000,
"RestartRequired": false,
"Type": "integer"
},
"innodb_open_files": {
"Min": 10,
"Default": 2000,
"Max": 10240,
"RestartRequired": true,
"Type": "integer"
},
"character_set_server": {
"Default": "utf8",
"RestartRequired": false,
"Type": "string",
"Enums": [
"utf8",
"latin1",
"gbk",
"utf8mb4"
]
},
"delayed_queue_size": {
"Min": 1,
"Default": 1000,
"Max": 2000,
"RestartRequired": false,
"Type": "integer"
},
"max_user_connections": {
"Min": 0,
"Default": 0,
"Max": 4294967295,
"RestartRequired": false,
"Type": "integer"
},
"innodb_old_blocks_pct": {
"Min": 5,
"Default": 37,
"Max": 95,
"RestartRequired": false,
"Type": "integer"
},
"table_open_cache": {
"Min": 1,
"Default": 2000,
"Max": 8096,
"RestartRequired": false,
"Type": "integer"
},
"log_slow_admin_statements": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"log_bin_trust_function_creators": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"log_queries_not_using_indexes": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"innodb_stats_on_metadata": {
"Default": "OFF",
"RestartRequired": false,
"Type": "string",
"Enums": [
"ON",
"OFF"
]
},
"table_open_cache_instances": {
"Min": 1,
"Default": 16,
"Max": 64,
"RestartRequired": true,
"Type": "integer"
},
"group_concat_max_len": {
"Min": 4,
"Default": 1024,
"Max": 134217728,
"RestartRequired": false,
"Type": "integer"
},
"innodb_sort_buffer_size": {
"Min": 65536,
"Default": 1048576,
"Max": 67108864,
"RestartRequired": true,
"Type": "integer"
}
}
},
"RequestId": "4f262443-6427-419a-9494-e8de524910b5"
}
纯净模式