The overview section displays the overall operating status of the cluster, including:
| Parameter name | Description | Reference Alarm Threshold |
| --- | --- |
|Cluster status | Cluster node status, including:
0: Normal
1: No Standby
2: No Mirror
10: Distribution unbalanced (Some nodes are down and restored, and the master-slave role is not rebalanced)
11: There are master-slave asynchronous nodes (Some mirror nodes are not synchronous with primary)
12: Only Master (The cluster only starts the Master node, usually used during diagnosis)
20: Segment downtime (There is an unavailable Segment node, the cluster is not available) | Segment downtime is a serious event, and an alarm is required |
|Runtime|Includes MatrixDB's run time since startup and master host operating system run time| |
| Version | Version of MatrixDB | |
|Connection status |Connection status displays the number of connections in the database system, including: total number of connections, number of blocked connection queries, number of idle connections, number of idle connections in transactions | |
|Slow query|In the current system, the number of queries that have been executed for more than 1 day| greater than 0 means that there are particularly slow queries and an alarm is required|
|Transactions | Statistics on transaction submission and rollback count | Rollback alarm threshold can be set |
|Disk usage |Disk usage and remaining space for master nodes and segment nodes | Alarms are recommended to set directly in node_exporter |
|Node status|State of each node, including:
0: UP (Normal)
10: Switched (Role swap, indicating that master-slave switching has occurred and needs to be rebalanced)
11: Resync (Master-slave synchronization)
20: Down (Downtime) | 11 and 20 need to add alarms |
The Database Performance section demonstrates database performance, including:
| Parameter name | Description | Reference Alarm Threshold |
| --- | --- |
|Page Hit Ratio|Hit Buffer Ratio when reading a data page| |
|Temp Size|Temp file usage| |
|Deadlocks|Number of deadlocks|Automatically greater than 0|
|Checksum Failures|Number of data page verification failure|Automatically greater than 0|
|Sessions Per Database|Number of connections per database| |
|Page Cache Hit|blks_hit: Number of hit caches when reading data pages
blks_read: Number of times cache missed and disks to be read| |
|Rows Read|Query read and return tuple number| |
|Checkpoints|checkpoints trigger times, including:
checkpoints_req: manual trigger
checkpoints_timed: periodic trigger| |
|Replication Latency|Master-slave replication delay, unit ms
write_lag: delay in log writing to mirror file cache
flush_lag: delay in log flushing to mirror disk
replay_lag: delay in log playback completion
Top Segment: All nodes write_lag+flush_lag+replay_lag delay and maximum value|Alarm threshold can be set according to the situation|
|Rows Insert/Update/Delete|Rows Insert: Insert number of rows
Rows Update: Updating number of rows
Rows Delete: Delete number of rows| |
|Checkpoint buffers|Dirty page writing statistics
buffers_checkpoint: checkpoint number of dirty pages
buffers_clean: bgwriter number of dirty pages
buffers_backend: backend process writing number of dirty pages| |
|Top 10 Replication Lag Size|Statistics of the delay amount of the Top 10 nodes, the calculation method is the difference between the sent lsn and the replay lsn|The alarm threshold can be set according to the situation|
Storage section displays storage-related statistics, including:
| Parameter name | Description | Reference Alarm Threshold | | --- | --- | |Top 10 Databases|Top 10 Databases| | |Top 10 Users|Top 10 User Generated Data Size| | |Top 10 Aging Database|Top10 Database Age (transaction ID less than this value is replaced by Frozen)| | |Top 10 Big Tables|Top 10 Database Table Size| | |Top 10 Big Partitions|Top 10 Partition Table Size| | |Top 10 Growth Today|Top 10 table size increments on the day| | |Top 10 Growth Last 7 Days|Top 10 table size increments in the past 7 days| |
