number of datasources in RRD's created by NCV
list Dennis Ortsen
Hi all, I've added a custom test to a host that sends (performance) information about the mysql daemon that's running on it. The data on the status page of that mysql test looks like this: threads : 53 queries per sec : 386 slow queries : 0 All values are absolute (GAUGE) so I added this NCV tag in hobbitserver.cfg: NCV_mysql="threads:GAUGE,queriespersec:GAUGE,slowqueries:GAUGE" I also added "mysql=ncv" to the TEST2RRD list in hobbitserver.cfg I kicked the hobbit daemons so the hobbitserver.cfg file would be read again. The RRD file is created on the hobbit server after the client has sent its data. When I check with `rrdtool dump mysql.rrd` I only see the first two datasources (threads and queriespersec). The third/last datasource isn't created/updated in the RRD file, although you'd expect that according to the NCV_mysql tag in hobbitserver.cfg. Is there a limitation in the maximum number of datasources the NCV graphing can handle? I'm running hobbit 4.2.0 on both client and server BTW. Thanks in advance, Br. Dennis
list Dominique Frise
You are probably missing a carriage return after the last value of the status message. Dominique UNIL - University of Lausanne
▸
Dennis Ortsen wrote:Hi all, I've added a custom test to a host that sends (performance) information about the mysql daemon that's running on it. The data on the status page of that mysql test looks like this: threads : 53 queries per sec : 386 slow queries : 0 All values are absolute (GAUGE) so I added this NCV tag in hobbitserver.cfg: NCV_mysql="threads:GAUGE,queriespersec:GAUGE,slowqueries:GAUGE" I also added "mysql=ncv" to the TEST2RRD list in hobbitserver.cfg I kicked the hobbit daemons so the hobbitserver.cfg file would be read again. The RRD file is created on the hobbit server after the client has sent its data. When I check with `rrdtool dump mysql.rrd` I only see the first two datasources (threads and queriespersec). The third/last datasource isn't created/updated in the RRD file, although you'd expect that according to the NCV_mysql tag in hobbitserver.cfg. Is there a limitation in the maximum number of datasources the NCV graphing can handle? I'm running hobbit 4.2.0 on both client and server BTW. Thanks in advance, Br. Dennis
list Trent Melcher
▸
On Fri, 2007-10-26 at 10:18 +0200, Dennis Ortsen wrote:
Hi all, I've added a custom test to a host that sends (performance) information about the mysql daemon that's running on it. The data on the status page of that mysql test looks like this: threads : 53 queries per sec : 386 slow queries : 0 All values are absolute (GAUGE) so I added this NCV tag in hobbitserver.cfg: NCV_mysql="threads:GAUGE,queriespersec:GAUGE,slowqueries:GAUGE" I also added "mysql=ncv" to the TEST2RRD list in hobbitserver.cfg I kicked the hobbit daemons so the hobbitserver.cfg file would be read again. The RRD file is created on the hobbit server after the client has sent its data. When I check with `rrdtool dump mysql.rrd` I only see the first two datasources (threads and queriespersec). The third/last datasource isn't created/updated in the RRD file, although you'd expect that according to the NCV_mysql tag in hobbitserver.cfg. Is there a limitation in the maximum number of datasources the NCV graphing can handle?
No limitation that I know of..... Did you happen to add the slowqueries value after the mysql.rrd was alreay created with the first 2? If so you may need to delete the rrd file and let it recreate it. Trent
▸
I'm running hobbit 4.2.0 on both client and server BTW. Thanks in advance, Br. Dennis
list Dennis Ortsen
Onderwerp: Re: [hobbit] number of datasources in RRD's created by NCV You are probably missing a carriage return after the last value of the status message.
That's it! after adding a <cr> in the status message the third datasource is also created in the rrd (I deleted the rrd and let hobbit create a new one). thanks! Dennis
▸
Dominique UNIL - University of Lausanne Dennis Ortsen wrote:Hi all,I've added a custom test to a host that sends (performance) information about the mysql daemon that's running on it. The data on the status page of that mysql test looks like this: threads : 53 queries per sec : 386 slow queries : 0 All values are absolute (GAUGE) so I added this NCV tag in hobbitserver.cfg: NCV_mysql="threads:GAUGE,queriespersec:GAUGE,slowqueries:GAUGE" I also added "mysql=ncv" to the TEST2RRD list in hobbitserver.cfg I kicked the hobbit daemons so the hobbitserver.cfg file would be read again. The RRD file is created on the hobbit server after the client has sent its data. When I check with `rrdtool dump mysql.rrd` I only see the first two datasources (threads and queriespersec). The third/last datasource isn't created/updated in the RRD file, although you'd expect that according to the NCV_mysql tag in hobbitserver.cfg. Is there a limitation in the maximum number of datasources the NCV graphing can handle? I'm running hobbit 4.2.0 on both client and server BTW. Thanks in advance, Br. Dennis