How to get munin to alert for NaN

Question

I am using this mysql slave status plugin and on the munin master I have added...

mysql_slave_status.warning 30
mysql_slave_status.critical 60

So it alerts whenever the slave gets behind the master. How do I get munin to alert me (critical alert if possible) when the plugin returns "NaN", will it do that automatically?

It returns NaN when the SQL isn't running or the connection fails.

EDIT: In the end I made it add a large number to the actual value if the connection was down.

Answer 1

Having written a bit of the mysql_ plugin I can attest to having replaced much of the single purpose plugins of munin. In the above link there is a documented example of what you want:

[mysql_replication]
env.slave_io_running_warning 0.5
env.slave_sql_running_warning 0.5
env.seconds_behind_master_warning 300
env.seconds_behind_master_critical 600