第1回：定量的な情報収集のススメ (2/3)

/usr/bin/mysqladmin -u root -p{password} extended-status >> ~/status.txt


*/5 * * * * /usr/bin/mysqladmin -u root -p{password} extended-status >> ~/status.txt


#!/bin/sh

########################
## Get mysql status

HOME=`/bin/echo $HOME`
DIR=$HOME/data
HOST=`/bin/hostname`
DATE=`/bin/date "+%Y/%m/%d %H:%M:%S"`

SOCKET=/var/lib/mysql/mysql.sock
COMMAND="/usr/bin/mysqladmin -u root -p{PASSWORD} extended-status"

if [ -S $SOCKET ];then
   $COMMAND | /bin/awk '{print $2,$4}' | /bin/egrep -v '(^ |Variable_name)' | \
   while read LABEL DATA
   do
      /bin/echo $DATE $DATA >> $DIR/$HOST.$LABEL
   done
else
   /bin/echo "MySQL is not running."
fi