#!/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 statusG' >> $PREFIX-${file}-innodbstatus & echo "$ts $loadavg" >> $PREFIX-${file}-processlist my -e 'show full processlistG' >> $PREFIX-${file}-processlist & echo $ts done echo Exiting because $RUNFILE does not exist.
Copyright © QY Network Company Ltd. All Rights Reserved. 2003-2018 群英 版权所有 茂名市群英网络有限公司
增值电信经营许可证 : B1.B2-20140078 粤ICP备09006778号-36 粤公网安备 44090202000006号 粤工商备P091701000595