MySQL获取系统性能和状态

#!/bin/kshINTERVAL=5PREFIX=$INTERVAL-sec-statustouch /tmp/runningRUNFILE=/tmp/runningmy -e 'show global variables' >> mysql-variableswhile 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}-statusmy -e 'show global status' >> $PREFIX-${file}-status &echo "$ts $loadavg" >> $PREFIX-${file}-innodbstatusmy -e 'show engine innodb status\G' >> $PREFIX-${file}-innodbstatus &echo "$ts $loadavg" >> $PREFIX-${file}-processlistmy -e 'show full processlist\G' >> $PREFIX-${file}-processlist &echo $tsdoneecho Exiting because $RUNFILE does not exist.