[hobbit] Problem with external script and RRD-Graphs

[Martin Flemming]

.. please send it also to the list :-)

 	martin

On Thu, 28 May 2009, Cayo de Moraes wrote:

> Hi Tom,
>
>
> oh plz!!! send it to me! it could be a big step for me when the first graph
> is working!
>
> I tought if im able only to generate the RRD files, i can manually call them
> all (html-codes) in the bb-mysqlstat.sh. It was the solution for Big-Brother
> and it was working so far.
>
>
> thank you guys for your support!
>
>
>
>
> 2009/5/27 Brand, Thomas R. <TRBrand at cvs.com>
>
>> > After editing the hobbitserver.cfg and hobbitgraph.cfg i had some
>> confrontations with:
>>>
>>> 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?
>>>
>>> when trying to get the only graph into the browser i get only an 1x1
>> Pixel graph...
>>
>>
>>
>> I can?t help with the multiple graphs on one page; I have mine set up for
>> one graph on the page.
>>
>>
>>
>> If you?re intererested, I can send you my version of bb-mysqlstat.sh
>> (heavily modified from the one available on Deadcat.net ?. )
>>
>>
>>
>> Here are the relevant parts from hobbitserver.cfg:
>>
>>
>>
>>
>> NCV_mysql="Threads:GAUGE,SlowQueries:GAUGE,OpenTables:GAUGE,FlushTables:NONE,Questions:NONE,Opens:NONE,AvgQuerysPerSecond:NONE,Uptime:NONE,FreeBufferPool:NONE"
>>
>>
>>
>>
>> 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"
>>
>>
>>
>>
>>
>> Here is the stanza from my hobbitgraph.cfg for the mysql graphs:
>>
>> [mysql]
>>
>>         TITLE MySQL Statistics
>>
>>         YAXIS Number of
>>
>>         DEF:threads=mysql.rrd:Threads:AVERAGE
>>
>>         DEF:slow=mysql.rrd:SlowQueries:AVERAGE
>>
>>         DEF:opentables=mysql.rrd:OpenTables:AVERAGE
>>
>>         LINE2:threads#FF0000:Threads
>>
>>         LINE2:slow#00CCCC:Slow Queries
>>
>>         LINE2:opentables#FF00FF:Open Tables
>>
>>         COMMENT:\n
>>
>>         GPRINT:threads:LAST:Threads     \: %5.1lf (cur)
>>
>>         GPRINT:threads:MAX: \: %5.1lf (max)
>>
>>         GPRINT:threads:MIN: \: %5.1lf (min)
>>
>>         GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n
>>
>>         GPRINT:slow:LAST:Slow Queries\: %5.1lf (cur)
>>
>>         GPRINT:slow:MAX: \: %5.1lf (max)
>>
>>         GPRINT:slow:MIN: \: %5.1lf (min)
>>
>>         GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n
>>
>>         GPRINT:opentables:LAST:Open Tables \: %5.1lf (cur)
>>
>>         GPRINT:opentables:MAX: \: %5.1lf (max)
>>
>>         GPRINT:opentables:MIN: \: %5.1lf (min)
>>
>>         GPRINT:opentables:AVERAGE: \: %5.1lf (avg)\n
>>
>>
>>
>>
>>
>> The client side extension script sends up the information which is then
>> displayed as:
>> *Wed May 27 10:12:53 EDT 2009 - mySQL is OK*
>>
>> Threads            : 10
>>
>> Slow Queries       : 1
>>
>> Open Tables        : 89
>>
>> Flush Tables       : 1
>>
>> Questions          : 83279
>>
>> Opens              : 94
>>
>> AvgQuerysPerSecond : 2.455
>>
>> Uptime             : 33923
>>
>> Free Buffer Pool   : 62
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hope this helps,
>>
>> *Tom Brand*
>>
>> *CVS/pharmacy*
>>
>> *IS Rx SysAdmin Store Support*
>>
>>
>>   ------------------------------
>>
>> *From:* Cayo de Moraes [mailto:camorae at googlemail.com]
>> *Sent:* Wednesday, May 27, 2009 5:06 AM
>> *To:* hobbit at hswn.dk
>> *Subject:* [hobbit] Problem with external script and RRD-Graphs
>>
>>
>>
>> Hi guys,
>>
>>
>> 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.
>>
>> Did i forget something / did something wrong or is it with the BB-Client
>> not possible?
>>
>>
>>
>> After editing the hobbitserver.cfg and hobbitgraph.cfg i had some
>> confrontations with:
>>
>> 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?
>>
>> when trying to get the only graph into the browser i get only an 1x1 Pixel
>> graph...
>>
>> has anybody any idea??
>>
>> TIA
>>
>

Gruss

        Martin Flemming


______________________________________________________
Martin Flemming
DESY / IT          office : Building 2b / 008a
Notkestr. 85       phone  : 040 - 8998 - 4667
22603 Hamburg      mail   : martin.flemming at desy.de
______________________________________________________