[hobbit] bb-mysqlstatus.tar.gz

[Henrik Stoerner]

On Mon, Jun 27, 2005 at 06:23:19PM +0200, Henrik Stoerner wrote:
> Then run the bb-mysqlstatus.sh script as a clientside extension on
> your Mysql server. This should trigger Hobbit to generate a
> ~hobbit/data/rrd/HOSTNAME/mysql.rrd file with the data from the
> mysql-status script tracked. Then we just need a hobbitgraph.cgi
> definition to generate the graph - will send you that later (gotta
> run now - have a meeting in 5 minutes).

These should do it, I think - they won't show up automatically
on the "mysql" status column unless you add 
"GRAPHS:*,mysql:mysqlslow,mysqlthread" to that entry in bb-hosts:


[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