Home PagePolarDBPolarDB for XscaleUser GuideMonitoring and alertMonitor columnstore resources
Search for Help Content

Monitor columnstore resources

Updated at: 2024-05-31 01:44
Product
Community

This topic describes how to view the monitoring information of columnstore resources in the PolarDB-X console.

Procedure

  1. Log on to the PolarDB-X for Xscale console.

  2. In the top navigation bar, select the region where the instance you want to manage is deployed.

  3. On the Instances page, click the PolarDB-X 2.0 tab.

  4. Find the instance and click its name.

  5. In the left-side navigation pane, choose Monitoring and Alerting > Columnstore Resource Monitoring.

  6. On the Columnstore Resource Monitoring page, you can view the metrics for your cluster and nodes. The following table describes the metrics.

Metric

Description

CPU Utilization

The CPU utilization of each column store node. Unit: percentage.

Memory Utilization

The memory utilization of each column store node. Unit: percentage.

IMCIs

The total number of in-memory column indexes (IMCIs) in the instance.

IMCI Partitions

The total number of IMCI partitions in the instance.

Synchronization Throughput

The throughput at which data is synchronized to columnar storage based on the binary logs. Unit: bytes/s.

Synchronized Rows

The number of rows of data synchronized to columnar storage.

Synchronization Delay

The binlog event synchronization delay. Unit: milliseconds.

Backend Compaction Tasks

The number of real-time backend compaction tasks that are performed in columnar storage.

Binlog Event Synchronization Throughput

The number of binlog events consumed by columnar storage.

Binlog Reception Delay

The binlog event reception delay. Unit: milliseconds.

  • To view the metrics of your cluster, click the Cluster tab. Specify the time range within which the metrics that you want to view are collected and click OK.

  • To view the metrics of a node, click the Node tab. Select the desired column store node from the drop-down list, specify the time range within which the metrics that you want to view are collected, and then click OK.

Previous: Log resource monitoringNext: Configure alert rules
  • On this page （1, T）
  • Procedure
Feedback
phone Contact Us

Chat now with Alibaba Cloud Customer Service to assist you in finding the right products and services to meet your needs.

alicare alicarealicarealicare