Monitoring for MariaDB Xpand

Overview

MariaDB Xpand provides all of the information necessary for monitoring the deployment. The system database contains low-level information about all portions of the deployment, 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 top should not be used on Xpand to monitor node status, as their results may not be reliable.

Current Sessions

MariaDB Xpand provides a system.sessions system table that can be used to monitor current sessions.

The following query will list all sessions in the deployment:

SELECT * FROM system.sessions;

Example output:

*************************** 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

Monitoring CPU Load

MariaDB Xpand provides a SHOW LOAD statement that can be used to monitor 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 deployment, CPU core 0 is used for specific tasks, and therefore omitted from the load average when calculating the overall load.

Disk read and write values are calculated as a percentage using estimated maximums for solid state drives and might exceed 100% under certain conditions.

Monitoring Space Utilization per Table

MariaDB Xpand provides a system.table_sizes system table that can be used to monitor the size of Xpand tables.

The system.table_sizes table shows the size in bytes of each table in every database, including indexes, replicas, and row data. The value in the size column represents total storage on disk, rather than just the size of the data.

Monitoring Data Rebalancing Activity

MariaDB Xpand continuously monitors how data is distributed in the deployment. 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.