forgot to say my e-mail:<br><br><a href="mailto:camorae@googlemail.com">camorae@googlemail.com</a><br><br><br>thx<br><br><br><br><br><br><div class="gmail_quote">2009/6/3 Cayo de Moraes <span dir="ltr"><<a href="mailto:camorae@googlemail.com">camorae@googlemail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Tom Brand,<br><br>can you please send me your mysqlstat script? I realy need to fix this issue as fast as possible... til now I couldnt solve this. I hope with your script I can make it work.<b><b><i><font size="5" face="Monotype Corsiva"><span style="font-size: 18pt; font-family: "Monotype Corsiva"; font-style: italic;"></span></font></i></b></b><br>
<br>TIA,<br><br>Cayo de Moraes<br><br><br><br><br><br><div class="gmail_quote"><div class="im">2009/5/27 Brand, Thomas R. <span dir="ltr"><<a href="mailto:TRBrand@cvs.com" target="_blank">TRBrand@cvs.com</a>></span><br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div><div>
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;">> After editing the hobbitserver.cfg and hobbitgraph.cfg i had some
confrontations with:<div><div></div><div class="h5"><br>
><br>
> how should i configure the parameters of the hobbitserver.cfg and
hobbitgraph.cfg if i want 3 diferent </div></div></span></font></p><div><div></div><div class="h5">
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;">> 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 color="blue" size="2"><span style="font-size: 10pt; color: blue;"></span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
</div></div></div><div><div></div><div class="h5"><p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;">I can’t help with the multiple graphs
on one page; I have mine set up for one graph on the page.</span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; 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 …. )</span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;">Here are the relevant parts from
hobbitserver.cfg:</span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; 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"</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; 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"</span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;">Here is the stanza from </span></font><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">my hobbitgraph.cfg</span></font><font color="blue" size="2"><span style="font-size: 10pt; color: blue;"> for the mysql graphs:</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">[mysql]</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
TITLE MySQL Statistics</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
YAXIS Number of</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
DEF:threads=mysql.rrd:Threads:AVERAGE</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
DEF:slow=mysql.rrd:SlowQueries:AVERAGE</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
DEF:opentables=mysql.rrd:OpenTables:AVERAGE</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
LINE2:threads#FF0000:Threads</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
LINE2:slow#00CCCC:Slow Queries</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
LINE2:opentables#FF00FF:Open Tables</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
COMMENT:\n</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:threads:LAST:Threads \: %5.1lf (cur)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:threads:MAX: \: %5.1lf (max)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:threads:MIN: \: %5.1lf (min)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:slow:LAST:Slow Queries\: %5.1lf (cur)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:slow:MAX: \: %5.1lf (max)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:slow:MIN: \: %5.1lf (min)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:opentables:LAST:Open Tables \: %5.1lf (cur)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:opentables:MAX: \: %5.1lf (max)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:opentables:MIN: \: %5.1lf (min)</span></font></p>
<p><font color="blue" size="2" face="Courier New"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">
GPRINT:opentables:AVERAGE: \: %5.1lf (avg)\n</span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;">The client side extension script sends up
the information which is then displayed as:</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</span></font></b></h3>
<pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Threads : 10 </span></font></pre><pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Slow Queries : 1 </span></font></pre>
<pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Open Tables : 89 </span></font></pre><pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Flush Tables : 1 </span></font></pre>
<pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Questions : 83279 </span></font></pre><pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Opens : 94 </span></font></pre>
<pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">AvgQuerysPerSecond : 2.455 </span></font></pre><pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Uptime : 33923 </span></font></pre>
<pre style="margin-left: 1.5in;"><font size="2" face="Courier New"><span style="font-size: 10pt;">Free Buffer Pool : 62 </span></font></pre>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"><img src="cid:image001.jpg@01C9DEB9.9A0FE9E0" width="673" height="255"></span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;">Hope this helps,</span></font></p>
<p><b><b><i><font size="5" face="Monotype Corsiva"><span style="font-size: 18pt; font-family: "Monotype Corsiva"; font-style: italic;">Tom
Brand<font color="blue"><span style="color: blue;"></span></font></span></font></i></b></b></p>
<p><i><b><i><font color="red" size="2" face="Verdana"><span style="font-size: 10pt; font-family: Verdana; color: red; font-weight: bold;">CVS/pharmacy</span></font></i></b></i></p>
<p><i><i><font size="2" face="Verdana"><span style="font-size: 10pt; font-family: Verdana;">IS Rx SysAdmin Store Support</span></font></i></i></p>
<p><font color="blue" size="2" face="Times New Roman"><span style="font-size: 10pt; color: blue;"> </span></font></p>
<div style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; border-width: medium medium medium 1.5pt; padding: 0in 0in 0in 4pt;"><div>
<div>
<div style="text-align: center;" align="center"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">
<hr align="center" size="3" width="100%">
</span></font></div>
<p><b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma;"> Cayo de Moraes
[mailto:<a href="mailto:camorae@googlemail.com" target="_blank">camorae@googlemail.com</a>] <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> <a href="mailto:hobbit@hswn.dk" target="_blank">hobbit@hswn.dk</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> [hobbit] Problem with
external script and RRD-Graphs</span></font></p>
</div>
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div><p><font size="3" face="Times New Roman"><span style="font-size: 12pt;">Hi guys,<div><div></div><div><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</div></div></span></font></p>
</div>
</div></div></div>
</div>
</blockquote></div><br>
</blockquote></div><br>