# Obtaining a Parameter List

#### Function

This API is used to obtain all the parameters that can be modified of the current database version.

#### URI

- URI format

  PATH: /rds/v1/{project_id}/datastores/versions/{datastore_version_id}/parameters

  Method: GET

- Parameter description

  Table 1 Parameter description
  Name | Mandatory | Description
  --- | --- | ---
  project_id | Yes | Specifies the project ID of a tenant in a region.
  datastore_version_id | Yes | Specifies the database version ID (dataStores.id in the response message in Database Version Queries).

#### Request

None

#### Normal Response

- Parameter description

  Table 2 Parameter description
  Name | Type | Description
  --- | --- | ---
  configuration-parameters | List data structure. For details, see Table 3. | Indicates all the parameters that can be modified of the database version.

  Table 3 configuration-parameters field data structure description
  Name | Type | Description
  --- | --- | ---
  name | String | Indicates the parameter name.
  min | String | Indicates the minimum value. Returned only when type is integer or float.
  max | String | Indicates the maximum value. Returned only when type is integer or float.
  type | String | Indicates the parameter type. The value can be integer, string, boolean, float, or list.
  value_range | String | Specifies the parameter value range and enumerated value.
  description | String | Indicates the parameter description.
  restart_required | Boolean | Indicates whether the instance needs to reboot for the parameter to take effect. The value is true or false.
  datastore_version_id | String | Indicates the database version ID.

- Response example

      {
        "configuration-parameters" : [ {
          "name" : "autocommit",
          "type" : "boolean",
          "value_range" : "ON|OFF",
          "description" : "The autocommit mode. If set to ON, all changes to a table take effect immediately. If set to OFF, you must use COMMIT to accept a transaction or ROLLBACK to cancel it. ",
          "restart_required" : false,
          "datastore_version_id" : "e8a8b8cc-63f8-4fb5-8d4a-24c502317a61"
        }, {
          "name" : "auto_increment_increment",
          "min" : "1",
          "max" : "65535",
          "type" : "integer",
          "value_range": "1-65535",
          "description" : "auto_increment_increment and auto_increment_offset are intended for use with master-to-master replication, and can be used to control the operation of AUTO_INCREMENT columns.",
          "restart_required" : false,
          "datastore_version_id" : "e8a8b8cc-63f8-4fb5-8d4a-24c502317a61"
        }, {
          "name" : "auto_increment_offset",
          "min" : "1",
          "max" : "65535",
          "type" : "integer",
          "value_range": "1-65535",
          "description" : "auto_increment_increment and auto_increment_offset are intended for use with master-to-master replication, and can be used to control the operation of AUTO_INCREMENT columns. ",
          "restart_required" : false,
          "datastore_version_id" : "e8a8b8cc-63f8-4fb5-8d4a-24c502317a61"
        }, {
          "name" : "back_log",
          "min" : "1",
          "max" : "65535",
          "type" : "integer",
          "value_range": "1-65535",
          "description" : "The number of outstanding connection requests MySQL can have. This comes into play when the main MySQL thread gets very many connection requests in a very short time. It then takes some time (although very little) for the main thread to check the connection and start a new thread. The back_log value indicates how many requests can be stacked during this short time before MySQL momentarily stops answering new requests. The default value depends on system architecture.",
          "restart_required" : true,
          "datastore_version_id" : "e8a8b8cc-63f8-4fb5-8d4a-24c502317a61"
          }
        ]
      }

#### Abnormal Response

For details, see Abnormal Request Results.

Parent topic: Parameter Configuration