[Xymon] rrd graph does not work (mysql)

[Michael Adelmann]

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.