Myql montoring with graphs
list Nelson Amaral
Hi, I would like to monitor my mysql servers with hobbit with graphs to show trends, etc. Does anyone know a good way to do this, i tried the one from the link below but it only gives me the values, i would really like the graphs. http://www.phpprogrammer.co.nz/how-to-setup-hobbit-including-mysql-graphs by the way hobbit is the perfect monitoring tool i just love it Regards Nelson Amaral ----- Original Message ----- From: "Kevin McAllister" <user-9e7bc063767c@xymon.invalid> To: user-ae9b8668bcde@xymon.invalid Sent: Thursday, 11 March, 2010 11:08:37 PM Subject: [hobbit] Using Xymon to monitor the ink and toner levels in printers Hello, The scripts that I have for gathering this doesn't seem to be getting any data at all. I am new to this any help would be appreciated. I am running Centos 5.3 x86_64. I have put a copy of the scripts in the email. #!/bin/sh #ink # #BIG BROTHER - monitor HP printer ink levels # HOSTIP=$1; export HOSTIP HOST=$2; export HOST VHOST=$3; export VHOST InkTmp=$BBTMP/ink.$$; export InkTmp COLOR="blue"; export COLOR echo $COLOR > ${InkTmp}-color URL="http://${HOSTIP}/SSI/device_status_info.htm"; echo "URL: $URL" > ${InkTmp}-2 echo "" >> ${InkTmp}-2 /usr/bin/curl -w "$SS_LOGCURL" -m 120 -H "Host: $VHOST" -G $URL > $InkTmp 2>> ${InkTmp}-2 #bit a monkeybusiness with COLOR here because the variable doesn't propagate back from the sub-shells if test $? -eq 0 then echo "" >> ${InkTmp}-2 COLOR="green"; export COLOR $GREP CARTRIDGE $InkTmp | $SED -r 's/<[^>]*>| //g' | $SED 's/ CARTRIDGE/ _CARTRIDGE: /' | tee -a ${InkTmp}-2 | $SED 's/%//' | while read x do if test $COLOR != "red" then set $x if test $2 -le 10 then COLOR="yellow" fi fi echo $COLOR > ${InkTmp}-color done fi # #THE FIRST LINE IS STATUS INFORMATION .....STRUCTURE IMPORTANT! #THE REST IS FREE-FORM - WHATEVER YOU'D LIKE TO SEND .... # LINE="status ${HOST}.${TEST} `cat ${InkTmp}-color` `date` <code>`cat ${InkTmp}-2`</code>" $RM -f $InkTmp ${InkTmp}-2 ${InkTmp}-color #NOW USE THE BB COMMAND TO SEND THE DATA ACROSS $BB $BBDISP "$LINE" #SEND IT TO BBDISPLAY ++++++++++++++++++++++++++++++++++++++++++++++++++ #!/bin/sh #toner # #BIG BROTHER - monitor HP printer ink levels # HOSTIP=$1; export HOSTIP HOST=$2; export HOST VHOST=$3; export VHOST InkTmp=$BBTMP/toner.$$; export InkTmp COLOR="blue"; export COLOR echo $COLOR > ${InkTmp}-color URL="http://${HOSTIP}/hp/device/this.LCDispatcher?nav=hp.DeviceStatus"; echo "URL: $URL" > ${InkTmp}-2 echo "" >> ${InkTmp}-2 /usr/bin/curl -w "$SS_LOGCURL" -m 120 -H "Host: $VHOST" -G $URL > $InkTmp 2>> ${InkTmp}-2 #bit a monkeybusiness with COLOR here because the variable doesn't propagate back from the sub-shells if test $? -eq 0 then echo "" >> ${InkTmp}-2 COLOR="green"; export COLOR $GREP CARTRIDGE $InkTmp | $SED -r 's/<[^>]*>| //g' | $SED 's/ CARTRIDGE/ _CARTRIDGE: /' | tee -a ${InkTmp}-2 | $SED 's/%//' | while read x do if test $COLOR != "red" then set $x if test $2 -le 10 then COLOR="yellow" fi fi echo $COLOR > ${InkTmp}-color done fi # #THE FIRST LINE IS STATUS INFORMATION .....STRUCTURE IMPORTANT! #THE REST IS FREE-FORM - WHATEVER YOU'D LIKE TO SEND .... # LINE="status ${HOST}.${TEST} `cat ${InkTmp}-color` `date` <code> `cat ${InkTmp}-2`</code>" $RM -f $InkTmp ${InkTmp}-2 ${InkTmp}-color #NOW USE THE BB COMMAND TO SEND THE DATA ACROSS $BB $BBDISP "$LINE" #SEND IT TO BBDISPLAY
list Nelson Amaral
Hi, Many thanks for your help Regards Nelson Amaral ----- Original Message ----- From: user-d54077869176@xymon.invalid To: user-ae9b8668bcde@xymon.invalid Sent: Friday, 12 March, 2010 7:40:10 AM Subject: Re: [hobbit] Myql montoring with graphs On Thu, 11 Mar 2010 13:14:02 +0000 (GMT), Nelson Amaral
▸
<user-eeda269dc555@xymon.invalid> wrote:Hi, I would like to monitor my mysql servers with hobbit with graphs to show trends, etc. Does anyone know a good way to do this, i tried the one from the link below but it only gives me the values, i would really like the graphs.
http://www.phpprogrammer.co.nz/how-to-setup-hobbit-including-mysql-graphs
by the way hobbit is the perfect monitoring tool i just love it Regards Nelson Amaral
Hello, On my side I'm using Charles Goyard's mysql monitoring plugin, available here : http://www.trantor.org/xymonton/doku.php/monitors:bb-mysql You can easily configure your Xymon server in order to get graphs from different values. Here are the data you can get with : threads, questions, slow queries, opens, flush tables, open tables, queries per second avg and maxcon Regards, Damien
list Kevin McAllister
Hello,
The scripts that I have for gathering this doesn't seem to be getting any data at all. I am new to this any help would be appreciated. I am running Centos 5.3 x86_64. I have put a copy of the scripts in the email.
#!/bin/sh
#ink
#
#BIG BROTHER - monitor HP printer ink levels
#
HOSTIP=$1; export HOSTIP
HOST=$2; export HOST
VHOST=$3; export VHOST
InkTmp=$BBTMP/ink.$$; export InkTmp
COLOR="blue"; export COLOR
echo $COLOR > ${InkTmp}-color
URL="http://${HOSTIP}/SSI/device_status_info.htm";
echo "URL: $URL" > ${InkTmp}-2
echo "" >> ${InkTmp}-2
/usr/bin/curl -w "$SS_LOGCURL" -m 120 -H "Host: $VHOST" -G $URL > $InkTmp 2>> ${InkTmp}-2
#bit a monkeybusiness with COLOR here because the variable doesn't propagate back from the sub-shells
if test $? -eq 0
then
echo "" >> ${InkTmp}-2
COLOR="green"; export COLOR
$GREP CARTRIDGE $InkTmp | $SED -r 's/<[^>]*>| //g' | $SED 's/ CARTRIDGE/ _CARTRIDGE: /' | tee -a ${InkTmp}-2 | $SED 's/%//' | while read x
do
if test $COLOR != "red"
then
set $x
if test $2 -le 10
then
COLOR="yellow"
fi
fi
echo $COLOR > ${InkTmp}-color
done
fi
#
#THE FIRST LINE IS STATUS INFORMATION .....STRUCTURE IMPORTANT!
#THE REST IS FREE-FORM - WHATEVER YOU'D LIKE TO SEND ....
#
LINE="status ${HOST}.${TEST} `cat ${InkTmp}-color` `date`
<code>`cat ${InkTmp}-2`</code>"
$RM -f $InkTmp ${InkTmp}-2 ${InkTmp}-color
#NOW USE THE BB COMMAND TO SEND THE DATA ACROSS
$BB $BBDISP "$LINE" #SEND IT TO BBDISPLAY
++++++++++++++++++++++++++++++++++++++++++++++++++
#!/bin/sh
#toner
#
#BIG BROTHER - monitor HP printer ink levels
#
HOSTIP=$1; export HOSTIP
HOST=$2; export HOST
VHOST=$3; export VHOST
InkTmp=$BBTMP/toner.$$; export InkTmp
COLOR="blue"; export COLOR
echo $COLOR > ${InkTmp}-color
URL="http://${HOSTIP}/hp/device/this.LCDispatcher?nav=hp.DeviceStatus";
echo "URL: $URL" > ${InkTmp}-2
echo "" >> ${InkTmp}-2
/usr/bin/curl -w "$SS_LOGCURL" -m 120 -H "Host: $VHOST" -G $URL > $InkTmp 2>> ${InkTmp}-2
#bit a monkeybusiness with COLOR here because the variable doesn't propagate back from the sub-shells
if test $? -eq 0
then
echo "" >> ${InkTmp}-2
COLOR="green"; export COLOR
$GREP CARTRIDGE $InkTmp | $SED -r 's/<[^>]*>| //g' | $SED 's/ CARTRIDGE/ _CARTRIDGE: /' | tee -a ${InkTmp}-2 | $SED 's/%//' | while read x
do
if test $COLOR != "red"
then
set $x
if test $2 -le 10
then
COLOR="yellow"
fi
fi
echo $COLOR > ${InkTmp}-color
done
fi
#
#THE FIRST LINE IS STATUS INFORMATION .....STRUCTURE IMPORTANT!
#THE REST IS FREE-FORM - WHATEVER YOU'D LIKE TO SEND ....
#
LINE="status ${HOST}.${TEST} `cat ${InkTmp}-color` `date` <code> `cat ${InkTmp}-2`</code>"
$RM -f $InkTmp ${InkTmp}-2 ${InkTmp}-color
#NOW USE THE BB COMMAND TO SEND THE DATA ACROSS
$BB $BBDISP "$LINE" #SEND IT TO BBDISPLAY
list dOCtoR MADneSs
On Thu, 11 Mar 2010 13:14:02 +0000 (GMT), Nelson Amaral <user-eeda269dc555@xymon.invalid> wrote:
Hi, I would like to monitor my mysql servers with hobbit with graphs to show trends, etc. Does anyone know a good way to do this, i tried the one from the link below but it only gives me the values, i would really like the graphs.
http://www.phpprogrammer.co.nz/how-to-setup-hobbit-including-mysql-graphs
by the way hobbit is the perfect monitoring tool i just love it Regards Nelson Amaral
Hello, On my side I'm using Charles Goyard's mysql monitoring plugin, available here : http://www.trantor.org/xymonton/doku.php/monitors:bb-mysql You can easily configure your Xymon server in order to get graphs from different values. Here are the data you can get with : threads, questions, slow queries, opens, flush tables, open tables, queries per second avg and maxcon Regards, Damien