<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
tt
{font-family:"Courier New";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=blue>
<div class=Section1>
<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>“</span></font>Our test script provides data that goes
up and down in value (it is the number of bytes of memory used for a Linux
kernel bufffer), and for that kind of data we'll use the RRD <b><span
style='font-weight:bold'>GAUGE</span></b> datatype. So we add an extra setting
to hobbitserver.cfg:<o:p></o:p></p>
<pre><tt><font size=2 face="Courier New"><span style='font-size:10.0pt'><o:p> </o:p></span></font></tt></pre><pre><tt><font
size=2 face="Courier New"><span style='font-size:10.0pt'> NCV_slab="inodecache:GAUGE,dentrycache:GAUGE"<o:p></o:p></span></font></tt></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>This tells the hobbitd_rrd module that it should create an RRD file with two datasets of type GAUGE instead of the default (DERIVE). The setting must be named NCV_<columnname>.</span></font><font
color=navy face=Arial><span style='font-family:Arial;color:navy'>” – from help > custom graphs<o:p></o:p></span></font></pre><pre><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><o:p> </o:p></span></font></pre><pre><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>If you do this then it should work properly<o:p></o:p></span></font></pre><pre><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Jason.<o:p></o:p></span></font></pre>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
Sabeer MZ [mailto:sabeer.mz@gmail.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> 06 March 2007 10:19<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">hobbit@hswn.dk</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [hobbit] mysql
connections</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
I am not getting data on my graphs. How to clear the old mysql.rrd and create a
new one ?<br>
<br>
pls find below mysql entries on hobbitserver.cfg and let me know if i have to
add anything.<br>
I am using hobbit </span></font><b><font size=1 color=silver face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:silver;font-weight:bold'><a
href="http://hobbitmon.sourceforge.net/"><span style='text-decoration:none'>Hobbit
Monitor 4.3.0-20061124</span></a></span></font></b><br>
<br>
[hobbit@abc etc]$ grep mysql hobbitserver.cfg<br>
<br>
TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tcp,
<br>
dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendmail,mailq,<br>
nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,files,procs=processes,<br>
ports,clock,lines",mysql=ncv" <br>
<br>
GRAPHS="la,mysql,disk,inode,qtree,files,processes,memory,users,vmstat,iostat,tcp.http,<br>
tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,bind,sendmail,mailq,socks,<br>
bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines" <br>
<br>
thanks<br>
Sabeer MZ<o:p></o:p></p>
<div>
<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 3/6/07, <b><span style='font-weight:bold'>Jones,
Jason (Altrincham)</span></b> <<a href="mailto:JasonAS_Jones@mentor.com">JasonAS_Jones@mentor.com</a>>
wrote:</span></font></span> <o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>One other thing is that I'm
mostly half sure that you will want GAUGE<br>
data types not DERIVE since derive assumes the value will always <br>
increase (I can't remember why this is the case) whereas gauge can<br>
increase and decrease. What changes have you made to
hobbitserver.cfg<br>
for this test?<br>
<br>
Jason.<br>
<br>
-----Original Message-----<br>
From: Stef Coene [mailto: <a href="mailto:stef.coene@docum.org">stef.coene@docum.org</a>]<br>
Sent: 06 March 2007 08:32<br>
To: <a href="mailto:hobbit@hswn.dk">hobbit@hswn.dk</a><br>
Subject: Re: [hobbit] mysql connections<br>
<br>
On Tuesday 06 March 2007 06:44, Sabeer MZ wrote: <br>
> good suggestion. i got one more clue.-<br>
><br>
> Use of uninitialized value in concatenation (.) or string at<br>
> bb-mysql.plline 119.<br>
> "config bb-mysql.cfg-"sh: config bb-mysql.cfg-:
command not found<br>
><br>
> this is showing that BB/Hobbit variables are not set.<br>
> So Where is the soure profile that We need to execute to get these<br>
> variables.<br>
> or how to set bb/hobbit env varibales. <br>
The hobbit variables are set with the "bbcmd"
command. That's why you<br>
have to<br>
execute "../bin/bbcmd perl bb-mysql.pl".<br>
<br>
For the error, on line 119, you will find
"system($cmd);". You can add <br>
the<br>
line "print $cmd" before this line. This will print the
command that<br>
will be<br>
executed when you run the script. Check the command for errors or<br>
missing<br>
options.<br>
<br>
<br>
Stef<br>
<br>
To unsubscribe from the hobbit list, send an e-mail to <br>
<a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk</a><br>
<br>
<br>
<br>
To unsubscribe from the hobbit list, send an e-mail to<br>
<a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk </a><br>
<br>
<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
Warm Regards<br>
Sabeer MZ <o:p></o:p></span></font></p>
</div>
</body>
</html>