MariaDB SkySQL Monitoring

Overview

The available panels are:

Panel Name

UI Tab

Scope

Panel Type

Description

Aborted Connections

status

server

singlestat

This panel shows the number of aborted connections for the ES node during the selected time interval

Adaptive Avg Select Time

cluster

server

graph

This panel shows the average time taken by the MaxScale node to perform read operations during the selected time interval

Adaptive Avg Select Time

cluster

server

stat

This panel shows the average time taken by the MaxScale node to perform read operations

Adaptive Avg Select Time

performance

server

graph

This panel shows the average time taken by the MaxScale node to perform read operations during the selected time interval

Adaptive Avg Select Time

performance

server

stat

This panel shows the average time taken by MaxScale to perform read operations

Average Network Latency

historical

server

graph

This panel shows the average network latency over the selected time interval

Average Network Latency

historical

service

graph

This panel shows the average network latency over the selected time interval

Average Network Latency in the last 24 hours (5 minute intervals)

system

service

graph

This panel shows the average network latency in 5 minute intervals over the past 24 hours

Average Network Latency over the last 24 hours (5 minute intervals)

system

server

graph

This panel shows the average network latency in 5 minute intervals over the past 24 hours

Buffer Pool Size of Total RAM

status

server

mariadb-pie-chart

This panel shows the current size of the InnoDB buffer pool for the ES node in two units: the absolute size and the percentage of the server's usable memory

Cluster Component

cluster

server

singlestat

This panel shows the status of Enterprise Cluster on the ES node

Cluster State UUID vs. Local State UUID

cluster

service

table

This panel compares the Enterprise Cluster's state UUID to each ES node's local state UUID

Connected

cluster

server

singlestat

This panel shows whether the ES node is connected to other ES nodes in the cluster over the network

Connection Pool Empty

cluster

server

graph

This panel shows the number of times that the MaxScale node's connection pool has been empty when a connection has been requested during the selected time interval

Connection Pool Empty

cluster

server

stat

This panel shows the number of times that the MaxScale node's connection pool has been empty when a connection has been requested

Connection Pool Empty

performance

server

graph

This panel shows the number of times that the MaxScale node's connection pool has been empty when a connection has been requested during the selected time interval

Connection Pool Empty

status

server

graph

This panel shows the number of times that the MaxScale node's connection pool has been empty when a connection has been requested during the selected time interval

Connection Pool Empty

status

server

stat

This panel shows the number of times that the MaxScale node's connection pool has been empty when a connection has been requested

Connections

cluster

server

singlestat

This panel shows the number of clients connected to the MaxScale node

Connections

cluster

server

stat

This panel shows the number of clients connected to the MaxScale node

Connections

status

server

stat

This panel shows the number of clients connected to the MaxScale node

Connections

status

service

table

This panel shows the number of used and aborted connections for each ES node along with the max_connections value

Connections/minute

historical

service

graph

This panel shows the total number of connection attempts (successful and unsuccessful) to the service during the selected time interval

Connections/minute in the last 24 hours

connections

service

graph

This panel shows the total number of connection attempts (successful and unsuccessful) to the service over the past 24 hours

Container Memory Distribution

historical

server

graph

This panel shows details about an Xpand node's RAM usage during the selected time interval

Container Memory Distribution in the last 24 hours (5 minute intervals)

system

server

graph

This panel shows details about an Xpand node's RAM usage in 5 minute intervals over the past 24 hours

Container Memory Hourly

system

service

graph

This panel shows details about each Xpand node's RAM usage in 1 hour intervals

Container Memory Usage

historical

service

graph

This panel shows details about each Xpand node's RAM usage during the selected time interval

Container Memory Usage in the last 24 hours (5 minute intervals)

system

service

graph

This panel shows details about each Xpand node's RAM usage in 5 minute intervals over the past 24 hours

Container Row Operations

historical

server

graph

This panel shows the number of row operations executed by the Xpand node for each type of operation during the selected time interval

Core 0 Utilization

historical

server

graph

This panel shows the CPU usage of core 0 for the Xpand node during the selected time interval

CPU

historical

server

graph

This panel shows the CPU usage for the Xpand node during the selected time interval

CPU

status

server

gauge

This panel shows the current CPU usage for the ES or Xpand node

CPU

status

server

graph

This panel shows the CPU usage for the ES or Xpand node during the selected time interval

CPU

system

service

graph

This panel shows the CPU usage for each Xpand node during the selected time interval

CPU Load

status

service

graph

This panel shows the CPU usage for each ES node during the selected time interval

CPU Load

system

service

graph

This panel shows the CPU usage for each ES node during the selected time interval

CPU Usage

historical

service

graph

This panel shows the CPU usage for each Xpand node during the selected time interval

CPU Usage / Load

system

server

graph

This panel shows the CPU usage for the ES node during the selected time interval

CPU Usage in the last 24 hours (5 minute intervals)

system

server

graph

This panel shows the CPU usage for the Xpand node in 5 minute intervals over the past 24 hours

CPU Usage over the last 24 hours (5 minute intervals)

system

service

graph

This panel shows the CPU usage for each Xpand node in 5 minute intervals over the past 24 hours

Current Average Cluster Latency - Read

queries

service

singlestat

This panel shows the average amount of time the cluster spent executing read queries before returning a result set during the selected time interval

Current Average Cluster Latency - Write

queries

service

singlestat

This panel shows the average amount of time the cluster spent executing write queries before returning a result set during the selected time interval

Current CPU Usage

system

server

gauge

This panel shows the current CPU usage for the Xpand node

Current Execution Times

queries

service

mariadb-pie-chart

This panel shows the time required to execute queries during the selected time interval

Current Memory Usage

system

server

bargauge

This panel shows the percentage of working memory currently used by the Xpand node

Current QPS

status

server

singlestat

This panel shows the number of queries per second (QPS) processed by the ES node during the selected time interval

Current Rebalancer Actions

status

service

table

This panel shows the number of times the Xpand Rebalancer executed certain tasks during the selected time interval

Current SQL Commands

status

server

mariadb-pie-chart

This panel shows the ratio between the types of SQL statements executed by the ES node during the selected time interval

Current SQL Commands

status

service

mariadb-pie-chart

This panel shows the ratio between the types of SQL statements executed by the service during the selected time interval

Current Storage

system

server

bargauge

This panel shows the percentage of storage space that is currently used by the Xpand node

Database Server Connections

cluster

server

graph

This panel shows the number of database server connections open between the MaxScale node and each ES or Xpand node during the selected time interval

Disk size

status

server

table

This panel shows the amount of storage space currently used by the ES or Xpand node

Disk size

system

service

table

This panel shows the amount of storage space currently used by the ES or Xpand node

Disk Size by Partition

status

service

table

This panel shows the amount of storage space used (as the usage percentage, actual size, and total size) by each ES node

Disk Size by Partition

system

server

graph

This panel shows the amount of storage space used by the ES node during the selected time interval

Disk Size by Partition

system

service

graph

This panel shows the amount of storage space used by all ES nodes during the selected time interval

Disk space usage

historical

service

graph

This panel shows the percentage of storage space used by each Xpand node during the selected time interval

Disk space usage in the last 24 hours (5 minute intervals)

system

service

graph

This panel shows the amount of storage space used by each Xpand node in 5 minute intervals over the past 24 hours

Errors

cluster

server

graph

This panel shows the number of errors encountered by threads on the MaxScale node during the selected time interval

Errors

performance

server

graph

This panel shows the number of errors encountered by threads on the MaxScale node during the selected time interval

Event Queue Length

cluster

server

graph

This panel shows the total event queue length for all threads on the MaxScale node during the selected time interval

Event Queue Length

performance

server

graph

This panel shows the total event queue length for all threads on the MaxScale node during the selected time interval

Exec Primary Log Position

replicas

service

graph

This panel shows the current binary log position of the replica SQL thread for each ES node during the selected time interval

Flow Control Commits

cluster

server

graph

This panel shows the sequence number of the latest writeset applied by Enterprise Cluster on the ES node during the selected time interval

Flow Control Commits

cluster

service

graph

This panel shows the sequence number of the latest writeset applied by Enterprise Cluster on all ES nodes during the selected time interval

Flow Control Pauses

cluster

server

graph

This panel shows the fraction of time that Enterprise Cluster was paused on the ES node due to flow control during the selected time interval

Flow Control Pauses

cluster

service

graph

This panel shows the fraction of time that Enterprise Cluster was paused on all ES nodes due to flow control during the selected time interval

GTID Replication Position

lags

service

graph

This panel shows the Global Transaction ID (GTID) for each ES node during the selected time interval

GTID Replication Position

replicas

service

graph

This panel shows the Global Transaction ID (GTID) for each ES node during the selected time interval

I/O Activity

status

server

graph

This panel shows the total number of bytes written to or read from the ES node's file system during the selected time interval

I/O Activity

system

server

graph

This panel shows the total number of bytes written to or read from the ES node's file system during the selected time interval

I/O Activity - Page In

system

service

graph

This panel shows the total number of bytes read from the ES node's file system during the selected time interval

I/O Activity - Page Out

system

service

graph

This panel shows the total number of bytes written to the ES node's file system during the selected time interval

I/O Latency

historical

server

graph

This panel shows the latency for I/O operations performed by the Xpand node during the selected time interval

I/O Latency

historical

service

graph

This panel shows the latency for I/O operations performed by all Xpand nodes during the selected time interval

I/O Latency in the last 24 hours (5 minute intervals)

system

service

graph

This panel shows the latency for I/O operations performed by all Xpand nodes in 5 minute intervals over the past 24 hours

I/O Latency over the last 24 hours (5 minute intervals)

system

server

graph

This panel shows the latency for I/O operations performed by the Xpand node in 5 minute intervals over the past 24 hours

InnoDB Data / sec

status

server

graph

This panel shows the number of bytes per second read and written by InnoDB during the selected time interval

InnoDB Data / sec

system

server

graph

This panel shows the number of bytes per second read and written by InnoDB during the selected time interval

Integrity of clusters (Split Brain)

cluster

service

table

This panel shows Enterprise Cluster metadata that can help determine the integrity of the cluster

IOPS

system

server

graph

This panel shows the number of input/output operations per second performed by the ES node during the selected time interval

IOPS - Page In

system

service

graph

This panel shows the total number of reads performed from the ES node's file system during the selected time interval

IOPS - Page Out

system

service

graph

This panel shows the total number of writes performed from the ES node's file system during the selected time interval

Local Received Queue

cluster

server

graph

This panel shows details about the size of the Enterprise Cluster receive queue on the ES node during the selected time interval

Local Received Queue

cluster

service

graph

This panel shows details about the size of the Enterprise Cluster receive queue on all ES nodes during the selected time interval

Local Send Queue

cluster

server

graph

This panel shows details about the size of the Enterprise Cluster send queue on the ES node during the selected time interval

Local Send Queue

cluster

service

graph

This panel shows details about the size of the Enterprise Cluster send queue on all ES nodes during the selected time interval

MariaDB Aborted Connections

database

server

graph

This panel shows the number of connections aborted by the ES node during the selected time interval

MariaDB Aborted Connections

database

service

graph

This panel shows the number of connections aborted by the ES node during the selected time interval

MariaDB Client Thread Activity

database

server

graph

This panel shows the number of client threads connected and running on the ES node during the selected time interval

MariaDB Client Thread Activity

queries

service

graph

This panel shows the number of client threads running on all ES nodes during the selected time interval

MariaDB Connections

database

server

graph

This panel shows the number of client connections to the ES node during the selected time interval

MariaDB Handlers / sec

queries

server

graph

This panel shows how many internal query handlers per second have been created by the ES node during the selected time interval

MariaDB Memory Overview

system

server

graph

This panel shows how much memory the ES node used for the InnoDB buffer pool, InnoDB log buffer, MyISAM key buffer, and query cache during the selected time interval

MariaDB Network Traffic

system

server

graph

This panel shows the amount of data sent and received over the network by the database server on the ES node during the selected time interval

MariaDB Network Traffic

system

service

graph

This panel shows the amount of data sent and received over the network by the database servers on all ES nodes during the selected time interval

MariaDB Network Usage Hourly

system

server

graph

This panel shows the amount of data sent and received over the network per hour by the database server on the ES node over the past 24 hours

MariaDB Network Usage Hourly

system

service

graph

This panel shows the amount of data sent and received over the network per hour by the database servers on all ES nodes over the past 24 hours

MariaDB Open Files

database

server

graph

This panel shows the number of files opened by the database server on the ES node during the selected time interval

MariaDB Open Tables

database

server

graph

This panel shows the number of tables opened by the database server on the ES node during the selected time interval

MariaDB Open Tables

database

service

graph

This panel shows the number of tables opened by the database servers on all ES nodes during the selected time interval

MariaDB Opened Files / sec

database

server

graph

This panel shows the number of files opened per second by the database server on the ES node during the selected time interval

MariaDB QPS

queries

service

graph

This panel shows the number of queries per second (QPS) executed by all ES nodes during the selected time interval

MariaDB QPS and Questions

queries

server

graph

This panel shows the number of queries and questions per second executed by the ES node during the selected time interval

MariaDB Questions / sec

queries

service

graph

This panel shows the number of questions per second executed by all ES nodes during the selected time interval

MariaDB Select Types

queries

server

graph

This panel shows the number of times the ES node has used certain execution strategies to execute SELECT statements during the selected time interval

MariaDB Service Connections

database

service

graph

This panel shows the number of clients connected to the ES node during the selected time interval

MariaDB Slow Queries

queries

server

graph

This panel shows the number of slow queries executed by the ES node during the selected time interval

MariaDB Slow Queries

queries

service

graph

This panel shows the number of slow queries executed by all ES nodes during the selected time interval

MariaDB Slow Queries

status

service

graph

This panel shows the number of slow queries executed by all ES nodes during the selected time interval

MariaDB Sorts

queries

server

graph

This panel shows the number of times the ES node has used certain algorithms to sort data during the selected time interval

MariaDB Table Definition Cache

caches

server

graph

This panel shows how many table definitions were cached by the ES node during the selected time interval

MariaDB Table Locks

database

server

graph

This panel shows the number of table locks requested by the ES node during the selected time interval

MariaDB Table Locks

database

service

graph

This panel shows the number of table locks requested by all ES nodes during the selected time interval

MariaDB Table Open Cache Status

caches

server

graph

This panel shows the activity of the table open cache on the ES node during the selected time interval

MariaDB Table Opened

database

service

graph

This panel shows the number of tables that have been opened by all ES nodes during the selected time interval

MariaDB Thread Cache

caches

server

graph

This panel shows the number of threads created and cached for re-use on the ES node during the selected time interval

MariaDB Transaction Handlers / sec

queries

server

graph

This panel shows the number of transaction-related handlers created by the ES node during the selected time interval

Max Connections

cluster

server

graph

This panel shows the highest number of clients that were concurrently connected to the MaxScale node during the selected time interval

Max Connections

cluster

server

stat

This panel shows the highest number of clients that have ever been concurrently connected to the MaxScale node

Max Connections

status

server

graph

This panel shows the highest number of clients that were concurrently connected to the MaxScale node during the selected time interval

Max Connections

status

server

stat

This panel shows the highest number of clients that have ever been concurrently connected to the MaxScale node

Max Pool Size

cluster

server

graph

This panel shows the highest number of connections that were in the MaxScale node's connection pool during the selected time interval

Max Pool Size

cluster

server

stat

This panel shows the highest number of connections that have ever been in the MaxScale node's connection pool

Max Pool Size

performance

server

graph

This panel shows the highest number of connections that were in the MaxScale node's connection pool during the selected time interval

Max Pool Size

status

server

stat

This panel shows the highest number of connections that have ever been in the MaxScale node's connection pool

Max Time in Queue

cluster

server

graph

This panel shows the longest time the MaxScale node waited for an I/O event during the selected time interval

Max Time in Queue

status

server

graph

This panel shows the longest time the MaxScale node waited for an I/O event during the selected time interval

MaxScale Connections

cluster

server

graph

This panel shows the number of clients connected to the MaxScale node during the selected time interval

MaxScale Descriptors

cluster

server

graph

This panel shows the number of descriptors used by the MaxScale node during the selected time interval

MaxScale Descriptors

performance

server

graph

This panel shows the number of descriptors used by the MaxScale node during the selected time interval

MaxScale Hangups

cluster

server

graph

This panel shows the number of client connections closed by the MaxScale node during the selected time interval

MaxScale Hangups

performance

server

graph

This panel shows the number of client connections closed by the MaxScale node during the selected time interval

MaxScale Modules

modules

server

table

This panel lists the modules installed on the MaxScale node

MaxScale Server Connections

database

service

graph

This panel shows the number of client connections open between the MaxScale node and each ES node during the selected time interval

MaxScale Service Connections

database

service

graph

This panel shows the number of clients connected to all MaxScale nodes during the selected time interval

Memory

cluster

server

graph

This panel shows memory usage details for the MaxScale node during the selected time interval

Memory

performance

server

graph

This panel shows memory usage details for the MaxScale node during the selected time interval

Memory Distribution

system

server

graph

This panel shows memory usage details for the ES node during the selected time interval

Memory Usage

system

service

graph

This panel shows memory usage details for all ES nodes during the selected time interval

Memory Utilization

historical

server

graph

This panel shows memory usage details for the Xpand node during the selected time interval

Memory Utilization

historical

service

graph

This panel shows memory usage details for all Xpand nodes during the selected time interval

Memory Utilization in the last 24 hours (5 minute intervals)

system

server

graph

This panel shows memory usage details for the Xpand node in 5 minute intervals over the past 24 hours

Memory Utilization in the last 24 hours (5 minute intervals)

system

service

graph

This panel shows memory usage details for all Xpand nodes in 5 minute intervals over the past 24 hours

Network Data

historical

server

graph

This panel shows the amount of data sent and received over the network by the database server on the Xpand node during the selected time interval

Network Errors

system

server

graph

This panel shows the number of network errors encountered by the ES node during the selected time interval

Network Errors

system

service

graph

This panel shows the number of network errors encountered by all ES nodes during the selected time interval

Network Packets Dropped

system

server

graph

This panel shows the number of network packets dropped by the ES node during the selected time interval

Network Packets Dropped

system

service

graph

This panel shows the number of network packets dropped by all ES nodes during the selected time interval

Network Traffic

status

server

graph

This panel shows the amount of data sent and received over the network by the operating system on the ES node during the selected time interval

Network Traffic

system

server

graph

This panel shows the amount of data sent and received over the network by the operating system on the ES node during the selected time interval

Network Traffic - Inbound

system

service

graph

This panel shows the amount of data received over the network by the operating systems on all ES nodes during the selected time interval

Network Traffic - Outbound

system

service

graph

This panel shows the amount of data sent over the network by the operating systems on all ES nodes during the selected time interval

Node Queues

cluster

service

table

This panel shows details about the size of the Enterprise Cluster send and receive queues on all ES nodes

Node Status

cluster

service

table

This panel shows details about the size of the Enterprise Cluster send and receive queues on all ES nodes

Nodes in Cluster

status

service

stat

This panel shows the number of Xpand nodes that are currently in the cluster

Nodes in quorum

status

service

stat

This panel shows the number of Xpand nodes that are currently in quorum

Persistent Connections

cluster

server

graph

This panel shows the number of connections in the MaxScale node's connection pool during the selected time interval

Persistent Connections

cluster

server

stat

This panel shows the number of connections currently in the MaxScale node's connection pool

Persistent Connections

status

server

graph

This panel shows the number of connections in the MaxScale node's connection pool during the selected time interval

Persistent Connections

status

server

stat

This panel shows the number of connections currently in the MaxScale node's connection pool

QPS

historical

service

graph

This panel shows the queries per second (QPS) executed by all Xpand nodes during the selected time interval

QPS

queries

service

singlestat

This panel shows the queries per second (QPS) executed by all Xpand nodes during the selected time interval

QPS

status

service

graph

This panel shows the queries per second (QPS) executed by the ES node during the selected time interval

QPS (at 5 minute intervals)

queries

service

graph

This panel shows the average queries per second (QPS) executed by all Xpand nodes in 5 minute intervals over the past 24 hours

QPS Hourly

queries

service

graph

This panel shows the average queries per second (QPS) executed by all Xpand nodes in 1 hour intervals over the past 24 hours

Queries per second by Query Type

historical

service

graph

This panel shows the queries per second (QPS) of certain query types executed by all Xpand nodes during the selected time interval

Query Latency

historical

service

graph

This panel shows the average amount of time all Xpand nodes spent executing queries before returning a result set during the selected time interval

Query Latency over the last 24 hours (5 minute intervals)

queries

service

graph

This panel shows the average amount of time all Xpand nodes spent executing queries before returning a result set in 5 minute intervals over the past 24 hours

Queue Received

lags

service

graph

This panel shows details about the size of the Enterprise Cluster receive queue on all ES nodes during the selected time interval

Queue Send

lags

service

graph

This panel shows details about the size of the Enterprise Cluster send queue on all ES nodes during the selected time interval

RAM

status

server

gauge

This panel shows the current memory usage details for the ES or Xpand node

RAM

status

server

graph

This panel shows memory usage details for the ES or Xpand node during the selected time interval

RAM

system

service

graph

This panel shows memory usage details for all Xpand nodes during the selected time interval

Read Primary Log Position

replicas

service

graph

This panel shows the current binary log position of the replica I/O thread for each ES node during the selected time interval

Ready

cluster

server

singlestat

This panel shows whether Enterprise Cluster is ready for queries on the ES node

Rebalancer - Underprotected Slices

status

service

stat

This panel shows the number of slices in the cluster that are currently unprotected

Rebalancer Activity

historical

service

graph

This panel shows the number of times the Xpand Rebalancer executed certain tasks during the selected time interval

Rebalancer Activity in the last 24 hours

status

service

graph

This panel shows the number of times the Xpand Rebalancer executed certain tasks over the past 24 hours

Rebalancer Jobs

status

service

stat

This panel shows the number of tasks currently scheduled in the Xpand Rebalancer's priority queue

Replicas lags

status

service

table

This panel shows average values for certain replication-related metadata to help determine if the replica ES nodes are currently lagging behind the primary ES node

Replicas status

status

service

table

This panel shows summarized values for certain replication-related metadata to help determine if any replica ES nodes encountered replication issues during the selected time interval

Replicated Writeset Bytes

cluster

server

graph

This panel shows how many bytes the ES node replicated to other ES nodes in the cluster in 5 minute intervals over the past 24 hours

Replicated Writeset Bytes

cluster

service

graph

This panel shows how many bytes all ES nodes replicated to other ES nodes in the cluster in 5 minute intervals over the past 24 hours

Replicated Writesets

cluster

server

graph

This panel shows how many writesets the ES node replicated to other ES nodes in the cluster in 5 minute intervals over the past 24 hours

Replicated Writesets

cluster

service

graph

This panel shows how many writesets all ES nodes replicated to other ES nodes in the cluster in 5 minute intervals over the past 24 hours

Replication Latency

cluster

server

graph

This panel shows details about latency from Enterprise Cluster replication on the ES node during the selected time interval

Resident

cluster

server

gauge

This panel shows the current resident set size (RSS) of the MaxScale process

Resident

status

server

gauge

This panel shows the current resident set size (RSS) of the MaxScale process

Reused Connections

cluster

server

graph

This panel shows the number of times a connection was successfully reused from the MaxScale node's connection pool during the selected time interval

Reused Connections

cluster

server

stat

This panel shows the number of times a connection was successfully reused from the MaxScale node's connection pool

Reused Connections

status

server

graph

This panel shows the number of times a connection was successfully reused from the MaxScale node's connection pool during the selected time interval

Reused Connections

status

server

stat

This panel shows the number of times a connection was successfully reused from the MaxScale node's connection pool

RO Service Connections

status

server

singlestat

This panel shows the number of clients currently connected to the MaxScale node's read-only listener

Routed Packets

cluster

server

graph

This panel shows the number of MariaDB protocol packets routed by the MaxScale node

Routed Packets

performance

server

graph

This panel shows the number of MariaDB protocol packets routed by the MaxScale node

Rows / sec

status

server

graph

This panel shows the total number of rows written and read per second by the ES node during the selected time interval

RW Service Connections

status

server

singlestat

This panel shows the number of clients currently connected to the MaxScale node's read-write listener

RW/sec

cluster

server

graph

This panel shows the number of read and write operations per second that were handled by the threads on the MaxScale node during the selected time interval

RW/sec

status

server

graph

This panel shows the number of read and write operations per second that were handled by the threads on the MaxScale node during the selected time interval

Seconds Behind Primary

replicas

service

graph

This panel shows the average number of seconds that the replica ES nodes lagged behind the primary ES node during the selected time interval

Sequentially in Parallel

cluster

server

graph

This panel shows the average distance between the highest and lowest sequence numbers for writesets applied in parallel by Enterprise Cluster on the ES node during the selected time interval

Sequentially in Parallel

cluster

service

graph

This panel shows the average distance between the highest and lowest sequence numbers for writesets applied in parallel by Enterprise Cluster on all ES nodes during the selected time interval

Server Connections

status

server

graph

This panel shows the number of client connections open between the MaxScale node and each ES node during the selected time interval

Server Routed Packets

cluster

server

graph

This panel shows the number of MariaDB protocol packets routed by the MaxScale node during the selected time interval

Server Routed Packets

performance

server

graph

This panel shows the number of MariaDB protocol packets routed by the MaxScale node during the selected time interval

Server Routed Packets

status

server

bargauge

This panel shows the number of MariaDB protocol packets routed by the MaxScale node over the past 5 minutes

Service Connections

status

server

graph

This panel shows the number of clients connected to the MaxScale node's listeners during the selected time interval

Session time in state

historical

service

graph

This panel shows the total length of time for all Xpand nodes that client connections were in each connection state during the selected time interval

Session time in state in the last 24 hours (5 minute intervals)

connections

service

graph

This panel shows the total length of time for all Xpand nodes that client connections were in each connection state in 5 minute intervals over the past 24 hours

Session transaction age

historical

service

graph

This panel shows the session transaction age for all Xpand nodes during the selected time interval

Session transaction age in the last 24 hours (5 minute intervals)

connections

service

graph

This panel shows the session transaction age for all Xpand nodes in 5 minute intervals over the past 24 hours

Sessions

historical

service

graph

This panel shows how many client connections on all Xpand nodes were in each connection state during the selected time interval

Sessions in the last 24 hours (5 minute intervals)

connections

service

graph

This panel shows how many client connections on all Xpand nodes were in each connection state in 5 minute intervals over the past 24 hours

Stack size

cluster

server

gauge

This panel shows the current stack size of the MaxScale node

Stack size

status

server

gauge

This panel shows the current stack size of the MaxScale node

Status

cluster

server

singlestat

This panel shows the current local state of the ES node according to Enterprise Cluster

Storage

historical

server

graph

This panel shows the total amount of storage space used by each Xpand node during the selected time interval

Storage allocation

historical

service

graph

This panel shows the amount of storage space allocated to each Xpand node during the selected time interval

Storage allocation in the last 24 hours (5 minute intervals)

system

service

graph

This panel shows the amount of storage space allocated to each Xpand node in 5 minute intervals over the past 24 hours

Storage in the last 24 hours (5 minute intervals)

system

server

graph

This panel shows the total amount of storage space used by each Xpand node in 5 minute intervals over the past 24 hours

Temporary Objects Created

database

server

graph

This panel shows the number of temporary tables created by the ES node during the selected time interval

Threads

cluster

server

singlestat

This panel shows the number of threads currently used by the MaxScale node

Threads Count

status

server

singlestat

This panel shows the number of threads currently used by the MaxScale node

TIL Core Utilization

historical

server

graph

This panel shows the CPU usage of each CPU core (excluding core-0) for the Xpand node during the selected time interval

Top Command Counters

historical

service

graph

This panel shows how often certain statement types were executed by the Xpand node during the selected time interval

Top Command Counters

queries

server

graph

This panel shows the top 30 statement types that were most frequently executed by the ES node during the selected time interval

Top Command Counters

queries

service

graph

This panel shows the top 30 statement types that were most frequently executed by all ES nodes during the selected time interval

Top Command Counters Hourly

queries

server

graph

This panel shows the top 30 statement types that were most frequently executed by the ES node in 1 hour intervals over the past 24 hours

Top Command Counters Hourly

queries

service

graph

This panel shows the top 30 statement types that were most frequently executed by all ES and Xpand nodes in 1 hour intervals over the past 24 hours

Top Command Counters in the last 24 hours (5 minute intervals)

queries

service

graph

This panel shows how often certain statement types were executed by all Xpand nodes in 5 minute intervals over the past 24 hours

Total Active Operations

cluster

server

graph

This panel shows the total number of queries that were actively being executed by the MaxScale node during the selected time interval

Total Active Operations

cluster

server

stat

This panel shows the total number of queries that are actively being executed by the MaxScale node

Total Active Operations

status

server

graph

This panel shows the total number of queries that were actively being executed by the MaxScale node during the selected time interval

Total Active Operations

status

server

stat

This panel shows the total number of queries that are actively being executed by the MaxScale node

Total Connections

cluster

server

graph

This panel shows the total number of connections created by the MaxScale node during the selected time interval

Total Connections

cluster

server

stat

This panel shows the total number of connections created by the MaxScale node since the MaxScale node was started

Total Connections

status

server

graph

This panel shows the total number of connections created by the MaxScale node during the selected time interval

Total Connections

status

server

stat

This panel shows the total number of connections created by the MaxScale node since the MaxScale node was started

TPS

historical

service

graph

This panel shows the average transactions per second (TPS) executed by all Xpand nodes during the selected time interval

TPS

queries

service

singlestat

This panel shows the average transactions per second (TPS) executed by all Xpand nodes during the selected time interval

TPS (at 5 minute intervals)

queries

service

graph

This panel shows the average transactions per second (TPS) executed by all Xpand nodes in 5 minute intervals over the past 24 hours

TPS Hourly

queries

service

graph

This panel shows the average transactions per second (TPS) executed by all Xpand nodes in 1 hour intervals over the past 24 hours

Uptime

status

service

singlestat

This panel shows how long all Xpand nodes have been online

Used Connections

status

server

mariadb-pie-chart

This panel shows the current number of client connections as a percentage of the ES node's max_connections value

Utilization

cluster

server

bargauge

This panel shows details about the CPU and memory usage for the MaxScale node during the selected time interval

Utilization

status

server

bargauge

This panel shows details about the CPU and memory usage for the MaxScale node during the selected time interval

WAL sync time

historical

service

graph

This panel shows the average time the Xpand nodes required to sync changes to the Write Ahead Log (WAL) during the selected time interval

WAL sync time in the last 24 hours (5 minute intervals)

status

service

graph

This panel shows the average time the Xpand nodes required to sync changes to the Write Ahead Log (WAL) in 5 minute intervals over the past 24 hours

Xpand Memory Distribution

historical

server

graph

This panel shows details about memory usage for the Xpand node during the selected time interval

Xpand Memory Distribution in the last 24 hours (5 minute intervals)

system

server

graph

This panel shows details about memory usage for the Xpand node in 5 minute intervals over the past 24 hours

Xpand Total Memory

historical

service

graph

This panel shows the total memory usage for all Xpand nodes during the selected time interval

Xpand Total Memory in the last 24 hours (5 minute intervals)

system

service

graph

This panel shows the total memory usage for all Xpand nodes in 5 minute intervals over the past 24 hours