Obtaining Default Parameters of a DB Instance

Function

This API is used to obtain default parameters of a specified DB instance.

URI

• URI format

  PATH: /v1.0/{project_id}/instances/{instanceId}/configuration

  Method: GET

• Parameter description

  Table 1 Parameter description

  Name	Mandatory	Description
  project_id	Yes	Specifies the project ID of a tenant in a region.
  instanceId	Yes	Specifies the DB instance ID.

• Restrictions

  Currently, only the DB engines MySQL and PostgreSQL are supported by the API.

Request

None

Normal Response

• Parameter description

  Table 2 Parameter description

  Name	Type	Description
  instance	List data structure. For details, see Table 3.	Indicates the parameter information of the specified DB instance.

  Table 3 instance field data structure description

  Name	Type	Description
  configuration	Dictionary data structure. For details, see Table 4.	Indicates the default parameter value.

  Table 4 configuration field data structure description

  Name	Type	Description
  key	String	Indicates the parameter name. For example, in "max_connections": "10", the key is max_connections.
  value	String	Indicates the parameter value. For example, in "max_connections": "10", the value is 10.

• Response example

  {
      "instance": {
          "configuration": {
              "basedir": "/usr",
              "connect_timeout": "15",
              "datadir": "/var/lib/mysql",
              "default_storage_engine": "innodb",
              "innodb_buffer_pool_size": "600M",
              "innodb_data_file_path": "ibdata1:10M:autoextend",
              "innodb_file_per_table": "1",
              "innodb_log_buffer_size": "25M",
              "innodb_log_file_size": "50M",
              "innodb_log_files_in_group": "2",
              "join_buffer_size": "1M",
              "key_buffer_size": "200M",
              "local-infile": "0",
              "max_allowed_packet": "4096K",
              "max_connections": "400",
              "max_heap_table_size": "64M",
              "max_user_connections": "400",
              "myisam-recover": "BACKUP",
              "open_files_limit": "2048",
              "pid_file": "/var/run/mysqld/mysqld.pid",
              "port": "3306",
              "query_cache_limit": "1M",
              "query_cache_size": "32M",
              "query_cache_type": "1",
              "read_buffer_size": "512K",
              "read_rnd_buffer_size": "512K",
              "server_id": "334596",
              "skip-external-locking": "1",
              "sort_buffer_size": "1M",
              "table_definition_cache": "1024",
              "table_open_cache": "1024",
              "thread_cache_size": "16",
              "thread_stack": "192K",
              "tmp_table_size": "64M",
              "tmpdir": "/var/tmp",
              "user": "mysql",
              "wait_timeout": "120"
          }
  }
  }

Abnormal Response

For details, see Abnormal Request Results.