MySQL获取系统性能和状态

#!/bin/ksh

INTERVAL=5

PREFIX=$INTERVAL-sec-status

touch /tmp/running

RUNFILE=/tmp/running

my -e 'show global variables' >> mysql-variables

while test -e $RUNFILE; do

    file=$(date +%F_%I)

	sleep=$(date +%s.%N | awk "{print $INTERVAL - (\$1 % $INTERVAL)}")

    sleep $sleep

    ts="$(date +"TS %s.%N %F %T")"

    loadavg="$(uptime)"

    echo "$ts $loadavg" >> $PREFIX-${file}-status

	my -e 'show global status' >> $PREFIX-${file}-status &

	echo "$ts $loadavg" >> $PREFIX-${file}-innodbstatus

	my -e 'show engine innodb status\G' >> $PREFIX-${file}-innodbstatus &

	echo "$ts $loadavg" >> $PREFIX-${file}-processlist

	my -e 'show full processlist\G' >> $PREFIX-${file}-processlist &

	echo $ts

done

echo Exiting because $RUNFILE does not exist.

巴特西

MySQL获取系统性能和状态

最新文章

热门文章