MySQL gets system performance and status code

Use MySQL to get the system performance and status of the code snippet, so that the need for friends can refer to, I hope to help you copy code as follows:

#!/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; Todo
file=$ (Date +%f_%i)
sleep=$ (Date +%s.%n | awk "{print $INTERVAL-(% $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 Processlistg ' >> $PREFIX-${file}-processlist &
Echo $ts
Done
echo exiting because $RUNFILE does not exist.