Obtaining the Result of a Specific Diagnosis Item

Function

This API is used to obtain the result of a specific diagnosis item.

• Before calling this API, learn how to authenticate it.
• Before calling this API, learn about request header parameters.

URI

• URI format

  GET /v3/{project_id}/instances/diagnosis/info

• Parameter description

  Table 1 Parameters

  Parameter	Mandatory	Description
  project_id	Yes	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A

  Table 2 Request parameters

  Parameter	Mandatory	Type	Description
  engine	Yes	String	Definition Engine type. Constraints N/A Range mysql postgresql sqlserver Default Value N/A
  diagnosis	Yes	String	Definition Diagnosis item. Constraints N/A Range high_pressure lock_wait insufficient_capacity slow_sql_frequency disk_performance_cap mem_overrun age_exceed connections_exceed Default Value N/A
  offset	No	Integer	Definition Index offset. The query starts from the next piece of data indexed by this parameter. Constraints N/A Range The value must be a non-negative number. Default Value The default value is 0, indicating that the query starts from the first data record.
  limit	No	Integer	Definition Number of returned results. Constraints N/A Range N/A Default Value 10

Request

• Request parameters

  None

• URI example

  GET https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/diagnosis/info?engine=sqlserver&diagnosis=high_pressure&offset=1&limit=10

Response

• Normal response

  Table 3 Parameters

  Parameter	Type	Description
  diagnosis	String	Definition Diagnosis item. Range high_pressure lock_wait insufficient_capacity slow_sql_frequency disk_performance_cap mem_overrun age_exceed connections_exceed
  total_count	Integer	Definition Number of instances. Range N/A
  instances	Array of objects	Definition Specifies the DB instance ID. For details, see Table 4.

  Table 4 instances field data structure description

  Parameter	Type	Description
  id	String	Definition Specifies the DB instance ID. Range

• Example normal response

  { 
    "diagnosis" : "high_pressure", 
    "total_count" : 1, 
    "instances" : [ { 
      "id" : "abd21a25fdedfd6db69721f4b761bc38in04" 
    } ] 
  }

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.