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
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: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
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" <SKreien at la-z-boy.com> 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: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
-- This message has been scanned for dangerous content by MailScanner, and is believed to be clean.
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.
- RRD-Graphs from the external scripts are not correctly generated
- When trying to monitor the processes "procs"
2009/5/27 William Ottley <wottley at cmicanada.com>
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" <SKreien at la-z-boy.com> 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:camorae at googlemail.com<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
-- This message has been scanned for dangerous content by *MailScanner*<http://www.mailscanner.info/>, and is believed to be clean.
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 <SKreien at la-z-boy.com>
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: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
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
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)\nThe 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
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)\nThe 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
.. please send it also to the list :-)
martinOn 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)\nThe 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 FlemmingMartin Flemming DESY / IT office : Building 2b / 008a Notkestr. 85 phone : 040 - 8998 - 4667 22603 Hamburg mail : martin.flemming at desy.de
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
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. <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)\nThe 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
forgot to say my e-mail:
camorae at googlemail.com
thx
2009/6/3 Cayo de Moraes <camorae at googlemail.com>
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. <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)\nThe 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
participants (6)
-
camorae＠googlemail.com
-
martin.flemming＠desy.de
-
SKreien＠la-z-boy.com
-
stef.coene＠docum.org
-
TRBrand＠cvs.com
-
wottley＠cmicanada.com