#!/bin/ksh
INTERVAL=5
PREFIX=$INTERVAL-sec-status
touch/tmp/running
RUNFILE=/tmp/running
my-e'showglobalvariables'>>mysql-variables
whiletest-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'showglobalstatus'>>$PREFIX-${file}-status&
echo"$ts$loadavg">>$PREFIX-${file}-innodbstatus
my-e'showengineinnodbstatus\G'>>$PREFIX-${file}-innodbstatus&
echo"$ts$loadavg">>$PREFIX-${file}-processlist
my-e'showfullprocesslist\G'>>$PREFIX-${file}-processlist&
echo$ts
done
echoExitingbecause$RUNFILEdoesnotexist.
|