mysql connections
Sabeer MZ
sabeer.mz at gmail.com
Thu Mar 1 08:37:09 CET 2007
Hi all,
cloud anyone help me why there is no graphs showing for me.
I am trying to monitor mysql connections using bb-mysql.pl.
1. /etc/bb-hosts
hostname TRENDS:*,mysql:mysqlslow,mysqlthread
2. 3 entries for mysql at hobbitserver.cfg
TEST2RRD="cpu=la,disk,------cut--------,ports,clock,lines",mysql=ncv"
GRAPHS="la,mysql,disk,-------cut-------clock,lines"
NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"
3. my hobbitgraph.cfg
[mysqlslow]
DEF:slow=mysql.rrd:Slowqueries:AVERAGE
TITLE MySQL Slow Queries
YAXIS #
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
YAXIS #
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
--
Warm Regards
Sabeer MZ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20070301/83cd30b9/attachment.html>
More information about the Xymon
mailing list