Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 5.3

ClustrixDB Xpand provides all of the information necessary for monitoring the cluster. The system database contains low-level information about all portions of the cluster, and proprietary SQL commands return high-level summary information. The following sections describe these features in detail.

As a best practice, unix sysadmin tools such as /usr/bin/top should not be used on ClustrixDB Xpand to monitor node status, as their results may not be reliable.


The following query will list all sessions in the cluster: 

          sql> select * from system.sessions\G
*************************** 1. row ***************************
            nodeid: 1
        session_id: 1560577
         source_ip: NULL
       source_port: NULL
          local_ip: NULL
        local_port: NULL
              user: 4106
          database: NULL
         trx_state: closed
   statement_state: finished
               xid: NULL
               cpu: 3
         isolation: REPEATABLE-READ
    last_statement: delete from system.rebalancer_activity_log where finished < subdate(now(), interval @global.rebalancer_activity_log_hours * 60 minute)
   time_in_state_s: 161
           created: 2016-01-11 20:31:41
           heap_id: 288230379201751147
           trx_age: NULL
          trx_mode: autocommit
trx_counter_select: 0
trx_counter_insert: 0
trx_counter_update: 0
trx_counter_delete: 1
     trx_is_writer: 1
1 row in set (0.01 sec)  

Monitoring CPU Load

To display CPU load percentages (0 to 100) for CPU utilization, disk read/write utilization, and buffer cache miss rates, issue the SHOW LOAD command. In the cluster, CPU core 0 is used for specific tasks and therefore omitted from the load average when calculating the overall load.


Monitoring Data Rebalancing Activity

ClustrixDB Xpand continuously monitors how data is distributed in the cluster. When it detects an imbalance, it rebalances data by moving, copying, and splitting as required. Data is also copied for protective purposes, such as when a disk or node is lost.


See ClustrixGUI XpandGUI Administration UI for more information on monitoring your cluster.