Hi,
i'm sorry to insist.
Is anybody could show me the right way to graphs result from mysql test ?
My RRD files are updated, i have sql section in trends columns but no graphes..
Rgds,
Etienne
Hi,
i have also add mysql in the GRAPHS section...
Now i have a "hobbit graph mysql" but nothing more...
In the man i don't see GRAPHS tag but a TRENDS one anyway it doesn't seem to be recognized...
I don't see where i made a mistake in my setting.
Regards.
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