Queries optimization suggestions that are generated by the SQL diagnostics feature of Database Autonomy Service (DAS).
The SQL diagnostics feature provides optimization suggestions for instances based on diagnostic results. You can use the optimization suggestions to optimize instance indexes. For more information, see Automatic SQL optimization.
Before you call this operation, make sure that the following requirements are met:
- This operation can be used only for ApsaraDB RDS for MySQL instances and PolarDB for MySQL clusters.
- If you use an Alibaba Cloud SDK, make sure that the aliyun-sdk-core version is V4.3.3 or later. We recommend that you use the latest version.
- The version of DAS SDK must be 1.0.8 or later.
- If you use an SDK to call the DAS service, you must set the region to cn-shanghai.
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | GetSqlOptimizeAdvice |
The operation that you want to perform. Set the value to GetSqlOptimizeAdvice. |
ConsoleContext | String | No | None |
A reserved parameter. |
Engine | String | No | MySQL |
The database engine. Valid values:
|
InstanceIds | String | No | rm-2ze1jdv45i7l6**** |
The ID of the instance. Note The instance must be an ApsaraDB RDS for MySQL instance or a PolarDB for MySQL cluster.
|
StartDt | String | No | 20210916 |
The start of the date range during which SQL suggestions are generated. Specify the date in the yyyyMMdd format. The time must be in UTC. Note
|
EndDt | String | No | 20210917 |
The end of the date range during which SQL suggestions are generated. Specify the date in the yyyyMMdd format. The time must be in UTC. Note
|
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
Code | String | 200 |
The returned HTTP status code. |
Message | String | Successful |
The message that is returned for the request. Note If the request is successful, Successful is returned. If the request fails, an error
message that contains information such as an error code is returned.
|
Data | Object |
The detailed information, including the error codes and the number of error messages. |
|
Status | String | FINISH |
The status of the task. Valid values:
|
StatusCode | String | SUCCESS |
The status code of the task. Valid values:
|
DownloadUrl | String | https://das-sql-optimize.oss-cn-shanghai.aliyuncs.com/adb/oss_sql_optimize_advice/1083******* |
The URL used to download the file. |
CreateTime | String | 1632303861000 |
The time when the task was created. This value is a UNIX timestamp. Unit: milliseconds. |
ExpireTime | String | 1632563061000 |
The time when the file expires. This value is a UNIX timestamp. Unit: milliseconds. Note The file expires three days after the task is created.
|
TaskId | String | 2021091710461519216**** |
The ID of the task. |
RequestId | String | B6D17591-B48B-4D31-9CD6-9B9796B2**** |
The ID of the request. |
Success | String | true |
Indicates whether the request is successful. Valid values:
|
Examples
Sample requests
http(s)://das.cn-shanghai.aliyuncs.com/?Action=GetSqlOptimizeAdvice
&Engine=MySQL
&InstanceIds=rm-2ze1jdv45i7l6****
&StartDt=20210916
&EndDt=20210917
&Common request parameters
Sample success responses
XML
format
HTTP/1.1 200 OK
Content-Type:application/xml
<GetSqlOptimizeAdviceResponse>
<Code>200</Code>
<Message>Successful</Message>
<Data>
<Status>FINISH</Status>
<StatusCode>SUCCESS</StatusCode>
<DownloadUrl>https://das-sql-optimize.oss-cn-shanghai.aliyuncs.com/adb/oss_sql_optimize_advice/1083*******</DownloadUrl>
<CreateTime>1632303861000</CreateTime>
<ExpireTime>1632563061000</ExpireTime>
<TaskId>2021091710461519216****</TaskId>
</Data>
<RequestId>B6D17591-B48B-4D31-9CD6-9B9796B2****</RequestId>
<Success>true</Success>
</GetSqlOptimizeAdviceResponse>
JSON
format
HTTP/1.1 200 OK
Content-Type:application/json
{
"Code" : "200",
"Message" : "Successful",
"Data" : {
"Status" : "FINISH",
"StatusCode" : "SUCCESS",
"DownloadUrl" : "https://das-sql-optimize.oss-cn-shanghai.aliyuncs.com/adb/oss_sql_optimize_advice/1083*******",
"CreateTime" : "1632303861000",
"ExpireTime" : "1632563061000",
"TaskId" : "2021091710461519216****"
},
"RequestId" : "B6D17591-B48B-4D31-9CD6-9B9796B2****",
"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.