Metric Name | Metric Meaning | Description | Unit | Dimension | Statistical Rules [period, statType] |
CacheHitPct | Cache hit rate | Cache hit rate | % | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
CacheHitPctNode | Node cache hit rate | Cache hit rate | % | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
CapacityUsage | Used capacity | Used capacity | GBytes | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
CapacityUsageNode | Utilized Capacity of the Node | Used capacity | GBytes | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
CapacityUsedPct | StorageUsage | StorageUsage | % | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
CapacityUsedPctNode | Node Capacity Utilization | StorageUsage | % | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
ClusterStatus | Cluster Status | Cluster Status | None | ClusterName | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
Connections | Number of Connections | Number of Connections | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
ConnectionsNode | Number of node connections | Number of Connections | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
CpuUsedPct | CPU utilization | CPU utilization | % | ClusterName | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
CpuUsedPctNode | Node CPU utilization | CPU utilization | % | ClusterName NodeName Type | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
DeleteRequests | Number of delete requests | Number of delete requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
DeleteRequestsNode | Node deletion requests | Number of delete requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
ErrorRequests | Error Requests | Error Requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
ErrorRequestsNode | Node Error Requests | Error Requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
InsertRequests | Number of insert requests | Number of insert requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
InsertRequestsNode | Node insertion requests | Number of insert requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
Iops | IO Throughput | IO Throughput | Count/s | ClusterName | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
IopsNode | Node IO Throughput | IO Throughput | Count/s | ClusterName NodeName Type | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
MachineCpuUse | Machine CPU Utilization | Machine CPU Usage | % | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineDiskReadbytes | Machine disk read throughput | Machine disk read throughput | MBytes/s | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineDiskReadcount | Machine read IOPS | Machine read IOPS | Count/s | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineDiskReadlatency | Machine disk read duration | Machine disk read duration | ms | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineDiskUse | Machine disk utilization | Machine disk utilization | % | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineDiskWritebytes | Machine disk write throughput | Machine disk write throughput | MBytes/s | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineDiskWritecount | Machine write IOPS | Machine write IOPS | Count/s | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineDiskWritelatency | Machine disk write time | Machine disk write time | ms | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineEthInput | Machine network input throughput | Machine network input throughput | KBit/s | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineEthOutput | Network outbound throughput of the machine | Network outbound throughput of the machine | KBit/s | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineIoUseRate | Machine disk IO utilization | Machine disk IO utilization | % | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MachineMemoryUseRate | Machine Memory Utilization | Machine Memory Utilization | % | ClusterName IP | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
MasterSwitch | Number of primary-secondary switches | Number of primary-secondary switches | Count | ClusterName | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
MasterSwitchNode | Number of node primary-backup switchovers | Number of primary-secondary switches | Count | ClusterName NodeName Type | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
MaxCnConnectionRate | Maximum cn connection utilization | Maximum cn connection utilization | % | ClusterName | [60s, avg] [300s, max] [3600s, avg] [86400s, avg] |
MaxDnConnectionRate | Maximum dn connection utilization | Maximum dn connection utilization | % | ClusterName | [60s, avg] [300s, max] [3600s, avg] [86400s, avg] |
MemUsedPct | Memory utilization | Memory utilization | % | ClusterName | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
MemUsedPctNode | Node memory utilization | Memory utilization | % | ClusterName NodeName Type | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
OtherRequests | Other Requests | Other Requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
OtherRequestsNode | Node other requests | Other Requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
ReadRequests | Number of read requests | Number of read requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
ReadRequestsNode | Node read requests | Number of read requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
SqlRuntimeAvg | Average SQL execution time | Average SQL execution time | ms | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
SqlRuntimeAvgNode | Average SQL execution time of nodes | Average SQL execution time | ms | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
SqlRuntimeMax | Maximum TOP10 Execution Time | Maximum TOP10 Execution Time | ms | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
SqlRuntimeMaxNode | Node Maximum TOP10 Execution Time | Maximum TOP10 Execution Time | ms | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
SqlRuntimeMin | Minimum TOP10 Execution Time | Minimum TOP10 Execution Time | ms | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
SqlRuntimeMinNode | Node Minimum TOP10 Execution Time | Minimum TOP10 Execution Time | ms | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
TotalRequests | Total number of requests | Total number of requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
TotalRequestsNode | Total number of requests of the node | Total number of requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
TwoPhaseCommitTrxs | Number of remaining two-phase transactions | Number of remaining two-phase transactions | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
TwoPhaseCommitTrxsNode | Number of remaining two-phase transactions on the node | Number of remaining two-phase transactions | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
UpdateRequests | Update Requests | Update Requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
UpdateRequestsNode | Node update requests | Update Requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
UserRequests | Number of business requests | Number of business requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
UserRequestsNode | Number of node service requests | Number of business requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
WriteRequests | Number of write requests | Number of write requests | Count | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
WriteRequestsNode | Node write requests | Number of write requests | Count | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
XidRemain | The number of remaining XIDs | The number of remaining XIDs | Count | ClusterName | [60s, avg] [300s, min] [3600s, min] [86400s, min] |
XidRemainNode | Remaining XID quantity on node | The number of remaining XIDs | Count | ClusterName NodeName Type | [60s, avg] [300s, min] [3600s, min] [86400s, min] |
XlogDiff | Primary/replica xlog synchronization difference | Primary/replica xlog synchronization difference | Bytes | ClusterName | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
XlogDiffNode | Synchronization Difference of xlog Among Standby Nodes | Replica xlog synchronization difference | Bytes | ClusterName NodeName Type | [60s, avg] [300s, max] [3600s, max] [86400s, max] |
XlogDiffSendReplay | xlog sync delay | sync delay | ms | ClusterName | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
XlogDiffSendReplayNode | node xlog sync delay | xlog sync delay | ms | ClusterName NodeName Type | [60s, avg] [300s, avg] [3600s, avg] [86400s, avg] |
Parameter Name | Dimension Name | Dimension Explanation | Format |
Instances.N.Dimensions.0.Name | ClusterName | Cluster id dimension name | Enter a String-type dimension name: ClusterName |
Instances.N.Dimensions.0.Value | cdwpg-xxx | Cluster id | Enter the specific cluster id, for example: cdwpg-12345678 |
Instances.N.Dimensions.0.Name | IP | IP Dimension Name of Machine | Input dimension name of String type: IP |
Instances.N.Dimensions.0.Value | x.x.x.x | Machine IP | Manually input the machine IP, for example: x.x.x.x |
Instances.N.Dimensions.0.Name | NodeName | Node Name Dimension Name | Enter the dimension name of String type: NodeName |
Instances.N.Dimensions.0.Value | cn0001 | Node Name | Enter the node name, for example: cn0001 |
Instances.N.Dimensions.0.Name | Type | Node Role Type dimension name | Dimension name of String class: Type |
Instances.N.Dimensions.0.Value | master | Node Role | Currently fixed value: master |
피드백