Mengkueri data performa kluster AnalyticDB for MySQL.
Deskripsi operasi
You can call this operation to query the performance data of a cluster over a time range based on its performance metrics. The data is collected every 30 seconds. This operation allows you to query information about slow queries, such as the SQL query duration, number of scanned rows, and amount of scanned data.
Coba sekarang
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
adb:DescribeDBClusterPerformance |
list |
*All Resource
|
None | None |
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| DBClusterId |
string |
Yes |
ID kluster AnalyticDB for MySQL. Catatan
Anda dapat memanggil operasi DescribeDBClusters untuk mengkueri ID semua kluster AnalyticDB for MySQL dalam suatu wilayah. |
am-************ |
| Key |
string |
No |
Kunci data deret waktu performa yang ingin Anda kueri. Pisahkan beberapa kunci dengan koma (,). Untuk informasi selengkapnya tentang data deret waktu performa, lihat Ikhtisar data deret waktu. |
AnalyticDB_CPU |
| StartTime |
string |
No |
Waktu mulai kueri. Tentukan waktu dalam standar ISO 8601 dengan format yyyy-MM-ddTHH:mmZ. Waktu harus dalam UTC. |
2021-05-03T15:00Z |
| EndTime |
string |
No |
Waktu akhir kueri. Tentukan waktu dalam standar ISO 8601 dengan format yyyy-MM-ddTHH:mmZ. Waktu harus dalam UTC. Catatan
Waktu akhir harus lebih lambat daripada waktu mulai. Rentang waktu maksimum yang dapat ditentukan adalah dua hari. |
2021-05-03T15:01Z |
| RegionId |
string |
Yes |
ID wilayah kluster. |
cn-hangzhou |
| ResourcePools |
string |
No |
Nama kelompok sumber daya. |
test |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
The response parameters. |
||
| EndTime |
string |
The end time of the query. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC. |
2021-05-03T15:01:00Z |
| RequestId |
string |
The request ID. |
25B56BC7-4978-40B3-9E48-4B7067****** |
| StartTime |
string |
The start time of the query. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC. |
2021-05-03T15:00:00Z |
| DBClusterId |
string |
The cluster ID. |
am-************ |
| Performances |
array<object> |
The queried performance metrics. |
|
|
array<object> |
The queried performance metric. |
||
| Key |
string |
The name of the performance metric. |
AnalyticDB_CPU |
| Unit |
string |
The unit of the performance metric. |
% |
| Series |
array<object> |
The queried performance metric data. |
|
|
object |
The queried performance metric data. |
||
| Values |
array |
The values of the queried performance metric. |
|
|
string |
The value of the performance metric at a specific point in time. |
[ "2021-05-03T15:00:12.72Z", "0.1250" ], [ "2021-05-03T15:00:42.739Z", "0.3125" ] |
|
| Name |
string |
The name of the performance metric value. For more information about the performance metrics, see Metric overview. |
worker_avg_cpu_used |
| Tags |
string |
The tags that are added to the cluster. |
instance_name: "amv-8vbf80pjcz*****" |
| TranslateKey |
string |
The key that is used to obtain the name of the performance metric value. |
elastic_executor_avg_cpu_use |
| AccessDeniedDetail |
string |
The information about the request denial. This parameter is returned only if Resource Access Management (RAM) permission verification failed. |
{ "AuthAction": "xxx", "AuthPrincipalDisplayName": "sampleName", "AuthPrincipalOwnerId": "111111111111111111", "AuthPrincipalType": "SubUser", "AuthResource": "xxx", "NoPermissionType": "xxx", "PolicyType": "xxx" } |
Contoh
Respons sukses
JSONformat
{
"EndTime": "2021-05-03T15:01:00Z",
"RequestId": "25B56BC7-4978-40B3-9E48-4B7067******",
"StartTime": "2021-05-03T15:00:00Z",
"DBClusterId": "am-************",
"Performances": [
{
"Key": "AnalyticDB_CPU",
"Unit": "%",
"Series": [
{
"Values": [
"[ \"2021-05-03T15:00:12.72Z\", \"0.1250\" ], [ \"2021-05-03T15:00:42.739Z\", \"0.3125\" ]"
],
"Name": "worker_avg_cpu_used",
"Tags": "instance_name: \"amv-8vbf80pjcz*****\"",
"TranslateKey": "elastic_executor_avg_cpu_use"
}
]
}
],
"AccessDeniedDetail": "{\n \"AuthAction\": \"xxx\",\n \"AuthPrincipalDisplayName\": \"sampleName\",\n \"AuthPrincipalOwnerId\": \"111111111111111111\",\n \"AuthPrincipalType\": \"SubUser\",\n \"AuthResource\": \"xxx\",\n \"NoPermissionType\": \"xxx\",\n \"PolicyType\": \"xxx\"\n}"
}Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | IdempotentParameterMismatch | The request uses the same client token as a previous, but non-identical request. Do not reuse a client token with different requests, unless the requests are identical. |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.