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.