百度智能云

All Product Document

          Relational Database Service

          Get Parameter List

          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 PositionDescription
          versionstringYesURL parameterAPI Version Number
          instanceIdstringYesURL parameterInstance ID

          Return Header Field

          Parameter Name Type Description
          ETagstringFor 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."
                  }
              ]
          }
          Previous
          Modify Configuration Parameters