mysql 获取状态_MySQL获取系统性能和状态代码_MySQL

bitsCN.com

#!/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.bitsCN.com

相关标签：

本文原创发布php中文网，转载请注明出处，感谢您的尊重！