<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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Monotype Corsiva";
panose-1:3 1 1 1 1 2 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h3
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:13.5pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.ComputerOutput, li.ComputerOutput, div.ComputerOutput
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
font-weight:bold;}
p.ComputerText, li.ComputerText, div.ComputerText
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
text-indent:-.25in;
mso-list:l1 level1 lfo2;
font-size:10.0pt;
font-family:"Courier New";
color:blue;
font-weight:bold;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Times New Roman";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1;
mso-list-template-ids:-1958160256;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-tab-stop:.75in;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l0:level3
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
margin-left:1.0in;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:1.25in;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
margin-left:1.5in;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:1.75in;
mso-level-number-position:left;
margin-left:1.75in;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
margin-left:2.0in;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:2.25in;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
margin-left:2.5in;
text-indent:-.25in;}
@list l1
{mso-list-id:1233467994;
mso-list-type:hybrid;
mso-list-template-ids:-1498099050 1406286398 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-style-link:"Computer Text";
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:117.0pt;
mso-level-number-position:right;
margin-left:117.0pt;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>> After editing the hobbitserver.cfg and hobbitgraph.cfg i had some
confrontations with:<br>
><br>
> how should i configure the parameters of the hobbitserver.cfg and
hobbitgraph.cfg if i want 3 diferent <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>> graphs in one page, when the graph name has to be the same as the
column name?<br>
><br>
> when trying to get the only graph into the browser i get only an 1x1 Pixel
graph...</span></font><font size=2 color=blue><span style='font-size:10.0pt;
color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'>I can’t help with the multiple graphs
on one page; I have mine set up for one graph on the page.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'>If you’re intererested, I can send
you my version of bb-mysqlstat.sh (heavily modified from the one available on
Deadcat.net …. )<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'>Here are the relevant parts from
hobbitserver.cfg:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>NCV_mysql="Threads:GAUGE,SlowQueries:GAUGE,OpenTables:GAUGE,FlushTables:NONE,Questions:NONE,Opens:NONE,AvgQuerysPerSecond:NONE,Uptime:NONE,FreeBufferPool:NONE"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>GRAPHS="la,disk,inode,qtree,files,processes,memory,users,vmstat,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"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'>Here is the stanza from </span></font><font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:blue'>my hobbitgraph.cfg</span></font><font size=2
color=blue><span style='font-size:10.0pt;color:blue'> for the mysql graphs:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>[mysql]<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
TITLE MySQL Statistics<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
YAXIS Number of<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
DEF:threads=mysql.rrd:Threads:AVERAGE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
DEF:slow=mysql.rrd:SlowQueries:AVERAGE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
DEF:opentables=mysql.rrd:OpenTables:AVERAGE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
LINE2:threads#FF0000:Threads<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
LINE2:slow#00CCCC:Slow Queries<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
LINE2:opentables#FF00FF:Open Tables<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
COMMENT:\n<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:threads:LAST:Threads \: %5.1lf (cur)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:threads:MAX: \: %5.1lf (max)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:threads:MIN: \: %5.1lf (min)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:slow:LAST:Slow Queries\: %5.1lf (cur)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:slow:MAX: \: %5.1lf (max)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:slow:MIN: \: %5.1lf (min)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:opentables:LAST:Open Tables \: %5.1lf (cur)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:opentables:MAX: \: %5.1lf (max)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:opentables:MIN: \: %5.1lf (min)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>
GPRINT:opentables:AVERAGE: \: %5.1lf (avg)\n<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'>The client side extension script sends up
the information which is then displayed as:<o:p></o:p></span></font></p>
<h3><b><font size=4 face="Times New Roman"><span style='font-size:13.5pt'>Wed
May 27 10:12:53 EDT 2009 - mySQL is OK<o:p></o:p></span></font></b></h3>
<pre style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Threads : 10 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Slow Queries : 1 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Open Tables : 89 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Flush Tables : 1 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Questions : 83279 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Opens : 94 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>AvgQuerysPerSecond : 2.455 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Uptime : 33923 <o:p></o:p></span></font></pre><pre
style='margin-left:1.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Free Buffer Pool : 62 <o:p></o:p></span></font></pre>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><img width=673 height=255 id="_x0000_i1026"
src="cid:image001.jpg@01C9DEB9.9A0FE9E0"><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'>Hope this helps,<o:p></o:p></span></font></p>
<p class=MsoNormal><strong><b><i><font size=5 face="Monotype Corsiva"><span
style='font-size:18.0pt;font-family:"Monotype Corsiva";font-style:italic'>Tom
Brand<font color=blue><span style='color:blue'><o:p></o:p></span></font></span></font></i></b></strong></p>
<p class=MsoNormal><em><b><i><font size=2 color=red face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:red;font-weight:bold'>CVS/pharmacy</span></font></i></b></em><o:p></o:p></p>
<p class=MsoNormal><em><i><font size=2 face=Verdana><span style='font-size:
10.0pt;font-family:Verdana'>IS Rx SysAdmin Store Support</span></font></i></em><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face="Times New Roman"><span
style='font-size:10.0pt;color:blue'><o:p> </o:p></span></font></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=3 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Cayo de Moraes
[mailto:camorae@googlemail.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, May 27, 2009 5:06
AM<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> [hobbit] Problem with
external script and RRD-Graphs</span></font><o:p></o:p></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><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi guys,<br>
<br>
im trying to monitor some mysql performances like slowqueries, threads, queries
per second, etc. trought an external script. So far i get all results from the
client (Big Brother-Client) unless the graphs. Using big brother (server) i get
3 graphs (slowqueries, threads and queries per second) but after migrating BB
to Hobbit i cant get any graph anymore. I already did all steps from "How
to setup custom graphs" but its not working.<br>
<br>
Did i forget something / did something wrong or is it with the BB-Client not
possible?<br>
<br>
<br>
<br>
After editing the hobbitserver.cfg and hobbitgraph.cfg i had some
confrontations with:<br>
<br>
how should i configure the parameters of the hobbitserver.cfg and
hobbitgraph.cfg if i want 3 diferent graphs in one page, when the graph name has
to be the same as the column name?<br>
<br>
when trying to get the only graph into the browser i get only an 1x1 Pixel
graph... <br>
<br>
has anybody any idea??<br>
<br>
TIA<o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>