MySQL obtains the system performance and status code.

Copy codeThe Code is 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; 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.