mysql数据收集shell脚本
#!/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