Hi,
i'm back from holidays ;-).
i'm still trying to graph mysql status with the snapshot of the day
(16th august)
i've added
GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.
NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE"
and mysql=ncv" in my hobbitserver.cfg.
I see mysql.rrd files but still no graphs...
I'm pretty sure that i have a mistake just in front of my eyes but...
Anybody has an idea ?
Thanks.
Etienne
Hi,
i'm trying to get graphes from mysql-status BB side client.
I followed the man page and a post from Henrik. Now i have mysql.rrd
which is updated but i cannot get graphs.
I use Hobbit 4.1.0.
I have in by bb-hosts :
x.x.x.x box1.cvf.fr # noping GRAPHS:*,mysql:mysqlslow,mysqlthread
And
[mysqlslow]
DEF:slow=mysql.rrd:Slowqueries:AVERAGE
TITLE MySQL Slow Queries
LINE2:slow#00CCCC:Slow Queries
COMMENT:\n
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]
DEF:threads=mysql.rrd:Threads:AVERAGE
TITLE MySQL Active Threads
AREA:threads#00CCCC:Threads
COMMENT:\n
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
in hobbitgraph.cfg...
In larrd-status i can see in debug log :
2005-07-25 11:25:56 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-07-25 11:25:56 RRD update param 04:
'1122283556:180:205393153:556:26208:3:512:92.123'
Where did i make a mistake ?
Regards,
--
Etienne Roulland -- CVF Bordeaux