rrd graph does not work (mysql) 🔗 link

Hi All,

I have a problem with my graphs not showing up correctly. I configured 4
servers with MySql tests (which are all working) but i only get useful
graphs for one of them. All others are just have the initial "-nan"
values showing up. By the way i've set it up to be shown on the trends
page which has the same results: mysql graphs are there but without
content. I thought that i set it up just like in the "howtograph.html"
but obviously not.

Thank you, Michael


Here is my config:

my MySql test returns:

threads: 25
questions: 48126368
slow queries: 4
opens: 16410
flush tables: 625
open tables: 55
queries per second avg: 1.793
maxcon: 151

Server version: 5.1.41-3ubuntu12.6-log (Ubuntu)
Uptime: 310 days 15 hours 26 min 37 sec

Server reports timestamp of 2011-07-27 09:26:34
<<

hobbitgraph.d/mysql.cfg (which is included):

[mysql]
        TITLE MySQL Activity
        YAXIS #
        DEF:slow=mysql.rrd:slowqueries:AVERAGE
        DEF:threads=mysql.rrd:threads:AVERAGE
        LINE1:slow#00CCCC:Slow Queries
        LINE2:threads#FF0000:Threads
        GPRINT:slow:LAST: \: %5.1lf%s (cur)
        GPRINT:slow:MAX: \: %5.1lf%s (max)
        GPRINT:slow:MIN: \: %5.1lf%s (min)
        GPRINT:slow:AVERAGE: \: %5.1lf%s (avg)\n 
        GPRINT:threads:LAST: \: %5.1lf%s (cur)
        GPRINT:threads:MAX: \: %5.1lf%s (max)
        GPRINT:threads:MIN: \: %5.1lf%s (min)
        GPRINT:threads:AVERAGE: \: %5.1lf%s (avg)\n 

[mysqlslow]
        TITLE MySQL Slow Queries
        YAXIS Slow Queries
        DEF:slow=mysql.rrd:slowqueries:AVERAGE
        LINE2:slow#00CCCC:Slow Queries
        GPRINT:slow:LAST: \: %5.1lf (cur)
        GPRINT:slow:MAX: \: %5.1lf (max)
        GPRINT:slow:MIN: \: %5.1lf (min)
        GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread]
        TITLE MySQL Active Threads
        YAXIS Threads
        DEF:threads=mysql.rrd:threads:AVERAGE
        AREA:threads#00CCCC:Threads
        GPRINT:threads:LAST: \: %5.1lf (cur)
        GPRINT:threads:MAX: \: %5.1lf (max)
        GPRINT:threads:MIN: \: %5.1lf (min)
        GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n
<<

hobbitserver.cfg:
<<
TEST2RRD="cpu=la,disk,inode,qtree,memory,...,maxuser,nparts,mysql=ncv"
GRAPHS="la,disk,inode,qtree,...,maxuser,nparts,mysql"
NCV_mysql="queriespersecondavg:GAUGE,slowqueries:GAUGE,threads:GAUGE,*:NONE"

And i added "TRENDS:*,mysql" to my bb-hosts file.

I moved my mysql graph definitions in a seperate file (e.g.
$BBHOME/server/etc/hobbit-graph.d/mysql.cfg) and now it works.

My next problem is that not all of my defined marks are shown correctly,
some values show that no values are present ("-nan"). I have for example
a "Queries / second" entry which is shown on one graph but not on the
others (although the graph definitions are show on each). 


-- 
Development Department
YLOG  GmbH
Liebochstraße 9
8143 Dobl

M: +43 / 676 / 83 082 865

Now i got it working as desired. I had to delete the existing rrd files
so hobbit/xymon could generate new ones. Of course i lost my history but
thats not that important in my case.

-- 
Development Department
YLOG  GmbH
Liebochstraße 9
8143 Dobl

M: +43 / 676 / 83 082 865