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>
Ralph Mitchell<br>
<br><div><span class="gmail_quote">On 5/30/06, <b class="gmail_sendername">Jason Chambers</b> <<a href="mailto:Jason.Chambers@geosoft.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Jason.Chambers@geosoft.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">No Rush! :D</span></p></div><div><span>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="color: rgb(31, 73, 125);">Jason
Chambers</span><span style="color: rgb(31, 73, 125);"></span></p>
<p><strong><span style="color: rgb(31, 73, 125);">IT Helpdesk Support</span></strong><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="color: navy;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
<img border="0" height="22" width="39"></span></a></span><span style="font-size: 10pt; color: rgb(31, 73, 125);">eosoft
Inc.</span><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">85 Richmond St. West - 8th Floor</span><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Toronto, Ontario, Canada</span><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">M5H 2C9</span><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);" lang="PT-BR">Tel: 416-369-0111 x344</span><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);" lang="PT-BR">Fax: 416-369-9599</span><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);" lang="PT-BR"><a href="http://www.geosoft.com" title="http://www.geosoft.com/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.geosoft.com
</a></span><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="color: rgb(31, 73, 125);"> </span></p>
<p><span style="color: rgb(31, 73, 125);"> </span></p>
</span></div><div><div style="border-style: solid none none; border-color: rgb(145, 192, 255) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 9pt;">From:</span></b><span style="font-size: 9pt;"> Ralph Mitchell
[mailto:<a href="mailto:ralphmitchell@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ralphmitchell@gmail.com</a>] <br>
<b>Sent:</b> Monday, May 29, 2006 8:47 PM</span></p></div><div><span><br>
<b>To:</b> <a href="mailto:hobbit@hswn.dk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">hobbit@hswn.dk</a><br>
<b>Subject:</b> Re: [hobbit] mysql monitor</span></div><div><p></p>
</div></div><div><span>
<p> </p>
<p style="margin-bottom: 12pt;">I don't have immediate access
to the hobbit server - it's at work, I'/m at home... Tomorrow night, OK?<br>
<br>
Ralph Mitchell<br>
<br>
</p>
<div>
<p><span>On 5/29/06, <b>Jason Chambers</b>
<<a href="mailto:Jason.Chambers@geosoft.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Jason.Chambers@geosoft.com</a>>
wrote:</span></p>
<div>
<div>
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">I finally figured out that I
made a typo for my hobbitlaunch.cfg file. Can you help me get the graphing
working too? I never done it before, and mostly relied on the server being able
to do that.</span></p>
</div>
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="color: rgb(31, 73, 125);">Jason Chambers</span></p>
<p><strong><span style="color: rgb(31, 73, 125);">IT Helpdesk Support</span></strong></p>
<p><span style="color: navy;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="font-size: 10pt; color: rgb(31, 73, 125); text-decoration: none;">
eosoft Inc.</span><span style="color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
85 Richmond St. West - 8th Floor</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
Toronto, Ontario, Canada</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
M5H 2C9</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);" lang="PT-BR"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
Tel: 416-369-0111 x344</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;" lang="EN-US"></span></a></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);" lang="PT-BR"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
Fax: 416-369-9599</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;" lang="EN-US"></span></a></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);" lang="PT-BR"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
<u><span style="color: blue;">www.geosoft.com </span></u></span><span style="font-size: 12pt; color: windowtext; text-decoration: none;" lang="EN-US"></span></a></span></p>
<p><span style="color: rgb(31, 73, 125);"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
</span><span style="color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="color: rgb(31, 73, 125);"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: rgb(31, 73, 125); text-decoration: none;">
</span><span style="color: windowtext; text-decoration: none;"></span></a></span></p>
</div>
<div>
<div style="border-style: solid none none; border-color: -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 9pt;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
From:</span><span style="color: windowtext; font-weight: normal; text-decoration: none;"> Ralph Mitchell [mailto:<u><span style="color: blue;">ralphmitchell@gmail.com</span></u>] <br>
</span><span style="color: windowtext; text-decoration: none;">Sent:</span><span style="color: windowtext; font-weight: normal; text-decoration: none;"> Saturday, May
27, 2006 1:12 AM<br>
</span><span style="color: windowtext; text-decoration: none;">To:</span><span style="color: windowtext; font-weight: normal; text-decoration: none;"> <u><span style="color: blue;">hobbit@hswn.dk</span></u><br>
</span><span style="color: windowtext; text-decoration: none;">Subject:</span><span style="color: windowtext; font-weight: normal; text-decoration: none;"> Re: [hobbit]
mysql monitor</span><span style="font-size: 12pt; color: windowtext; font-weight: normal; text-decoration: none;"></span></a></span></b></p>
</div>
</div>
<div>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
<p style="margin-bottom: 12pt;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
Hmm... I just downloaded the current bb-mysqlstatus.tar.gz
from <u><span style="color: blue;">deadcat.net</span></u>, diffed bb-mysqlstat.sh
against the one I have running on a hobbit server, and the only change I made
was to replace VALIDMYSQLUSER & VALIDMYSQLPASSWORD.<br>
<br>
The status page shows:</span></a></p>
<h3><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">Sat May 27 00:05:21 CDT 2006 - Mysql OK
</span></a></h3>
<pre><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">Uptime: 286 Threads: 1 Questions: 2916 Slow queries: 0 Opens: 37 Flush tables: 1 Open tables: 31 Queries per second avg: 10.196
<br></span></a></pre>
<p style="margin-bottom: 12pt;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
<br>
This is on a Sun E450 running Gentoo, linux kernel 2.6.16, MySQL-4.1.19.<br>
<br>
Ralph Mitchell</span></a></p>
<div>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">On 5/26/06, <b>Jason Chambers
</b> <<u><span style="color: blue;">Jason.Chambers@geosoft.com</span></u>>
wrote:</span></a></p>
<div>
<div>
<div>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">Hi,</span></a></p>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">Does anyone have a mysql monitor working for hobbit client? I suck at
reprogramming the one on <u><span style="color: blue;">deadcat.net</span></u></span></a></p>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">Jason Chambers</span>
</a></p>
<p><strong><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">IT Helpdesk Support
</span><span style="color: windowtext; font-weight: normal; text-decoration: none;"></span></a></strong></p>
<p><span style="color: navy;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: navy; text-decoration: none;">
<span style="font-size: 10pt; color: windowtext;">eosoft Inc.</span></span><span style="color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
85 Richmond St. West - 8th Floor</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
Toronto, Ontario, Canada</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt;"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
M5H 2C9</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;"></span></a></span></p>
<p><span style="font-size: 10pt;" lang="PT-BR"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
Tel: 416-369-0111 x344</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;" lang="EN-US"></span></a></span></p>
<p><span style="font-size: 10pt;" lang="PT-BR"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
Fax: 416-369-9599</span><span style="font-size: 12pt; color: windowtext; text-decoration: none;" lang="EN-US"></span></a></span></p>
<p><span style="font-size: 10pt;" lang="PT-BR"><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;">
<u><span style="color: blue;">www.geosoft.com</span></u></span><span style="font-size: 12pt; color: windowtext; text-decoration: none;" lang="EN-US"></span></a></span></p>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
</div>
</div>
</div>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"><br clear="all">
</span></a></p>
</div>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
</div>
</div>
</div>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"><br clear="all">
</span></a></p>
</div>
<p><a href="http://www.geosoft.com/20" title="http://www.geosoft.com/20" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><span style="color: windowtext; text-decoration: none;"> </span></a></p>
</span></div><div></div>
</div>
</div><br clear="all"></blockquote></div><br>