Merge statistics will indicate the performance of the system in persisting changes. This monitor will check for the success and time taken by the merge operation applied on each table. It will also detect potential future failing merge because of too large table
| Merge time monitoring | |
|---|---|
| Parameter | Description |
| Active | If checked, the rule is enabled and will be processed |
| Host | Can be used to restrict the monitoring to a given host (multi instance case). A star (‘*’) will match any host |
| Schema | Can be used to restrict the monitoring on the tables within a given schema. A star (‘*’) will match any schema |
| Table | Can be used to restrict the monitoring on a given table. A star (‘*’) will match any table |
| Threshold (sec) | The maximum delta merges time before sending an alarm |
| Period (min) | The period of time in the past (computed from now) to look for merge operations |
| Aggregate | If checked, one alarm will be sent indicating the number of merge operations reaching the threshold. If not checked, one alarm per merge operation will be sent |
| Severity | Defines the level of severity of the alarm that will be generated if one of the thresholds is reached |
| Failed merge severity | Defines the level of severity of the alarm that will be generated if one merge operation fails |
| Auto clear | If set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled anymore |
| Alarm tag | You can define some text to use as a prefix of the alarm message generated by the current rule |
| Alarm | Defines if an alarm has to be generated for the given rule |
| Metric | Defines if a metric has to be generated for the given rule |
| Merge size ratio monitoring | |
|---|---|
| Parameter | Description |
| Active | If checked, the rule is enabled and will be processed |
| Schema | Can be used to restrict the monitoring on the tables within a given schema. A star (‘*’) will match any schema |
| Table | Can be used to restrict the monitoring on a given table. A star (‘*’) will match any table |
| Max size ratio (%) | The maximum size ratio between table disk space and effective memory allocation size |
| Severity | Defines the default severity of the alarm generated |
| Failed merge severity | Defines the level of severity of the alarm that will be generated if one merge operation fails |
| Alarm tag | You can define some text to use as a prefix of the alarm message generated by the current rule |
| metricId | metricUnit | metric tags | metricDescription |
|---|---|---|---|
| MERGE_STATISTICS_TIME | Seconds | SCHEMA.TABLE | Sends the average time taken by merge operations within a period, for a given table |
| MERGE_STATISTICS_COUNT | Occurence | SCHEMA.TABLE | Sends the number of merge operations occurred for a given table within a period. Only generated in aggregate mode |
| MERGE_STATISTICS_TABLE_SIZE_RATIO | Percent | SCHEMA.TABLE | Sends the table disk size vs effective allocation limit ratio |