[Nagiosplug-help] check_mysql_query

[Mikael Fridh]

On 6/15/08, Kaushal Shriyan <kaushalshriyan at gmail.com> wrote:
> whats the best range to be given to -w option if i give the value for -c
> option as -c 200000 in the below query
>
> as the info page for -w option says -w, --warning=RANGE Warning range
> (format: start:end). Alert if outside this range
>
> /usr/nagios/libexec/check_mysql_query -q 'Select count(*)
> from table" -w -c 200000 -P 3306 -u test -p example

That's pretty much up to you, but something like this perhaps?
-w 1:180000 -c 200000

warn if > 180000
crit if > 200000

--
Mike