Queries the results of a SQL statement diagnostic task.
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | GetRequestDiagnosisResult |
The operation that you want to perform. Set the value to GetRequestDiagnosisResult. |
InstanceId | String | No | rm-0iwhhl8gx0ld6**** |
The ID of the instance. |
NodeId | String | No | 202**** |
The ID of the node. Note For cluster instances that run engines such as MongoDB, you must provide the node
ID.
|
MessageId | String | No | 61820b594664275c4429**** |
The unique ID of the diagnostic task. You can view it by calling CreateRequestDiagnosis. |
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
Message | String | Successful |
The returned message. Note If the request is successful, Successful is returned. If the request fails, an error
message that includes an error code is returned.
|
RequestId | String | 800FBAF5-A539-5B97-A09E-C63AB2F7**** |
The ID of the request. |
Data | Object |
Response parameters |
|
messageId | String | 61820b594664275c4429**** |
The unique ID of the diagnostic task. |
uuid | String | hdm_51fe9bc19ec413f4d530431af87a**** |
The unique ID of the instance. |
accountId | String | 2093**** |
The ID of the user. |
sqlId | String | 0c95dae3afef77be06572612df9b**** |
The ID of the SQL template. |
engine | String | MySQL |
The database engine. Valid values:
|
dbSchema | String | das |
The name of the database. |
param | String | {"":""} |
The additional information. |
state | Integer | 2 |
The diagnostic status. Valid values:
|
result | String | { "endTime":1636354256000, "errorCode":"0001", "errorMessage":"TFX succeeded", "estimateCost":{ "cpu":1.7878745150389268, "io":9.948402604746128, "rows":8.889372575194633 }, "improvement":12933.97, "indexAdvices":[ { "columns":[ "work_no" ], "ddlAddIndex":"ALTER TABLE `test`.`work_order` ADD INDEX `idx_workno` (`work_no`)", "indexName":"idx_workno", "schemaName":"test", "tableName":"work_order", "unique":false } ], "ip":"****.mysql.rds.aliyuncs.com", "messageId":"6188c8cb2f1365b16aee****", "port":3306, "sqlTag":"{\"PRED_EQUAL\":\"Y\",\"CNT_QB\":\"1\",\"CNT_TB\":\"1\"}", "startTime":1636354252000, "success":true, "support":true, "tuningAdvices":[ ] } |
The SQL diagnostic result. Valid values:
|
gmtCreate | String | 1633071840000 |
The time when the SQL diagnostic task was created. This value is a UNIX timestamp. Unit: milliseconds. |
gmtModified | String | 1633071850000 |
The time when the SQL diagnostic task was modified. This value is a UNIX timestamp. Unit: milliseconds. |
Code | String | 200 |
The returned HTTP status code. |
Success | String | true |
Indicates whether the request is successful. Valid values:
|
Examples
Sample requests
http(s)://das.cn-shanghai.aliyuncs.com/?Action=GetRequestDiagnosisResult
&InstanceId=rm-0iwhhl8gx0ld6****
&NodeId=202****
&MessageId=61820b594664275c4429****
&<Common request parameters>
Sample success responses
XML
format
HTTP/1.1 200 OK
Content-Type:application/xml
<GetRequestDiagnosisResultResponse>
<Message>Successful</Message>
<RequestId>800FBAF5-A539-5B97-A09E-C63AB2F7****</RequestId>
<Data>
<messageId>61820b594664275c4429****</messageId>
<uuid>hdm_51fe9bc19ec413f4d530431af87a****</uuid>
<accountId>2093****</accountId>
<sqlId>0c95dae3afef77be06572612df9b****</sqlId>
<engine>MySQL</engine>
<dbSchema>das</dbSchema>
<param>{"":""}</param>
<state>2</state>
<result>{ "endTime":1636354256000, "errorCode":"0001", "errorMessage":"TFX succeeded", "estimateCost":{ "cpu":1.7878745150389268, "io":9.948402604746128, "rows":8.889372575194633 }, "improvement":12933.97, "indexAdvices":[ { "columns":[ "work_no" ], "ddlAddIndex":"ALTER TABLE `test`.`work_order` ADD INDEX `idx_workno` (`work_no`)", "indexName":"idx_workno", "schemaName":"test", "tableName":"work_order", "unique":false } ], "ip":"****.mysql.rds.aliyuncs.com", "messageId":"6188c8cb2f1365b16aee****", "port":3306, "sqlTag":"{\"PRED_EQUAL\":\"Y\",\"CNT_QB\":\"1\",\"CNT_TB\":\"1\"}", "startTime":1636354252000, "success":true, "support":true, "tuningAdvices":[ ] }</result>
<gmtCreate>1633071840000</gmtCreate>
<gmtModified>1633071850000</gmtModified>
</Data>
<Code>200</Code>
<Success>true</Success>
</GetRequestDiagnosisResultResponse>
JSON
format
HTTP/1.1 200 OK
Content-Type:application/json
{
"Message" : "Successful",
"RequestId" : "800FBAF5-A539-5B97-A09E-C63AB2F7****",
"Data" : {
"messageId" : "61820b594664275c4429****",
"uuid" : "hdm_51fe9bc19ec413f4d530431af87a****",
"accountId" : "2093****",
"sqlId" : "0c95dae3afef77be06572612df9b****",
"engine" : "MySQL",
"dbSchema" : "das",
"param" : "{\"\":\"\"}",
"state" : 2,
"result" : "{ \"endTime\":1636354256000, \"errorCode\":\"0001\", \"errorMessage\":\"TFX succeeded\", \"estimateCost\":{ \"cpu\":1.7878745150389268, \"io\":9.948402604746128, \"rows\":8.889372575194633 }, \"improvement\":12933.97, \"indexAdvices\":[ { \"columns\":[ \"work_no\" ], \"ddlAddIndex\":\"ALTER TABLE `test`.`work_order` ADD INDEX `idx_workno` (`work_no`)\", \"indexName\":\"idx_workno\", \"schemaName\":\"test\", \"tableName\":\"work_order\", \"unique\":false } ], \"ip\":\"****.mysql.rds.aliyuncs.com\", \"messageId\":\"6188c8cb2f1365b16aee****\", \"port\":3306, \"sqlTag\":\"{\\\"PRED_EQUAL\\\":\\\"Y\\\",\\\"CNT_QB\\\":\\\"1\\\",\\\"CNT_TB\\\":\\\"1\\\"}\", \"startTime\":1636354252000, \"success\":true, \"support\":true, \"tuningAdvices\":[ ] }",
"gmtCreate" : "1633071840000",
"gmtModified" : "1633071850000"
},
"Code" : "200",
"Success" : "true"
}
Error codes
HTTP status code | Error code | Error message | Description |
---|---|---|---|
400 | InvalidParams | The request parameters are invalid. | The error message returned because the specified request parameters are invalid. |
For a list of error codes, visit the API Error Center.