<br>Hopefully you are referring to change below lines. I am not experienced guy and got below code<br>from mailing list. please let me know which line i have to correct it.<br><br>[mysql]<br> DEF:t=mysql.rrd:threads:AVERAGE
<br> DEF:q=mysql.rrd:questions:AVERAGE<br> DEF:s=mysql.rrd:slowqueries:AVERAGE<br> TITLE Monitoring MySQL<br> YAXIS count<br> LINE1:q#FF0000:Requês<br> GPRINT:q:LAST: \: %3.0lf (cur)<br>
GPRINT:q:MAX: \: %3.0lf (max)<br> GPRINT:q:MIN: \: %3.0lf (min)<br> GPRINT:q:AVERAGE: \: %3.0lf (avg)\n<br> LINE1:s#0000FF:Req. lentes<br> GPRINT:s:LAST: \: %3.0lf (cur)<br> GPRINT:s:MAX: \: %3.0lf (max)
<br> GPRINT:s:MIN: \: %3.0lf (min)<br> GPRINT:s:AVERAGE: \: %3.0lf (avg)\n<br> LINE1:t#00FF00:Threads<br> GPRINT:t:LAST: \: %3.0lf (cur)<br> GPRINT:t:MAX: \: %3.0lf (max)<br> GPRINT:t:MIN: \: %3.0lf (min)
<br> GPRINT:t:AVERAGE: \: %3.0lf (avg)\n<br><br>Thanks<br>Sabeer MZ<br><br><div><span class="gmail_quote">On 3/5/07, <b class="gmail_sendername">Jones, Jason (Altrincham)</b> <<a href="mailto:JasonAS_Jones@mentor.com">
JasonAS_Jones@mentor.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 link="blue" vlink="blue" lang="EN-GB">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">My guess is the problem is what it says in
that the number is not a simple integer, try going to 2 decimal places instead
of three if possible.</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Thanks,</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Jason.</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-US">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;" lang="EN-US">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;" lang="EN-US">
Sabeer MZ [mailto:<a href="mailto:sabeer.mz@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">sabeer.mz@gmail.com</a>] <br>
<b><span style="font-weight: bold;">Sent:</span></b> 05 March 2007 10:42<br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:hobbit@hswn.dk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">hobbit@hswn.dk</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [hobbit] mysql
connections</span></font><span lang="EN-US"></span></p>
</div><div><span class="e" id="q_11121bc5949a2cb8_1">
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Dear all,<br>
<br>
Any comments on below errors. I am not able to see graphs for the data coming.<br>
And I see below errors on /var/log/hobbit/rrd-stastus.log<br>
<br>
2007-03-05 02:34:05 RRD error updating
/home/hobbit/data/rrd/abx.acc.com/mysql.rrd from <a href="http://147.183.128.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">147.183.128.102</a>: not a simple integer:
'13.617'<br>
2007-03-05 02:34:16 RRD error updating
/home/hobbit/data/rrd/abcx.abccom/mysql.rrd from <a href="http://147.183.128.98" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">147.183.128.98
</a>: not a simple integer: '106.435'<br>
2007-03-05 02:35:16 RRD error updating
/home/hobbit/data/rrd/abc.abc.com/mysql.rrd from <a href="http://147.183.128.98" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">147.183.128.98</a>:
not a simple integer: '106.435 '<br>
<br>
thanks<br>
Sabeer MZ</span></font></p>
<div>
<p><span><font face="Times New Roman" size="3"><span style="font-size: 12pt;">On 3/2/07, <b><span style="font-weight: bold;">Sabeer MZ</span></b>
<<a href="mailto:sabeer.mz@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">sabeer.mz@gmail.com</a>> wrote:</span></font></span></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi all,<br>
<br>
Thanks. Finally i am able to run the perl script and getting the results in the
hobbit server.<br>
<br>
one issue: my graphs are not coming. pls find below rrd-staus.log error details
...<br>
<br>
2007-03-02 02:28:24 RRD error updating
/home/hobbit/data/rrd/tor.abc.com/mysql.rrd from <a href="http://64.88.160.214" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">64.88.160.214</a>: not a simple integer: '0.024'<br>
2007-03-02 02:32:51 RRD error updating
/home/hobbit/data/rrd/jacc3.zbc.com/mysql.rrd from <a href="http://147.183.128.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">147.183.128.102 </a>: not a
simple integer: '13.910'<br>
2007-03-02 02:38:25 RRD error updating
/home/hobbit/data/rrd/abc.example.com/mysql.rrd from <a href="http://64.88.160.214" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">64.88.160.214</a>: not a simple
integer: '0.024 '<br>
2007-03-02 02:42:53 RRD error updating
/home/hobbit/data/rrd/abc.exam.com/mysql.rrd from <a href="http://147.183.128.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">147.183.128.102</a> : not a
simple integer: '13.908'<br>
<br>
Thanks<br>
Sabeer MZ</span></font></p>
<div><span>
<p style="margin-bottom: 12pt;"><span><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></span></p>
<div>
<p><span><font face="Times New Roman" size="3"><span style="font-size: 12pt;">On 3/1/07, <b><span style="font-weight: bold;">Dominique
Frise</span></b> <<a href="mailto:Dominique.Frise@unil.ch" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Dominique.Frise@unil.ch
</a>> wrote:</span></font></span></p>
<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Sabeer MZ wrote:<br>
> Hi all,<br>
><br>
> cloud anyone help me why there is no graphs showing for me.<br>
> I am trying to monitor mysql connections using bb-mysql.pl.<br>
><br>
><br>
> 1. /etc/bb-hosts<br>
> hostname TRENDS:*,mysql:mysqlslow,mysqlthread<br>
><br>
> 2. 3 entries for mysql at hobbitserver.cfg<br>
><br>
>
TEST2RRD="cpu=la,disk,------cut--------,ports,clock,lines",mysql=ncv"<br>
><br>
> GRAPHS="la,mysql,disk,-------cut-------clock,lines"<br>
><br>
> NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"<br>
><br>
> 3. my hobbitgraph.cfg<br>
><br>
> [mysqlslow] <br>
>
DEF:slow=mysql.rrd:Slowqueries:AVERAGE<br>
> TITLE MySQL Slow Queries<br>
> YAXIS #<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>
> DEF:threads=
mysql.rrd:Threads:AVERAGE <br>
> TITLE MySQL Active Threads<br>
> YAXIS #<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>
><br>
> --<br>
> Warm Regards<br>
> Sabeer MZ<br>
<br>
Double-check your settings using the documentation from your Hobbit <br>
installation at
http|https://$BBSERVERWWWNAME/$BBSERVERWWWURL/help/howtograph.html<br>
<br>
or use Henrik's:<br>
<br>
<a href="http://www.hswn.dk/hobbit/help/howtograph.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.hswn.dk/hobbit/help/howtograph.html
</a><br>
<br>
<br>
<br>
Dominique<br>
UNIL - University
of Lausanne<br>
<br>
To unsubscribe from the hobbit list, send an e-mail to<br>
<a href="mailto:hobbit-unsubscribe@hswn.dk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">hobbit-unsubscribe@hswn.dk</a><br>
<br>
</span></font></p>
</div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
<br clear="all">
<br>
<br>
</span></font></p>
</span></div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">-- <br>
Warm Regards<br>
<span>Sabeer MZ </span></span></font></p>
</div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
<br clear="all">
<br>
-- <br>
Warm Regards<br>
Sabeer MZ </span></font></p>
</span></div></div>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Warm Regards<br>Sabeer MZ