Problem with external script and RRD-Graphs
list Cayo de Moraes
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
list Scot Kreienkamp
It might not be sending in the format that Hobbit needs. Is it creating the RRD's? Thanks, Scot Kreienkamp
▸
From: Cayo de Moraes [mailto:user-92aec3b3c467@xymon.invalid]
Sent: Wednesday, May 27, 2009 5:06 AM
To: user-ae9b8668bcde@xymon.invalid
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
list William Ottley
Interesting you should say that. I have both http and ftp, but at this time all I get is: fileserver (10.136.209.164) - ftp:green:1h14m I¹ve been trying different things for the http, with no luck. I do a wget http://fileserver to make sure it works, and it does. I¹ll check and see if its generatign the rrd...
▸
On 27/05/09 10:01 AM, "Scot Kreienkamp" <user-462cf0b6d846@xymon.invalid> wrote:
It might not be sending in the format that Hobbit needs. Is it creating the
RRD¹s?
▸
Thanks,
Scot Kreienkamp
From: Cayo de Moraes [mailto:user-92aec3b3c467@xymon.invalid]
Sent: Wednesday, May 27, 2009 5:06 AM
To: user-ae9b8668bcde@xymon.invalid
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--
This message has been scanned for dangerous content by MailScanner, and is believed to be clean.
list Thomas R. Brand
▸
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,FreeB
ufferPool:NONE"
GRAPHS="la,disk,inode,qtree,files,processes,memory,users,vmstat,iostat,t
cp.http,tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,
bind,sendmail,mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobb
itd,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:user-92aec3b3c467@xymon.invalid]
Sent: Wednesday, May 27, 2009 5:06 AM
To: user-ae9b8668bcde@xymon.invalid
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
Attachments (1)
attachment.jpglist Cayo de Moraes
Hi Scot, after I tried to solve this problem in many diferent ways, hobbit does create only one RRD file (supposed to create 3 diferents, but this is not the main problem). When i try to get the graph directly in my browser, i only get a 1x1 pixel graph. I think i will test Tom's solution. It could work! 2009/5/27 Scot Kreienkamp <user-462cf0b6d846@xymon.invalid>
▸
It might not be sending in the format that Hobbit needs. Is it creating the RRD’s? Thanks, Scot Kreienkamp *From:* Cayo de Moraes [mailto:user-92aec3b3c467@xymon.invalid] *Sent:* Wednesday, May 27, 2009 5:06 AM *To:* user-ae9b8668bcde@xymon.invalid *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
list Cayo de Moraes
Hi William, are you using the Hobbit-Client? I dont know why, but til yet i have 2 issues with BB-Client and Hobbit-Server. 1) RRD-Graphs from the external scripts are not correctly generated 2) When trying to monitor the processes "procs" 2009/5/27 William Ottley <user-432013e2e0c6@xymon.invalid>
▸
Interesting you should say that. I have both http and ftp, but at this time all I get is: fileserver (10.136.209.164) - ftp:green:1h14m
I’ve been trying different things for the http, with no luck. I do a wget http://fileserver to make sure it works, and it does. I’ll check and see if its generatign the rrd...
▸
On 27/05/09 10:01 AM, "Scot Kreienkamp" <user-462cf0b6d846@xymon.invalid> wrote:
It might not be sending in the format that Hobbit needs. Is it creating
the RRD’s?
Thanks,
Scot Kreienkamp
*From:* Cayo de Moraes [mailto:user-92aec3b3c467@xymon.invalid<user-92aec3b3c467@xymon.invalid>]
▸
*Sent:* Wednesday, May 27, 2009 5:06 AM
*To:* user-ae9b8668bcde@xymon.invalid
*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
--This message has been scanned for dangerous content by *MailScanner*<http://www.mailscanner.info/>;, and is believed to be clean.
list Cayo de Moraes
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. <user-10a840458972@xymon.invalid>
▸
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 diferentgraphs 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 1x1Pixel 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:user-92aec3b3c467@xymon.invalid]
*Sent:* Wednesday, May 27, 2009 5:06 AM
*To:* user-ae9b8668bcde@xymon.invalid
*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
list 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. <user-10a840458972@xymon.invalid>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 diferentgraphs 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 1x1Pixel 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:user-92aec3b3c467@xymon.invalid] *Sent:* Wednesday, May 27, 2009 5:06 AM *To:* user-ae9b8668bcde@xymon.invalid *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 : XXX - XXXX - XXXX
22603 Hamburg mail : user-f286aaa49a76@xymon.invalid
list Stef Coene
▸
On Thursday 28 May 2009, Cayo de Moraes wrote:
Hi Scot, after I tried to solve this problem in many diferent ways, hobbit does create only one RRD file (supposed to create 3 diferents, but this is not the main problem). When i try to get the graph directly in my browser, i only get a 1x1 pixel graph.
Take a look at this page for debugging graphs problems: http://www.docum.org/foswiki/bin/view/Xymon/DebugGraphs Stef
list Cayo de Moraes
Hi Tom Brand, 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.** TIA, Cayo de Moraes
▸
2009/5/27 Brand, Thomas R. <user-10a840458972@xymon.invalid>
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 diferentgraphs 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 1x1Pixel 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:user-92aec3b3c467@xymon.invalid] *Sent:* Wednesday, May 27, 2009 5:06 AM *To:* user-ae9b8668bcde@xymon.invalid *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
list Cayo de Moraes
forgot to say my e-mail: user-92aec3b3c467@xymon.invalid thx 2009/6/3 Cayo de Moraes <user-92aec3b3c467@xymon.invalid>
▸
Hi Tom Brand, 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.** TIA, Cayo de Moraes 2009/5/27 Brand, Thomas R. <user-10a840458972@xymon.invalid>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 diferentgraphs 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 1x1Pixel 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:user-92aec3b3c467@xymon.invalid] *Sent:* Wednesday, May 27, 2009 5:06 AM *To:* user-ae9b8668bcde@xymon.invalid *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
list Thomas R. Brand
Cayo, Sorry it took so long to get back to you... I had to 'cleanup' some of the non-public code in the script and I added installation documentation... The attached script was originally based on bb-mysql.sh <http://www.deadcat.net/viewfile.php?fileid=29>; but has been heavily modified for my environment. YMMV... ALso, I noticed that I had missed the following in the earlier reply: hobbitserver.cfg: Add ",mysql=ncv" to the TEST2RRD= line, eg: TEST2RRD="cpu=la,disk, ...,clock,lines,mysql=ncv" Please let me know of any improvements to the code or to the documentation. Thanks, Tom Tom Brand CVS/pharmacy IS Rx SysAdmin Store Support
Attachments (1)