Get Parameter List
Last Updated:2021-11-05
Return the Database Parameters List under the instance.
Request Structure
GET /v{version}/instance/{instanceId}/parameter HTTP/1.1
HOST: rds.bj.baidubce.com
Authorization: authorization string
Request Header Field
No other special header fields are available except for common header fields.
Request Parameters
Parameter Name | Type | Required? | Parameter Position | Description |
---|---|---|---|---|
version | string | Yes | URL parameter | API Version Number |
instanceId | string | Yes | URL parameter | Instance ID |
Return Header Field
Parameter Name | Type | Description |
---|---|---|
ETag | string | For the current version number, the current ETag needs to be passed back via the header during the modification. |
Return Parameters
Parameter Name | Type | Description |
---|---|---|
parameters | List parameter | An array that consists of [Parameter](RDS/API reference/Object descriptions.md#Parameter Object details). |
Request Example
GET /v{version}/instance/{instanceId}/parameter HTTP/1.1
HOST: rds.bj.baidubce.com
Authorization: bce-auth-v1/rdsak/2016-07-03T06:13:13Z/1800/x-bce-date/{signature}
Return Example
HTTP/1.1 200 OK
x-bce-request-id: 7869616F-7A68-6977-656E-406261696475
ETag:xxx-xxx-xxx
Content-Type: application/json
Content-Length: 567
{
"parameters": [
{
"name" : "wait_timeout",
"defaultValue" : "28800",
"value" : "1",
"pendingValue" : "",
"type" : "integer",
"dynamic" : true,
"modifiable" : true,
"allowedValues" : "60-86400",
"desc" : “Timeout period during which the server waits for the non-interaction connection."
},
{
"name" : "lower_case_table_names",
"defaultValue" : "1",
"value" : "1",
"pendingValue" : "2",
"type" : "string",
"dynamic" : false,
"modifiable" : true,
"allowedValues" : "0,1,2",
"desc" : “The table name should be case sensitive."
},
{
"name" : "sql_mode",
"defaultValue" : "",
"value" : "",
"pendingValue" : "",
"type" : "set<string>",
"dynamic" : true,
"modifiable" : true,
"allowedValues" : "ALLOW_INVALID_DATES, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_CREATE_USER, NO_AUTO_VALUE_ON_ZERO, NO_BACKSLASH_ESCAPES, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_FIELD_OPTIONS, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PAD_CHAR_TO_FULL_LENGTH, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES",
"desc" : “ The SQL syntax and check mode."
}
]
}