Merge statistics

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

Configuration hints

You can customize the monitoring by setting filters on the host, the schema and the table

Failed and Long merge operations:

Use the first table to configure threshold, severities and period

The period defines how far in the past the monitoring will fetch merge operations

If set to 0, it will fetch since the last check.

Detecting too big tables to complete a successful merge.

Use the second table to configure threshold

Multi-threshold syntax can be used in any threshold field

Surveillance 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

Generated metrics

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