[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Newbie question: have (looks like) valid rrd data, can't get the graph to appear in the status page
- To: "Hobbit mailing list" <hobbit (at) hswn.dk>
- Subject: Newbie question: have (looks like) valid rrd data, can't get the graph to appear in the status page
- From: "John Burk" <john.d.burk (at) gmail.com>
- Date: Tue, 29 Apr 2008 14:04:16 -0700
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=naAFbHLQYe/JyToeDi2BiXQCr7X41u1iZGxHpgaf5aA=; b=ffk311okFfy6pEYxcPXpnz7jIVkZ8Q3ZtJeqQSxSmzgXMp6PlpXh+9TbEFemvggPlz8z9WFxj0nuA6bH2rq+ZL8ZHF8j6pVrnsoRjiNO18XJ4abpwPdFHBjCTnQn2PKUzqfAePT8ZLKoriRyrgQu9DDVVRDWjq3sSg0ffm5thoU=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Wn0PiOSpZaG0Z7UxN4l13hy+Fm8fo/F8AM0WM+x0BSRcXduOoeUo7AKUL0mZQ1RFzjwLrUK2tFu4UPVJye3b/V7Y2wGaGJocvBvVJrBUYdC31A5rpYehn4lVr86mvygmMTaB7UMpTm15+0YlgqUZ90dkuiS34iAcib0Ac/pNf2A=
Can someone see what I'm missing? I get a 'hobbit graph ncv:mysl'
link in the mysql status and trends pages, but no graph.
here's the data as it appears in the status page:
(ignore the low values for ThreadsCreated and OpenedTables, these
are values over the last sample interval - could probably have done this with
a DERIVE rrd dataType - I do the calcs in my collection script)
=====================================
QueriesPerSecAvg:5177
QueriesPerSec:1851
ThreadsConnected:396
ThreadsCreated:0
OpenFiles:19751
OpenTables:12500
OpenedTables:0
=====================================
here's my block from hobbitgraph.cfg:
=====================================
[mysql]
TITLE MySQL Queries Per Second
YAXIS #
DEF:qpsavg=mysql.rrd:QueriesPerSecAvg:GAUGE
DEF:qps=mysql.rrd:QueriesPerSec:GAUGE
LINE2:qpsavg#0C0C0C:QpsAvg
LINE2:qps#C0C0C0:Qps
GPRINT:qpsavg:LAST: \: %5.1lf (cur)
GPRINT:qpsavg:MAX: \: %5.1lf (max)
GPRINT:qpsavg:MIN: \: %5.1lf (min)
GPRINT:qpsavg:AVERAGE: \: %5.1lf (avg)\n
GPRINT:qps:LAST: \: %5.1lf (cur)
GPRINT:qps:MAX: \: %5.1lf (max)
GPRINT:qps:MIN: \: %5.1lf (min)
GPRINT:qps:AVERAGE: \: %5.1lf (avg)\n
=====================================
hobbitserver.cfg:
=====================================
TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendmail,mailq,nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,files,procs=processes,ports,clock,lines,mysql=ncv"
NCV_mysql="*:GAUGE"
GRAPHS="la,vmstat,memory,processes,inode,qtree,files,users,disk,iostat,tcp.http,tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,bind,sendmail,mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines,mysql"
=====================================
bb-hosts.cfg
=====================================
xx.xx.xx.xx greenjeans # conn mysql TRENDS:*,!tcp,!netstat2
=====================================
here's the output of "rrdtool info ../../data/rrd/greenjeans/mysql.rrd"
=====================================
filename = "../../data/rrd/greenjeans/mysql.rrd"
rrd_version = "0003"
step = 300
last_update = 1209502058
ds[QueriesPerSecAvg].type = "GAUGE"
ds[QueriesPerSecAvg].minimal_heartbeat = 600
ds[QueriesPerSecAvg].min = 0.0000000000e+00
ds[QueriesPerSecAvg].max = NaN
ds[QueriesPerSecAvg].last_ds = "5186"
ds[QueriesPerSecAvg].value = 8.1958000000e+05
ds[QueriesPerSecAvg].unknown_sec = 0
ds[QueriesPerSec].type = "GAUGE"
ds[QueriesPerSec].minimal_heartbeat = 600
ds[QueriesPerSec].min = 0.0000000000e+00
ds[QueriesPerSec].max = NaN
ds[QueriesPerSec].last_ds = "1386"
ds[QueriesPerSec].value = 2.5088800000e+05
ds[QueriesPerSec].unknown_sec = 0
ds[ThreadsConnected].type = "GAUGE"
ds[ThreadsConnected].minimal_heartbeat = 600
ds[ThreadsConnected].min = 0.0000000000e+00
ds[ThreadsConnected].max = NaN
ds[ThreadsConnected].last_ds = "374"
ds[ThreadsConnected].value = 6.0887000000e+04
ds[ThreadsConnected].unknown_sec = 0
ds[ThreadsCreated].type = "GAUGE"
ds[ThreadsCreated].minimal_heartbeat = 600
ds[ThreadsCreated].min = 0.0000000000e+00
ds[ThreadsCreated].max = NaN
ds[ThreadsCreated].last_ds = "0"
ds[ThreadsCreated].value = 0.0000000000e+00
ds[ThreadsCreated].unknown_sec = 0
ds[OpenFiles].type = "GAUGE"
ds[OpenFiles].minimal_heartbeat = 600
ds[OpenFiles].min = 0.0000000000e+00
ds[OpenFiles].max = NaN
ds[OpenFiles].last_ds = "19685"
ds[OpenFiles].value = 3.1083160000e+06
ds[OpenFiles].unknown_sec = 0
ds[OpenTables].type = "GAUGE"
ds[OpenTables].minimal_heartbeat = 600
ds[OpenTables].min = 0.0000000000e+00
ds[OpenTables].max = NaN
ds[OpenTables].last_ds = "12500"
ds[OpenTables].value = 1.9750000000e+06
ds[OpenTables].unknown_sec = 0
ds[OpenedTables].type = "GAUGE"
ds[OpenedTables].minimal_heartbeat = 600
ds[OpenedTables].min = 0.0000000000e+00
ds[OpenedTables].max = NaN
ds[OpenedTables].last_ds = "0"
ds[OpenedTables].value = 7.8000000000e+01
ds[OpenedTables].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 576
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[0].cdp_prep[1].value = NaN
rra[0].cdp_prep[1].unknown_datapoints = 0
rra[0].cdp_prep[2].value = NaN
rra[0].cdp_prep[2].unknown_datapoints = 0
rra[0].cdp_prep[3].value = NaN
rra[0].cdp_prep[3].unknown_datapoints = 0
rra[0].cdp_prep[4].value = NaN
rra[0].cdp_prep[4].unknown_datapoints = 0
rra[0].cdp_prep[5].value = NaN
rra[0].cdp_prep[5].unknown_datapoints = 0
rra[0].cdp_prep[6].value = NaN
rra[0].cdp_prep[6].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 576
rra[1].pdp_per_row = 6
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = 1.5580810000e+04
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[1].cdp_prep[1].value = 4.7480566667e+03
rra[1].cdp_prep[1].unknown_datapoints = 0
rra[1].cdp_prep[2].value = 4.0307553957e+02
rra[1].cdp_prep[2].unknown_datapoints = 2
rra[1].cdp_prep[3].value = 0.0000000000e+00
rra[1].cdp_prep[3].unknown_datapoints = 2
rra[1].cdp_prep[4].value = 1.9674374101e+04
rra[1].cdp_prep[4].unknown_datapoints = 2
rra[1].cdp_prep[5].value = 1.2499100719e+04
rra[1].cdp_prep[5].unknown_datapoints = 2
rra[1].cdp_prep[6].value = 1.0107913669e+00
rra[1].cdp_prep[6].unknown_datapoints = 2
rra[2].cf = "AVERAGE"
rra[2].rows = 576
rra[2].pdp_per_row = 24
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = 4.6847800000e+04
rra[2].cdp_prep[0].unknown_datapoints = 0
rra[2].cdp_prep[1].value = 1.3392856667e+04
rra[2].cdp_prep[1].unknown_datapoints = 0
rra[2].cdp_prep[2].value = 1.6543988729e+03
rra[2].cdp_prep[2].unknown_datapoints = 5
rra[2].cdp_prep[3].value = 5.0000000000e-02
rra[2].cdp_prep[3].unknown_datapoints = 5
rra[2].cdp_prep[4].value = 7.8531830767e+04
rra[2].cdp_prep[4].unknown_datapoints = 5
rra[2].cdp_prep[5].value = 4.9999100719e+04
rra[2].cdp_prep[5].unknown_datapoints = 5
rra[2].cdp_prep[6].value = 1.4874580336e+00
rra[2].cdp_prep[6].unknown_datapoints = 5
rra[3].cf = "AVERAGE"
rra[3].rows = 576
rra[3].pdp_per_row = 288
rra[3].xff = 5.0000000000e-01
rra[3].cdp_prep[0].value = 1.7319647667e+05
rra[3].cdp_prep[0].unknown_datapoints = 216
rra[3].cdp_prep[1].value = 5.8770938095e+04
rra[3].cdp_prep[1].unknown_datapoints = 216
rra[3].cdp_prep[2].value = 1.0685098873e+04
rra[3].cdp_prep[2].unknown_datapoints = 221
rra[3].cdp_prep[3].value = 7.9333333333e-01
rra[3].cdp_prep[3].unknown_datapoints = 221
rra[3].cdp_prep[4].value = 5.4433304886e+05
rra[3].cdp_prep[4].unknown_datapoints = 221
rra[3].cdp_prep[5].value = 3.4992956739e+05
rra[3].cdp_prep[5].unknown_datapoints = 221
rra[3].cdp_prep[6].value = 1.1470791367e+01
rra[3].cdp_prep[6].unknown_datapoints = 221
=====================================
john burk