ClickHouse clusters in E-MapReduce (EMR) provide a comprehensive monitoring system that is used to monitor the metrics of services and nodes. This topic describes how to view the service metrics and node metrics of ClickHouse clusters.

Background information

In a ClickHouse cluster, only the ClickHouse and ZooKeeper services can be monitored. On the Cluster Metrics tab of the Monitor page, you can view the metrics of different components. You can also select a time range to view the metrics based on your business requirements.

Prerequisites

A ClickHouse cluster is created. For more information, see Create a cluster.

View service metrics

  1. Go to the Monitor page.
    1. Log on to the Alibaba Cloud EMR console.
    2. In the top navigation bar, select the region where your cluster resides and select a resource group based on your business requirements.
    3. Click the Monitor tab.
  2. Click the Cluster Metrics tab.
  3. View the metrics of the ZooKeeper and ClickHouse services.
    • Click HOST and click ZOOKEEPER. Zookeeper
    • Click HOST and click CLICKHOUSE.

      The metrics of the ClickHouse service are obtained from three system tables of ClickHouse: metrics, events, and asynchronous_metrics.

View node metrics

You can view the node deployment status and the detailed node information.

View the node deployment status

  1. Go to the Cluster Overview page.
    1. Log on to the Alibaba Cloud EMR console.
    2. In the top navigation bar, select the region where your cluster resides and select a resource group based on your business requirements.
    3. Click the Cluster Management tab.
    4. On the Cluster Management page, find your cluster and click Details in the Actions column.
  2. View the node deployment status of the ZooKeeper service or ClickHouse service.
    1. In the left-side navigation pane, choose Cluster Service > ZooKeeper.

      To view the node deployment status of the ClickHouse service, choose Cluster Service > ClickHouse.

    2. Click the Component Deployment tab.
      On this tab, you can view the real-time status of the processes in which the service is deployed. This way, you can monitor the status of components. Zookeeper

View the detailed metric data

  1. Go to the Monitor page.
    1. Log on to the Alibaba Cloud EMR console.
    2. In the top navigation bar, select the region where your cluster resides and select a resource group based on your business requirements.
    3. Click the Monitor tab.
  2. Click the Cluster Metrics tab.
  3. Select the ID of the cluster that you created from the clusterid drop-down list and select one or more nodes from the hostname drop-down list.

    You can view the metrics of the selected nodes, such as the metrics related to loads, disks, memory, networks, and TCP.

    Cluster ID