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.