Mengonfigurasi parameter terkait fitur Pembatasan SQL otomatis untuk beberapa Instansiasi basis data secara asinkron sekaligus.
Deskripsi operasi
Asynchronous calls do not immediately return the complete results. To obtain the complete results, you must use the value of ResultId returned in the response to re-initiate the call until the value of isFinish is true.**** In this case, you must call this operation at least twice.
Before you call this operation, take note of the following items:
-
If you use an SDK to call API operations of Database Autonomy Service (DAS), you must set the region ID to cn-shanghai.
-
The autonomy service must be enabled for the database instance that you want to manage. For more information, see Autonomy center.
-
The database instance that you want to manage must be of one of the following types:
-
ApsaraDB RDS for MySQL High-availability Edition or Enterprise Edition that runs MySQL 5.6, MySQL 5.7, or MySQL 8.0
-
PolarDB for MySQL Cluster Edition that runs MySQL 5.6, MySQL 5.7, or MySQL 8.0
-
Coba sekarang
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
hdm:UpdateAutoThrottleRulesAsync |
none |
*All Resource
|
None | None |
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| ConsoleContext |
string |
No |
Parameter yang dicadangkan. |
None |
| InstanceIds |
string |
Yes |
ID Instansiasi basis data. Catatan
Tetapkan parameter ini ke array JSON yang terdiri dari beberapa ID instans. Pisahkan ID instans dengan koma (,). Contoh: |
['rm-2ze8g2am97624****','rm-2ze9xrhze0709****'] |
| CpuUsage |
number |
Yes |
Ambang batas untuk penggunaan CPU. Nilai valid: 70% hingga 100%. |
70 |
| CpuSessionRelation |
string |
Yes |
Hubungan logis antara ambang batas penggunaan CPU dan jumlah maksimum sesi aktif. Nilai valid:
|
OR |
| ActiveSessions |
integer |
Yes |
Ambang batas untuk jumlah sesi aktif.
|
16 |
| AbnormalDuration |
number |
Yes |
Ambang batas durasi untuk memicu Pembatasan SQL otomatis. Tetapkan parameter ini ke bilangan bulat yang lebih besar dari atau sama dengan 2. Unit: menit. |
2 |
| MaxThrottleTime |
number |
Yes |
Durasi Pembatasan kecepatan maksimum. Tetapkan parameter ini ke bilangan bulat positif. Unit: menit. |
10 |
| AllowThrottleStartTime |
string |
Yes |
Waktu mulai jendela Pembatasan kecepatan. Waktu harus dalam format UTC. |
00:00Z |
| AllowThrottleEndTime |
string |
Yes |
Waktu berakhir jendela Pembatasan kecepatan. Waktu harus dalam format UTC. |
23:59Z |
| AutoKillSession |
boolean |
Yes |
Apakah akan menghentikan tugas pernyataan SQL abnormal yang sedang dieksekusi pada waktu yang sama. Nilai valid: Catatan
Pernyataan SQL abnormal menggunakan template yang sama dengan pernyataan SQL yang akan dibatasi.
|
true |
| ResultId |
string |
No |
ID permintaan asinkron. Catatan
Anda dapat mengosongkan parameter ini saat memanggil operasi untuk memulai permintaan pertama kali, lalu menggunakan nilai parameter ini yang terdapat dalam tanggapan permintaan pertama untuk permintaan berikutnya. |
async__507044db6c4eadfa2dab9b084e80**** |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
|||
| Code |
integer |
The HTTP status code returned. |
200 |
| Message |
string |
The returned message. Catatan
If the request was successful, Successful is returned. If the request failed, an error message such as an error code is returned. |
Successful |
| Data |
object |
The data returned. |
|
| Fail |
boolean |
Indicates whether the asynchronous request failed. Valid values:
|
false |
| ConfigResponse |
object |
The returned data of the configuration. Catatan
The data is returned only if the value of isFinish is true. This value indicates that the asynchronous request is complete. |
|
| TotalInstanceCount |
integer |
The total number of database instances. |
2 |
| ConfigSuccessInstanceCount |
integer |
The number of database instances for which the parameters are configured. |
1 |
| ConfigFailInstanceCount |
integer |
The number of database instances for which the parameters failed to be configured. |
1 |
| ConfigSuccessInstanceList |
array<object> |
The database instances for which the parameters are configured. |
|
|
object |
|||
| ConfigSuccess |
boolean |
Indicates whether the parameters are configured. Valid values:
|
true |
| InstanceId |
string |
The database instance ID. |
rm-2ze8g2am97624**** |
| ConfigFailInstanceList |
array<object> |
The database instances for which the parameters failed to be configured. |
|
|
object |
|||
| ConfigSuccess |
boolean |
Indicates whether the parameters are configured. Valid values:
|
false |
| InstanceId |
string |
The database instance ID. |
rm-2ze9xrhze0709**** |
| ErrorMessage |
string |
The error message returned. |
instance das autonomy service is off or can not find instance |
| ResultId |
string |
The ID of the asynchronous request. |
async__665ee69612f1627c7fd9f3c85075**** |
| IsFinish |
boolean |
Indicates whether the asynchronous request was complete. Valid values:
|
true |
| State |
string |
The state of the asynchronous request. Valid values:
|
SUCCESS |
| Complete |
boolean |
Indicates whether the asynchronous request was complete. Valid values:
|
true |
| Timestamp |
integer |
The time when the asynchronous request was made. This value is a UNIX timestamp representing the number of milliseconds that have elapsed since January 1, 1970, 00:00:00 UTC. |
1645668213000 |
| RequestId |
string |
The request ID. |
B6D17591-B48B-4D31-9CD6-9B9796B2**** |
| Success |
boolean |
Indicates whether the request was successful. Valid values:
|
true |
Contoh
Respons sukses
JSONformat
{
"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": "instance das autonomy service is off or can not find instance"
}
]
},
"ResultId": "async__665ee69612f1627c7fd9f3c85075****",
"IsFinish": true,
"State": "SUCCESS",
"Complete": true,
"Timestamp": 1645668213000
},
"RequestId": "B6D17591-B48B-4D31-9CD6-9B9796B2****",
"Success": true
}
Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | InvalidParams | The request parameters are invalid. | |
| 403 | NoPermission | You are not authorized to do this action. |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.