Xymon Mailing List Archive search

MySQL graphs

4 messages in this thread

list Ralph Mitchell · Wed, 28 Dec 2005 05:35:15 -0600 ·
I've been playing with hobbit-4.1.2p1 for a week or so now, and have
just spent the last couple of hours banging my head on the  desk
trying to get bb-mysqlstat to show graphs.  Well, getting the reports
through wasn't hard, and I could even get an empty link to show on the
trends page by (mostly) following this advice:

  http://www.hswn.dk/hobbiton/2005/06/msg00268.html

but I wasn't getting graphs...

Anyway, to make a long story short, it looks like the [mysqlslow] and
[mysqlthread] entries in hobbitgraph.cfg need to have YAXIS defined. 
With that in, I get graphs.

Looking at hobbitd/hobbitgraph.c, it appears that where YAXIS is
defined, it gets copied to newitem->yaxis (line 284), then that gets
copied to rrdargs (line 890).  I haven't had time to really read the
whole file closely, but unless rrdargs is being checked somewhere, I'd
guess that rrd_graph can't handle being passed an empty pointer for
the yaxis label...

This is a great tool, and if I can ever persuade management to switch
from Big Brother...  :)

Ralph Mitchell
list Henrik Størner · Wed, 28 Dec 2005 17:24:51 +0100 ·
quoted from Ralph Mitchell
On Wed, Dec 28, 2005 at 05:35:15AM -0600, Ralph Mitchell wrote:
Anyway, to make a long story short, it looks like the [mysqlslow] and
[mysqlthread] entries in hobbitgraph.cfg need to have YAXIS defined. 
With that in, I get graphs.
Yep, it's a mistake. Was fixed after the 4.1.2p1 release.


Regards,
Henrik
list Ralph Mitchell · Wed, 28 Dec 2005 19:49:25 -0600 ·
Great, thanks!  Is this the right place to report things like that, or
is there a bug-tracker somewhere I should have looked at??

Ralph Mitchell
quoted from Henrik Størner


On 12/28/05, Henrik Stoerner <user-ce4a2c883f75@xymon.invalid> wrote:
On Wed, Dec 28, 2005 at 05:35:15AM -0600, Ralph Mitchell wrote:
Anyway, to make a long story short, it looks like the [mysqlslow] and
[mysqlthread] entries in hobbitgraph.cfg need to have YAXIS defined.
With that in, I get graphs.
Yep, it's a mistake. Was fixed after the 4.1.2p1 release.


Regards,
Henrik

list James H Thompson · Wed, 22 Mar 2006 10:14:36 -1000 ·
I've setup hobbit and the mysql monitoring using the script from deadcat.
All is working great except for one thing.

When I click on the 'mysql' bullet in the status display, I get the lastest status message, but no graphs.

If I click on the 'trends' bullet, I get the mysql graphs.

For 'http', the apache graphs appear under both the 'http' and 'trends' bullets.

What would make the mysql graphs appear in 'trends' but not 'mysql'?

Thanks.