bug : reload of hobbitlaunch.cfg on trunk
Hello,
I defined several jobs in hobbitlaunch.cfg, all DISABLED. I fired up hobbit, and then started enabling those jobs one by one.
I do see in hobbitlaunch.log a "Loading tasklist configuration from ..." a couple seconds after saving the new version of hobbitlaunch.cfg
But the job never starts.
And even stranger : enabling/disabling an ENABLED job does work normaly.
Right now, i working arround this, by doing a stop/start of hobbit.
Olivier Beau
Hi all,
I have set up a 'mysql' status check as an external script: ~hobbit/client/ext/bb-mysqlstatus.sh
It sends up several informational lines (see below), only some of which I want to graph.
I only want to graph "Threads", "Slow queries", and "Open Tables".
If I only send up the 3 lines I want to graph, everything works as desired. However, if I add more lines, the graph stops working. I'm guessing that I need to add something somewhere to tell RRD to ignore the lines I don't want to graph... but where/how?
mysqlstatus.sh sends the following (and shows on the 'mysql' column page):
Uptime : 2
Threads : 4
Questions : 6
Slow queries : 9
Opens : 2
Flush tables : 6
Open tables : 9
Queries/second avg : 8
I modified hobbitserver.cfg and
added "mySQL=ncv" to the end of the TEST2RRD="cpu=la,...,lines,mysql=ncv"
added the line: NCV_mysql="Threads:GAUGE,Slowqueries:GAUGE,Opentables:GAUGE"
I also added the following to hobbitgraph.cfg
[mysql] TITLE MySQL Statistics YAXIS Number of DEF:threads=mysql.rrd:Threads:AVERAGE DEF:slow=mysql.rrd:Slowqueries:AVERAGE DEF:opentables=mysql.rrd:Opentables:AVERAGE LINE2:threads#FF0000:Threads LINE2:slow#00CCCC:Slow Queries LINE2:opentables#FF00FF:Opentables COMMENT:\n GPRINT:threads:LAST:Threads \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n GPRINT:slow:LAST:SlowQueries \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n GPRINT:opentables:LAST:OpenTables \: %5.1lf (cur) GPRINT:opentables:MAX: \: %5.1lf (max) GPRINT:opentables:MIN: \: %5.1lf (min) GPRINT:opentables:AVERAGE: \: %5.1lf (avg)\n
Googling around didn't produce any useful results; can someone shed some light?
Thanks Tom
Tom Brand CVS/pharmacy IS Rx SysAdmin Store Support
STATEMENT OF CONFIDENTIALITY Information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please destroy all copies of this message and any attachments and advise sender (TRBrand at cvs.com)
On Friday 12 December 2008, Brand, Thomas R. wrote:
Hi all,
I have set up a 'mysql' status check as an external script: ~hobbit/client/ext/bb-mysqlstatus.sh
It sends up several informational lines (see below), only some of which I want to graph.
I only want to graph "Threads", "Slow queries", and "Open Tables".
If I only send up the 3 lines I want to graph, everything works as desired. However, if I add more lines, the graph stops working. I'm guessing that I need to add something somewhere to tell RRD to ignore the lines I don't want to graph... but where/how? If an rrd is created, the number of counters is fixed. So, if you initally used 3 counters, the rrd is for these 3 counters. If you later send on a status message with 5 counters, the rrd will not be updated because it does not match. I have a script to add a DS to an existing rrd. An other option is throw away the existing rrd.
So, never change the number of counters in a rrd. Or the name of the counters.
Stef
Thanks for the info Stef. I've figured out a few more things too....
Turns out a lot of my problems were caused by three reasons:
as you state, I had to remove the existing mysql.rrd file
one of the NCV records contained a '%' in the name... eg: 'Buffer Pool %' which caused nothing to be graphed; the values in the rrd file (as shown by rrdtool dump mySQL.rrd were 'NAN'
I also found out that one must mention ALL the named values being sent up by the client, in hobbitserver.cfg. If the value is not to be graphed, one can use the flag "NONE"
example: NCV_mysql="Threads:GAUGE,SlowQueries:GAUGE,OpenTables:GAUGE,FlushTables: NONE,Questions:NONE,Opens:NONE,AvgQuerysPerSecond:NONE"
I now have three values graphed and the rest are only displayed in the text area -- not graphed.
Which is what I was looking for :)
Thanks for the help, Tom
-----Original Message----- From: Stef Coene [mailto:stef.coene at docum.org] Sent: Friday, December 12, 2008 2:02 PM To: hobbit at hswn.dk Subject: Re: [hobbit] rrd graphing questions - how to ignore items?
If an rrd is created, the number of counters is fixed. So, if you initally used 3 counters, the rrd is for these 3 counters. If you later send on a status message with 5 counters, the rrd will not be updated because it does not match. I have a script to add a DS to an existing rrd. An other option is throw away the existing rrd.
So, never change the number of counters in a rrd. Or the name of the counters.
participants (3)
-
obeau79@gmail.com
-
stef.coene@docum.org
-
TRBrand@cvs.com