Help Center/ Data Admin Service/ User Guide/ GaussDB/ Intelligent O&M/ Performance/ Multiple Nodes with a Single Metric
Updated on 2024-11-28 GMT+08:00

Multiple Nodes with a Single Metric

This function allows you to view the same metric of multiple instances so that you can compare performance of different instances at a specific point of time.

Procedure

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane, choose Intelligent O&M > Instance List.

    Alternatively, on the Overview page, click Go to Intelligent O&M.

  5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.

    Figure 1 Searching for instances

  6. Select the instance whose metrics you want to view and click Details.
  7. Choose Performance > Multiple Nodes with Single Metric.
  8. Click Select Node to select instances.

    You can select a maximum of five nodes of the same type.

  9. Click Select Metric and select the instance metrics to display.

    Table 1 Node metrics

    Category

    Metric

    Description

    CPU

    CPU Usage

    CPU usage of the monitored object (Unit: %)

    CPU Load

    Average CPU load over the past 1, 5, and 15 minutes. The value is obtained using the w command.

    CPU Load in Past 1 Minute

    Average CPU load over the past 1 minute. The value is obtained using the w command.

    Memory

    Memory Usage

    Memory usage of the monitored object (Unit: %)

    Available Memory

    Memory available to the operating system (Unit: GB)

    Network

    Data Transfer In

    Average number of bytes sent by the VM of the monitored object in a measurement period (Unit: KB/s)

    Data Transfer Out

    Average number of bytes received by the VM of the monitored object in a measurement period (Unit: KB/s)

    Disk Usage

    System Disk Usage

    Real-time larger value between usages of disks / and /var/log on the monitored node (Unit: %)

    Used Disk Space

    Real-time data disk usage of the monitored node. For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: GB)

    Total Disk Space

    Real-time total data disk size of the monitored node. For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: GB)

    Disk Usage

    Real-time data disk usage on the monitored instance For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: %)

    Log Disk Used Space

    Used space of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: GB)

    Log Disk Total Space

    Total space of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: GB)

    Log Disk Usage

    Usage of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: %)

    ETCD Disk Usage

    Usage of disk in /var/chroot/usr/local/etcd on the current node. This metric is available only for GaussDB Centralized.

    Total swap space, which can be queried via the free -m command

    Total swap space, which can be queried via the free -m command

    Swap usage, which can be queried via the free -m command

    Swap usage, which can be queried via the free -m command

    Inode usage, which can be queried via the df -i command

    Inode usage, which can be queried via the df -i command

    I/O

    Disk IOPS

    Real-time value of data disk reads and writes per second of the monitored node For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: Count/s)

    Log Disk IOPS

    IOPS of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: Count/s)

    Disk Write Throughput

    Real-time write throughput per second of the data disk on the monitored node For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: KB/s)

    Disk Read Throughput

    Real-time read throughput per second of the data disk on the monitored node For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: KB/s)

    Log Disk Write Throughput

    Write throughput of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: KB/s)

    Log Disk Read Throughput

    Read throughput of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: KB/s)

    Time Required for per Disk Write

    Average time required for a data disk write on the monitored node For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: ms)

    Time Required for per Disk Read

    Average time required for a data disk read on the monitored node For GaussDB Distributed, the disk in /var/chroot/var/lib/engine/data of data nodes is monitored, and the disk in /var/chroot/usr/local of other nodes is monitored. For GaussDB Centralized, only data disks of data nodes are monitored. (Unit: ms)

    Max. Log Disk Seconds per Write

    Seconds per write of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: ms)

    Max. Log Disk Seconds per Read

    Seconds per read of the disk in /var/chroot/var/lib/log of a monitored node. This metric will be updated in real time only for GaussDB Distributed. (Unit: ms)

    Process Status

    om_agent Status

    Whether the om_agent process exists on the current node

    om_monitor Status

    Whether the om_monitor process exists on the current node

    dbmanager Status

    Whether the dbmanager process exists on the current node

    watchdog Status

    Whether the watchdog process exists on the current node

    agentmonitor Status

    Whether the agentmonitor process exists on the current node

    Semaphore

    Semaphore format. Ipcs -s | wc -1

    Semaphore format. Ipcs -s | wc -1

    Password

    Password Expiration Time

    Password expiration time for accounts Ruby and root.

    You can also perform the following operations:

    • Click Performance History and specify a time range in the upper right corner to view metric details in the last 1 hour, 12 hours, 1 day, 2 days, or 7 days.

      You can also select a metric, click Details in the upper right corner of the graph, and specify a time range in the upper right corner to view metric details in the last 1 hour, 12 hours, 1 day, 2 days, or 7 days.

    • Click the Performance Trends Comparisons tab, select the metrics you want to view, and click OK.

      You can also select the comparison time in the upper right corner of the Performance Trends Comparisons tab page.

    • Enable Interactive Graph to view other metrics.
    • Click Full Screen for a clear view.