Hi,
Does anyone have the definition of the columns in the "dc_spread_monitor" table or some SQL that would make some meaning of the data?
No information on this table in either the V6 or V7 online documentation.
I see in the V7 MC that there is an alert for "Spread Retransmit Rate Over Threshold 10%", but need to look for something similar in a V6 cluster and assuming the data to analyse is in the dc_spread_monitor table.
Regards
Tim
Spread Monitoring
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Spread Monitoring
If you're just looking for a query, this might help:Timbo wrote:I see in the V7 MC that there is an alert for "Spread Retransmit Rate Over Threshold 10%", but need to look for something similar in a V6 cluster and assuming the data to analyse is in the dc_spread_monitor table.
Code: Select all
SELECT DATE_TRUNC('minute', time) AS time,
node_name,
ROUND(( MAX(retrans) - MIN(retrans) ) / ( MAX(message_delivered) - MIN(message_delivered) ) * 100, 2.0) AS retransmit_rate
FROM dc_spread_monitor
GROUP BY 1,
2
HAVING ROUND(( MAX(retrans) - MIN(retrans) ) / ( MAX(message_delivered) - MIN(message_delivered) ) * 100, 2.0) > 10
ORDER BY 1 DESC,
2;
Checkout vertica.tips for more Vertica resources.