YMatrix

Quick Start

Cluster Deployment

Data Model

Data Writing

Data Query

SQL Reference

Maintenance and Monitoring

Tool Guide

Troubleshooting

FAQ

Scenario
Version Release History

Interpretation of MatrixGate monitoring parameters

1. Basic information

Basic Information

| Parameter name | Description | Reference Alarm Threshold | | --- | --- | |version|mxgate version number| | |Run time |mxgate run time | | |Process number |mxgate process number | |

2. Task information

Task Information

| Parameter name | Description | Reference Alarm Threshold | | --- | --- | |Target table |Target table inserted into this task data | | |Total number of rows in the database | Total number of data successfully in the database since the mxgate was started | | |Total number of error rows | Total number of data that failed to enter the database since the task was started | The alarm threshold can be set according to the situation | |Total inlet size | The data size of the successful initing of this task since mxgate was started | | |Concurrency|Total concurrency: The value is the configuration item stream-prepared+1, the upper limit configuration of concurrency
Number of work: The actual concurrency of work, some threads will enter a dormant state, so the actual concurrency of work may be less than the configuration| | |Transaction time granularity |Time span of data transaction commit| |

3. Load statistics

Load Statistics

| Parameter name | Description | Reference Alarm Threshold | | --- | --- | |Number of submission lines|Submit data rate| | |Number of rows in storage|Successful rate in storage| | |Number of blocked rows|The amount of data that has not been in the database after submission due to database throughput|Alarm threshold can be set according to the situation| |Number of failed rows |Failed rate of entry|Alarm threshold can be set according to the situation| |Written data volume |Successful data volume rate | |

4. Delay Statistics

Delay Statistics The delays of each stage of data entry are statistical values ​​for a period of time, including:

  1. max: maximum value
  2. min: minimum value
  3. 95%: The average value of 95% data

| Parameter name | Description | Reference Alarm Threshold | | --- | --- | |Total delay statistics | This delay is the sum of the following delays | | |insertStart delay statistics | Delay from execution of INSERT to the first piece of data sent to segment | Alarm threshold can be set according to the situation | |write delay statistics | mxgate time-consuming to send this batch of data to segment | alarm threshold can be set according to the situation | |insertDone delay statistics | The last data sent to segment to the delay when the INSERT statement is executed | The alarm threshold can be set according to the situation | |commit delay statistics | Delay execution of commit command | Alarm threshold can be set according to the situation |