<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 12 (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]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
h3
{mso-style-priority:9;
mso-style-link:"Heading 3 Char";
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","serif";
font-weight:bold;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.gmailquote
{mso-style-name:gmail_quote;}
span.Heading3Char
{mso-style-name:"Heading 3 Char";
mso-style-priority:9;
mso-style-link:"Heading 3";
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:bold;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Nuts! I’ve replaced and copied the data you pasted here, but I’m
still having now luck getting the rrd graph for it to appear! </span><span
style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>L</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> I
just tried upgrading to the latest snapshot of hobbit too, to see if it would
get me lucky. Oh well,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thanks for trying Ralph!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Comic Sans MS";color:#1F497D'>Jason
Chambers</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><strong><span style='color:#1F497D'>IT Helpdesk Support</span></strong><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:navy'><a href="http://www.geosoft.com/20"
title="http://www.geosoft.com/20"><span style='color:windowtext;text-decoration:
none'><img border=0 width=39 height=22 id="Picture_x0020_1"
src="cid:image001.jpg@01C68491.9732EFE0"></span></a></span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>eosoft
Inc.</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>85 Richmond St. West - 8th Floor</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Toronto, Ontario, Canada</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>M5H 2C9</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=PT-BR style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Tel: 416-369-0111 x344</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=PT-BR style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Fax: 416-369-9599</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=PT-BR style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><a href="http://www.geosoft.com" title="http://www.geosoft.com/">www.geosoft.com</a></span><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'> </span><o:p></o:p></p>
<div style='border:none;border-top:solid #91C0FF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Segoe UI","sans-serif"'>From:</span></b><span
style='font-size:9.0pt;font-family:"Segoe UI","sans-serif"'> Ralph Mitchell
[mailto:ralphmitchell@gmail.com] <br>
<b>Sent:</b> Wednesday, May 31, 2006 1:25 AM<br>
<b>To:</b> hobbit@hswn.dk<br>
<b>Subject:</b> Re: [hobbit] mysql monitor<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Looks like I've got these:<br>
<br>
in hobbitgraph.cfg:<br>
[mysqlslow]<br>
TITLE MySQL Slow Queries<br>
YAXIS Slow Queries<br>
DEF:slow=mysql.rrd:Slowqueries:AVERAGE<br>
LINE2:slow#00CCCC:Slow Queries<br>
COMMENT:\n<br>
GPRINT:slow:LAST: \: %5.1lf (cur)<br>
GPRINT:slow:MAX: \: %5.1lf (max)<br>
GPRINT:slow:MIN: \: %5.1lf (min)<br>
GPRINT:slow:AVERAGE: \: %5.1lf
(avg)\n<br>
<br>
[mysqlthread]<br>
TITLE MySQL Active Threads<br>
YAXIS Threads<br>
DEF:threads=mysql.rrd:Threads:AVERAGE<br>
AREA:threads#00CCCC:Threads<br>
COMMENT:\n<br>
GPRINT:threads:LAST: \: %5.1lf (cur)<br>
GPRINT:threads:MAX: \: %5.1lf (max)<br>
GPRINT:threads:MIN: \: %5.1lf (min)<br>
GPRINT:threads:AVERAGE: \: %5.1lf
(avg)\n<br>
<br>
in hobbitserver.cfg:<br>
TEST2RRD="cpu=la,disk...mysql=ncv"<br>
GRAPHS="la,disk...mysql:mysqlslow,mysql:mysqlthread"<br>
NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE"<br>
<br>
The status line from one host reads:<br>
Uptime: 5421958 Threads: 1 Questions:
1051219 Slow queries: 577 Opens: 80325 Flush tables:
189 Open tables: 63<br>
<br>
The Uptime value is discarded and the rest go into the mysql.rrd. Only
the "Slow queries" and "Thread" graphs show on the Trends
page.<br>
<br>
It may not be optimal, but I am getting graphs... :)<br>
<br>
<br>
<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>