View common resource usage for your ApsaraDB for ClickHouse cluster through the ApsaraDB for ClickHouse console or the CloudMonitor console.
Prerequisites
-
The cluster is a Community-compatible Edition or Enterprise Edition cluster.
-
Application Real-Time Monitoring Service (ARMS) manages alerts for ApsaraDB for ClickHouse. If you are a RAM user, you must have the AliyunARMSFullAccess permission. For more information about how to grant permissions, see Manage RAM user permissions.
Limitations
-
You cannot view monitoring information for Enterprise Edition clusters in CloudMonitor.
-
For Community-compatible Edition clusters that were purchased before December 1, 2021, you must manually enable Prometheus for Alibaba Cloud. To do this, go to the Cluster Monitoring page and click Upgrade ClickHouse.
ImportantThis operation restarts the ClickHouse nodes and ZooKeeper nodes. We recommend that you perform this operation during off-peak hours or when data writes are stopped.
Procedure
ApsaraDB for ClickHouse console
-
Log on to the ApsaraDB for ClickHouse console.
-
In the upper-left corner, select the region where your cluster is located.
-
On the Clusters page, click the Clusters of Community-compatible Edition tab or the Enterprise Edition Instances tab, and then click the ID of your cluster.
-
In the left-side navigation pane, click Monitoring and Alerting.
-
On the Monitoring Details page, click Cluster Monitoring.
Note-
By default, the page displays resource usage for the cluster for the last hour.
-
For information about the metrics for Community-compatible Edition clusters purchased before December 1, 2021, see Metrics for earlier-version clusters.
-
For information about the metrics for Community-compatible Edition clusters purchased after December 1, 2021, see Metrics for ApsaraDB for ClickHouse clusters.
-
CloudMonitor console
-
Log on to the CloudMonitor console.
-
In the left-side navigation pane, choose Cloud Service Monitoring > Cloud Service Monitoring.
-
On the Dashboards page, click Database.
-
In the Database section, select a product name.
Parameter
Description
ApsaraDB for ClickHouse
Community-compatible Edition clusters of ApsaraDB for ClickHouse purchased before December 1, 2021.
Clickhouse Community-compatible Edition
Community-compatible Edition clusters of ApsaraDB for ClickHouse purchased after December 1, 2021.
-
In the upper-left corner, select the cluster's region.
-
Click the target cluster's ID to view its metrics.
Note-
By default, the page displays monitoring information for the cluster for the last hour.
-
You can query up to 30 days of monitoring information at a time.
-
For more information about the ClickHouse metrics, see Appendix 1: Cloud service monitoring metrics.
-
FAQ
Q: Why do CPU utilization and memory usage vary significantly between nodes?
In a dual-replica or single-replica multi-node cluster, the write node has higher CPU usage and memory usage than other nodes during heavy write operations. Usage balances out across the nodes once the data is synchronized.
Q: Why are there gaps in the monitoring data?
Common causes include:
-
A query triggering an OOM error.
-
An instance restart triggered by a configuration change.
-
An instance restart following an upgrade or downgrade.
API reference
Related documentation
If you are new to CloudMonitor, see What is CloudMonitor?.