首页 > > 操作系统 > FreeBSD >

Graphing MySQL performance statistics with MR…

2009-05-13 15:25:19来源：未知阅读 ()

Create a user allowed to retrieve statistics from the
[url=javascript:;]MySQL[/url]
serverGRANT USAGE ON * TO status@localhost IDENTIFIED BY 'showstatus';
FLUSH PRIVILEGES;

Create a script/usr/local/bin/mrtg_read_2_mysql_varswhich retrieves the variables from MySQL#! /bin/sh
export PATH=/usr/bin:$PATH
TMP=/tmp/read_2_mysql_vars.$$.TMP
if [ -z "$3" ] ; then
      HOST=localhost
else
      HOST=$3
fi
echo 'SHOW GLOBAL STATUS;' | mysql -u status --password=showstatus -h $HOST > $TMP
VAR1=`grep ^$1 $TMP | awk '{ print $2; }'`
VAR2=`grep ^$2 $TMP | awk '{ print $2; }'`
UP=`grep "^Uptime" $TMP | head -n 1 | awk '{ print $2; }'`
if [ $UP -gt 86400 ] ; then
DAYS=`echo "scale=3; $UP / 86400" | bc`
      UPTIME="$DAYS days"
else
      UPTIME="$UP seconds"
fi
rm -f $TMP
echo $VAR1
echo $VAR2
echo $UPTIME
hostname

Alter
[url=javascript:;]mrtg[/url]
.cfg (Debian: /etc/mrtg.cfg) to graph the requested variablesTarget[mysqltraffic]: `/usr/local/bin/mrtg_read_2_mysql_vars Bytes_received Bytes_sent`
MaxBytes[mysqltraffic]: 100000000
Options[mysqltraffic]: growright
Title[mysqltraffic]: Traffic
YLegend[mysqltraffic]: bytes
LegendI[mysqltraffic]:  received
LegendO[mysqltraffic]:  sent
PageTop[mysqltraffic]: Traffic
ShortLegend[mysqltraffic]: bytes
Target[mysqlconnections]: `/usr/local/bin/mrtg_read_2_mysql_vars Connections Connections`
MaxBytes[mysqlconnections]: 1000
Options[mysqlconnections]: growright
Title[mysqlconnections]: Number of connections
YLegend[mysqlconnections]: n
LegendI[mysqlconnections]:  n
LegendO[mysqlconnections]:  n
PageTop[mysqlconnections]: Number of connections
ShortLegend[mysqlconnections]: n

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/4206/showart_1359094.html

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有