查看数据库默认参数

最近更新时间:2018-12-21 15:40:10

DescribeEngineDefaultParameters 查看数据库默认参数

请求参数

Action

调用接口名称

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

Version

API版本号。

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

Engine

数据引擎名称

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

EngineVersion

数据库引擎版本

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

返回值

RequestId

请求ID

  • 类型:String

Parameters

数据库参数列表

  • 类型:Object({"": {"Min":?,"Max":?,"Default":?,"RestartRequired":?,"Type":?}})

请求示例

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

&Engine=mysql

&EngineVersion=mysql-5.5

示例返回


{
"Data":{
"Engine":"mysql",
"EngineVersion":"mysql-5.5",
"Parameters":{
"innodb_thread_concurrency":{
"Min":0,
"Default":0,
"Max":1000,
"RestartRequired":false,
"Type":"integer"
},
"innodb_strict_mode":{
"Default":"OFF",
"RestartRequired":false,
"Type":"string"
},
"slow_launch_time":{
"Min":0,
"Default":2,
"Max":10,
"RestartRequired":false,
"Type":"integer"
},
"log_bin_trust_function_creators":{
"Default":"OFF",
"RestartRequired":false,
"Type":"string"
},
"innodb_log_buffer_size":{
"Min":262144,
"Default":33554432,
"Max":134217728,
"RestartRequired":true,
"Type":"integer"
},
"character_set_server":{
"Default":"utf8",
"RestartRequired":false,
"Type":"string"
},
"connect_timeout":{
"Min":2,
"Default":15,
"Max":31536000,
"RestartRequired":false,
"Type":"integer"
},
"net_write_timeout":{
"Min":1,
"Default":300,
"Max":500,
"RestartRequired":false,
"Type":"integer"
},
"auto_increment_increment":{
"Min":1,
"Default":1,
"Max":65535,
"RestartRequired":false,
"Type":"integer"
},
"bulk_insert_buffer_size":{
"Min":0,
"Default":8388608,
"Max":67108864,
"RestartRequired":false,
"Type":"integer"
},
"innodb_write_io_threads":{
"Min":1,
"Default":8,
"Max":64,
"RestartRequired":true,
"Type":"integer"
},
"innodb_open_files":{
"Min":10,
"Default":300,
"Max":10240,
"RestartRequired":true,
"Type":"integer"
},
"innodb_stats_sample_pages":{
"Min":1,
"Default":8,
"Max":2048,
"RestartRequired":false,
"Type":"integer"
},
"table_definition_cache":{
"Min":400,
"Default":400,
"Max":8096,
"RestartRequired":false,
"Type":"integer"
},
"concurrent_insert":{
"Default":"AUTO",
"RestartRequired":false,
"Type":"string"
},
"default_week_format":{
"Min":0,
"Default":0,
"Max":7,
"RestartRequired":false,
"Type":"integer"
},
"low_priority_updates":{
"Default":"OFF",
"RestartRequired":false,
"Type":"string"
},
"wait_timeout":{
"Min":1,
"Default":28800,
"Max":31536000,
"RestartRequired":false,
"Type":"integer"
},
"query_cache_limit":{
"Min":0,
"Default":1048576,
"Max":8388608,
"RestartRequired":false,
"Type":"integer"
},
"myisam_sort_buffer_size":{
"Min":4096,
"Default":8388608,
"Max":16777216,
"RestartRequired":false,
"Type":"integer"
},
"query_alloc_block_size":{
"Min":1024,
"Default":8192,
"Max":32768,
"RestartRequired":false,
"Type":"integer"
},
"init_connect":{
"Default":"",
"RestartRequired":false,
"Type":"string"
},
"ft_query_expansion_limit":{
"Min":0,
"Default":20,
"Max":1000,
"RestartRequired":true,
"Type":"integer"
},
"net_retry_count":{
"Min":1,
"Default":10,
"Max":1000,
"RestartRequired":false,
"Type":"integer"
},
"innodb_flush_log_at_trx_commit":{
"Min":0,
"Default":1,
"Max":2,
"RestartRequired":false,
"Type":"integer"
},
"innodb_stats_method":{
"Default":"nulls_equal",
"RestartRequired":false,
"Type":"string"
},
"query_cache_type":{
"Default":"OFF",
"RestartRequired":true,
"Type":"string"
},
"lower_case_table_names":{
"Min":0,
"Default":0,
"Max":1,
"RestartRequired":true,
"Type":"integer"
},
"interactive_timeout":{
"Min":1,
"Default":28800,
"Max":31536000,
"RestartRequired":false,
"Type":"integer"
},
"join_buffer_size":{
"Min":128,
"Default":1048576,
"Max":8388608,
"RestartRequired":false,
"Type":"integer"
},
"log_queries_not_using_indexes":{
"Default":"OFF",
"RestartRequired":false,
"Type":"string"
},
"delayed_queue_size":{
"Min":1,
"Default":1000,
"Max":2000,
"RestartRequired":false,
"Type":"integer"
},
"rpl_semi_sync_master_enabled":{
"Default":"ON",
"RestartRequired":false,
"Type":"string"
},
"long_query_time":{
"Min":0,
"Default":1.0,
"Max":5000,
"RestartRequired":false,
"Type":"float"
},
"local_infile":{
"Default":"ON",
"RestartRequired":false,
"Type":"string"
},
"sync_binlog":{
"Min":0,
"Default":1,
"Max":100,
"RestartRequired":false,
"Type":"integer"
},
"auto_increment_offset":{
"Min":1,
"Default":1,
"Max":65535,
"RestartRequired":false,
"Type":"integer"
},
"max_allowed_packet":{
"Min":1024,
"Default":134217728,
"Max":134217728,
"RestartRequired":false,
"Type":"integer"
},
"ft_min_word_len":{
"Min":1,
"Default":4,
"Max":10,
"RestartRequired":true,
"Type":"integer"
},
"rpl_semi_sync_slave_enabled":{
"Default":"ON",
"RestartRequired":false,
"Type":"string"
},
"delayed_insert_timeout":{
"Min":1,
"Default":300,
"Max":500,
"RestartRequired":false,
"Type":"integer"
},
"innodb_old_blocks_pct":{
"Min":5,
"Default":37,
"Max":95,
"RestartRequired":false,
"Type":"integer"
},
"innodb_purge_batch_size":{
"Min":1,
"Default":20,
"Max":5000,
"RestartRequired":false,
"Type":"integer"
},
"group_concat_max_len":{
"Min":4,
"Default":1024,
"Max":134217728,
"RestartRequired":false,
"Type":"integer"
},
"innodb_concurrency_tickets":{
"Min":1,
"Default":500,
"Max":1000,
"RestartRequired":false,
"Type":"integer"
},
"delay_key_write":{
"Default":"ON",
"RestartRequired":false,
"Type":"string"
},
"innodb_rollback_on_timeout":{
"Default":"OFF",
"RestartRequired":true,
"Type":"string"
},
"key_cache_division_limit":{
"Min":1,
"Default":100,
"Max":100,
"RestartRequired":false,
"Type":"integer"
},
"innodb_additional_mem_pool_size":{
"Min":2097152,
"Default":8388608,
"Max":16777216,
"RestartRequired":true,
"Type":"integer"
},
"net_read_timeout":{
"Min":1,
"Default":30,
"Max":500,
"RestartRequired":false,
"Type":"integer"
},
"innodb_table_locks":{
"Default":"ON",
"RestartRequired":false,
"Type":"string"
},
"innodb_buffer_pool_size":{
"Min":"instance_memory * 20%",
"Default":"instance_memory * 60%",
"Max":"instance_memory * 80%",
"RestartRequired":true,
"Type":"expression"
},
"innodb_read_io_threads":{
"Min":1,
"Default":8,
"Max":64,
"RestartRequired":true,
"Type":"integer"
},
"binlog_format":{
"Default":"MIXED",
"RestartRequired":false,
"Type":"string"
},
"delayed_insert_limit":{
"Min":1,
"Default":100,
"Max":2000,
"RestartRequired":false,
"Type":"integer"
},
"innodb_old_blocks_time":{
"Min":0,
"Default":0,
"Max":1000,
"RestartRequired":false,
"Type":"integer"
},
"div_precision_increment":{
"Min":0,
"Default":4,
"Max":30,
"RestartRequired":false,
"Type":"integer"
},
"innodb_stats_on_metadata":{
"Default":"OFF",
"RestartRequired":false,
"Type":"string"
},
"max_connect_errors":{
"Min":1,
"Default":10,
"Max":100,
"RestartRequired":false,
"Type":"integer"
},
"innodb_read_ahead_threshold":{
"Min":0,
"Default":56,
"Max":64,
"RestartRequired":false,
"Type":"integer"
},
"tmp_table_size":{
"Min":1024,
"Default":"instance_memory * 0.5%",
"Max":"instance_memory * 10%",
"RestartRequired":false,
"Type":"expression"
},
"key_cache_age_threshold":{
"Min":100,
"Default":300,
"Max":2000,
"RestartRequired":false,
"Type":"integer"
},
"innodb_max_dirty_pages_pct":{
"Min":0,
"Default":75,
"Max":99,
"RestartRequired":false,
"Type":"integer"
},
"tx_isolation":{
"Default":"REPEATABLE-READ",
"RestartRequired":false,
"Type":"string"
},
"query_cache_size":{
"Min":0,
"Default":0,
"Max":1048576,
"RestartRequired":false,
"Type":"integer"
},
"innodb_file_format":{
"Default":"Antelope",
"RestartRequired":false,
"Type":"string"
},
"back_log":{
"Min":1,
"Default":1024,
"Max":65535,
"RestartRequired":true,
"Type":"integer"
},
"table_open_cache":{
"Min":1,
"Default":400,
"Max":8096,
"RestartRequired":false,
"Type":"integer"
},
"rpl_semi_sync_master_timeout":{
"Min":0,
"Default":1000,
"Max":10000,
"RestartRequired":false,
"Type":"integer"
},
"innodb_purge_threads":{
"Min":0,
"Default":1,
"Max":1,
"RestartRequired":true,
"Type":"integer"
},
"innodb_autoinc_lock_mode":{
"Min":0,
"Default":1,
"Max":2,
"RestartRequired":true,
"Type":"integer"
},
"sort_buffer_size":{
"Min":32768,
"Default":1048576,
"Max":8388608,
"RestartRequired":false,
"Type":"integer"
},
"query_prealloc_size":{
"Min":8192,
"Default":8192,
"Max":8388608,
"RestartRequired":false,
"Type":"integer"
},
"autocommit":{
"Default":"ON",
"RestartRequired":false,
"Type":"string"
},
"key_cache_block_size":{
"Min":512,
"Default":1024,
"Max":16384,
"RestartRequired":false,
"Type":"integer"
},
"innodb_thread_sleep_delay":{
"Min":0,
"Default":10000,
"Max":1000000,
"RestartRequired":false,
"Type":"integer"
},
"innodb_lock_wait_timeout":{
"Min":1,
"Default":50,
"Max":28800,
"RestartRequired":false,
"Type":"integer"
}
}
},
"RequestId":"4367539744524331411",
"Status":"OK",
"Message":"OK"
}

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

立即注册