[Xymon] rrd graph does not work (mysql)

Michael Adelmann michael.adelmann at ylog.at
Wed Jul 27 09:38:44 CEST 2011

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):
        TITLE MySQL Activity
        YAXIS #
        LINE1:slow#00CCCC:Slow Queries
        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 

        TITLE MySQL Slow Queries
        YAXIS Slow Queries
        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

        TITLE MySQL Active Threads
        YAXIS 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


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

More information about the Xymon mailing list