What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags

View all Tags

MySQL v2 Sensor - Alerting Reset



We're implementing the MySQL v2 sensor for a MariaDB RDS instance. And most of the configuration has gone as expected. There is one part of the alerting that we've not been able to get to present as desired.

STEPS TAKEN Added MySQL v2 sensor Configured Database Added .sql file to appropriate path on Core Probe Selected SQL Query File that was uploaded Data (options set) ... Data Processing: Process data table ... Handle DBNull in Channel Values as: Number 0 ... Select Channel Value by: Column number ... Sensor Channel #1 Column Number: 0 ... Sensor Channel #1 Unit: Count ....... note: it's a select statement that returns a count

Edited Channel ... Enable alerting based on limits ... Upper Error Limit (#): 0 ....... note: we want the sensor to alert if this value is greater than 0

Notification Triggers ... When sensor state is Down perform > Slack notification ... When sensor state is Up perform > Slack notification ... note: we've run planned tests and the Sensor along with Slack notify as expected

Unexpected Presentation ... When the channel resets to an up status, the sensor returns to an Up status, but, the visual graph for the channel still presents as Red instead of Green. This leads to a confusing visual, any ideas on what we might be missing?

Resources Referenced: https://www.paessler.com/manuals/prtg/mysql_v2_sensor https://kb.paessler.com/en/topic/71779-how-can-i-monitor-mysql-performance-via-mysqlv2-sensor https://kb.paessler.com/en/topic/70618-how-to-setup-the-sql-v2-sensors-in-prtg-is-there-a-guide

mysql-v2-sensor prtg rds

Created on Nov 5, 2018 6:57:26 PM

1 Reply




Do you have the edited channel set to the primary channel? If so, the graph will be color coded to represent the channel limits. So in this case, anything above 0 would be red. The graphs default to a positive correlation by default, so in this case, yes I can see where the graph will show red. You can go in to the channel settings, and modify the Vertical Axis Scaling to adjust for this particular sensor. Let me know if this helps out at all.

Benjamin Day
Paessler Support

Created on Nov 6, 2018 11:22:17 PM by  Benjamin Day [Paessler Support] (1,441) 2 1

Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.