Mysql data collection shell script bitsCN.com
Shell script for mysql data collection
#! /Bin/sh
INTERVAL = 5
PREFIX = $ INTERVAL-sec-status
RUNFILE =/home/benchmarks/running
Mysql-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
Mysql-e 'show GLOBAL status'> $ PREFIX-$ (file)-STATUS &
Echo "$ ts $ loadavg" >>$ PREFIX-$ {file}-innodbstatus
Echo-e 'show engine innodb status/g'> $ PREFIX-$ {file}-innodbstatus &
Echo "$ ts $ loadavg" >>$ PREFIX-$ {file}-processlist
Mysql-e 'show full processlist/g'> $ PREFIX-$ {file}-processlist & echo $ ts
Done
Echo Exiting because $ RUNFILE does not exist.
BitsCN.com