Alibaba Cloud AnalyticDB MySQL¶
Alibaba Cloud AnalyticDB MySQL metrics display, including CPU, memory, disk, coordinator nodes, instance queries, and more.
Configuration¶
Install Func¶
It is recommended to enable Guance Integration - Extensions - Managed Func
If deploying Func manually, refer to Deploy Func Manually
Enable Script Manually¶
- Log in to the Func console, click 【Script Market】, enter the Guance script market, and search for:
integration_alibabacloud_adb - Click 【Install】 and enter the required parameters: Alibaba Cloud AK ID, AK Secret, and account name.
- Click 【Deploy Startup Script】. The system will automatically create the
Startupscript set and configure the corresponding startup script. - After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to run it immediately without waiting for the scheduled time. After a short wait, you can view the execution task records and corresponding logs.
Verification¶
- In 「Manage / Automatic Trigger Configuration」, confirm that the corresponding task has an automatic trigger configuration, and check the task records and logs for any exceptions
- In Guance, check whether asset information exists in 「Infrastructure / Custom」
- In Guance, check whether corresponding monitoring data exists in 「Metrics」
Metrics¶
After configuring Alibaba Cloud AnalyticDB MySQL, the default metric set is as follows. More metrics can be collected through configuration. Alibaba Cloud Cloud Monitor Metric Details
| MetricName | MetricCategory | MetricDescribe | Dimensions | Statistics | Unit | MinPeriods |
|---|---|---|---|---|---|---|
| AutoMCQueuedQueriesCount_v5 | Resource Group Metrics | (Multi-Cluster) Queued Query Count | userId,instanceId,resourceGroup | Average | count | 60 s |
| AutoMCRunningQueriesCount_v5 | Resource Group Metrics | (Multi-Cluster) Running Query Count | userId,instanceId,resourceGroup | Average | count | 60 s |
| ColdDataDiskUsage-v5 | Basic Metrics | Cold Data Size | userId,instanceId | Average | MiB | 60 s |
| ExecutorDownCount-v5 | Basic Metrics | Elastic Compute Node Offline Count | userId,instanceId | Maximum | count | 60 s |
| HotDataDiskUsage-v5 | Basic Metrics | Hot Data Size | userId,instanceId | Average | MiB | 60 s |
| LakeCacheDirDataSize_v5 | LakeCache Metrics | Total Size of LakeCache Cached Files | userId,instanceId,dirName | Average | B | 60 s |