Asynchronously configures parameters related to the automatic fragment recycling feature for multiple database instances at a time.
Operation description
Note
UpdateAutoResourceOptimizeRulesAsync is an asynchronous operation. After a request is sent, the complete results are not returned immediately. If the value of isFinish is false in the response, wait for 1 second and then send a request again. If the value of isFinish is true, the complete results are returned.
Before you call this operation, take note of the following items:
- If you use an SDK to call the API operations of Database Autonomy Service (DAS), you must set the region ID to cn-shanghai.
- The database instances must be an ApsaraDB RDS for MySQL High-availability Edition instance.
- DAS Enterprise Edition must be enabled for the database instance. You can call the call DescribeInstanceDasPro operation to query whether DAS Enterprise Edition is enabled.
- The database instance has four or more CPU cores, and innodb_file_per_table is set to ON.
Debugging
Authorization information
There is currently no authorization information disclosed in the API.
Request parameters
Parameter | Type | Required | Description | Example |
---|---|---|---|---|
ConsoleContext | string | No | The reserved parameter. | None |
InstanceIds | string | Yes | The database instance IDs. Note
Set this parameter to a JSON array that consists of multiple instance IDs. Separate instance IDs with commas (,). Example: ['Instance ID1', 'Instance ID2'] .
| ['rm-2ze8g2am97624****','rm-2ze9xrhze0709****'] |
TableSpaceSize | double | Yes | The minimum storage usage that triggers automatic fragment recycling of a single physical table. Valid values: 5 to 100. Unit: GB. | 10 |
TableFragmentationRatio | double | Yes | The fragmentation rate that triggers automatic fragment recycling of a single physical table. Valid values: 0.10 to 0.99. | 0.2 |
ResultId | string | No | The ID of the asynchronous request. Note
You can leave this parameter empty when you call the operation to initiate the request for the first time, and use the value of this parameter contained in the response to the first request for subsequent requests.
| async__507044db6c4eadfa2dab9b084e80**** |
Response parameters
Examples
Sample success responses
JSON
format
{
"Code": 200,
"Message": "Successful",
"Data": {
"Fail": false,
"ConfigResponse": {
"TotalInstanceCount": 2,
"ConfigSuccessInstanceCount": 1,
"ConfigFailInstanceCount": 1,
"ConfigSuccessInstanceList": [
{
"ConfigSuccess": true,
"InstanceId": "rm-2ze8g2am97624****"
}
],
"ConfigFailInstanceList": [
{
"ConfigSuccess": false,
"InstanceId": "rm-2ze9xrhze0709****",
"ErrorMessage": "Only Support DAS Pro High-availability Edition RDS MySQL 5.6, 5.7, 8.0 instance, and CPU cores >= 4, innodb_file_per_table=ON"
}
]
},
"ResultId": "async__20ee808e72257f16a4fe024057ca****",
"IsFinish": true,
"State": "SUCCESS",
"Complete": true,
"Timestamp": 1645668213000
},
"RequestId": "9CB97BC4-6479-55D0-B9D0-EA925AFE****",
"Success": true
}
Error codes
HTTP status code | Error code | Error message |
---|---|---|
400 | InvalidParams | The request parameters are invalid. |
403 | NoPermission | You are not authorized to do this action. |
For a list of error codes, visit the Service error codes.
Change history
Change time | Summary of changes | Operation | ||||
---|---|---|---|---|---|---|
2023-11-17 | The Error code has changed | see changesets | ||||
|