Skip to content

Monitoring Metrics Reference

Panel Name UI Tab Scope Panel Type Description
Connections status service table This panel shows the number of used and aborted connections for each ES node along with the max_connections value
CPU Load status service graph This panel shows the CPU usage for each ES node during the selected time interval
Current SQL Commands status service pie-chart This panel shows the ratio between the types of SQL statements executed by the service during the selected time interval
Disk Size of Data status service table "This panel shows the amount of storage space used (as the usage percentage
QPS status service graph This panel shows the queries per second (QPS) executed by the ES node during the selected time interval
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
GTID Replication Position lags service graph This panel shows the Global Transaction ID (GTID) for each ES node during the selected time interval
Seconds Behind Primary lags service graph This panel shows the lag in seconds behind the primary in terms of the time of the transaction being replicated.
Exec Primary Log Position lags service graph This panel shows the position up to which the primary has processed in the current primary binary log file.
Read Primary Log Position lags service graph This panel shows the position up to which the I/O thread has read in the current primary binary log file.
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 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 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 queries service graph This panel shows the number of slow queries executed by all ES nodes 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 service graph This panel shows the top 30 statement types that were most frequently executed by all ES nodes in 1 hour intervals over the past 24 hours
MariaDB Aborted Connections database service graph This panel shows the number of connections aborted by 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 Service Connections database service graph This panel shows the number of clients connected to 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 Opened database service graph This panel shows the number of tables that have been opened by all ES nodes during the selected time interval
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
CPU Load system service graph This panel shows the CPU usage for each ES node during the selected time interval
Disk Size of Data system service graph This panel shows the amount of storage space used by all ES nodes during the selected time interval
I/OActivity - 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
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
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 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
Memory Usage system service graph This panel shows memory usage details for all ES nodes 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 service graph This panel shows the number of network packets dropped by all ES nodes 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
Aborted Connections status server singlestat This panel shows the number of aborted connections for the ES node during the selected time interval
Buffer Pool Size of Total RAM status server 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
Connections status server stat This panel shows the number of clients connected to the MaxScale node
CPU Load status server gauge This panel shows the current CPU usage for the ES node
CPU Usage / Load status server graph This panel shows the CPU usage for the ES node during the selected time interval
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 SQL Commands status server pie-chart This panel shows the ratio between the types of SQL statements executed by the 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
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
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 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
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
Memory Usage status server gauge This panel shows the current memory usage details for the ES node
Resident (RSS) memory status server gauge This panel shows the current resident set size (RSS) of the MaxScale process
RO Service Connections status server singlestat This panel shows the number of clients currently connected to the MaxScale node's read-only listener
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 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
Database 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
MaxScale Connections status server graph This panel shows the number of clients connected to the MaxScale node's listeners during the selected time interval
Stack size status server gauge This panel shows the current stack size of the MaxScale node
Threads status server singlestat This panel shows the number of threads currently used by the MaxScale node
RW/sec 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
MaxScale Connections status server graph This panel shows the total number of connections created by the MaxScale node since the MaxScale node was started
Used Connections status server pie-chart This panel shows the current number of client connections as a percentage of the ES node's max_connections value
MariaDB Aborted Connections database server 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 Connections database server graph This panel shows the number of client connections to the ES node during the selected time interval
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 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 Table Locks database server graph This panel shows the number of table locks requested by the ES node during the selected time interval
Temporary Objects Created database server graph This panel shows the number of temporary tables created by the ES node 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 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 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 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 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 Slow Queries queries server graph This panel shows the number of slow queries executed by the ES node 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 Handlers / sec queries server graph This panel shows the number of transaction-related handlers created by the ES 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 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
CPU Usage / Load system server graph This panel shows the CPU usage for the ES node during the selected time interval
Disk Size of Data system server graph This panel shows the amount of storage space used by the ES node during the selected time interval
Disk Size of Logs system server graph This panel shows the amount of storage space used by the server error logs 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
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
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
MariaDB Memory Overview system server graph "This panel shows how much memory the ES node used for the InnoDB buffer pool
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 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
Memory Distribution system server graph This panel shows memory usage details for the ES 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 Packets Dropped system server graph This panel shows the number of network packets dropped by 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
Errors performance server graph This panel shows the number of errors encountered by threads on 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 performance server graph This panel shows the number of client connections closed by the MaxScale node during the selected time interval
Memory Usage performance server graph This panel shows memory usage details for the MaxScale node during the selected time interval
MaxScale Modules modules server table This panel lists the modules installed on the MaxScale node