[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
mysql connections
- To: hobbit (at) hswn.dk
- Subject: mysql connections
- From: "Sabeer MZ" <sabeer.mz (at) gmail.com>
- Date: Thu, 1 Mar 2007 13:07:09 +0530
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=hq+dNznm3JeUGJvb8+9irkLY6HGeaNYDfIOgea1qx0CUDTJYQkwNk1zbe+wJnNP4ilIL+1wKg/rwZsixmeUii2vOknR7hP8MO5Jcm8vVlqX+O+XsYDkDIvXlyz4zdz7gpFOTQgyv3XLdjG1UdCpgnzkZeg+JidaU59bdXaKZ/sc=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=WbPTgHbKU4bOts1GBGEH6Ilyl0sA++ki6BVnZ2YTg7Gcp4TQVWF6JTC1XENsGlyc4jWiV1EdwGZF17KAdivrPG6bQIjzKnnCpFVndS1YxhlN8Ya/t0OfeH2n5AwBZ+pKhSNOq3E1rwFfy1pmDu5F5AufNPymQYewj/I8Tswaows=
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