#收集mysql测试数据的shell脚本
#!/bin/sh
INTERVAL=5
PREFIX=$INTERVAL-sec-status
RUNFILE=/home/benchmarks/running
mysql –e ‘SHOW GLOBAL VARIABLES’ >> mysql-variables
while test –e
R
U
N
F
I
L
E
;
d
o
f
i
l
e
=
RUNFILE; do file=
RUNFILE;dofile=(date+%F_%I)
sleep=$(date+%s.%N | awk “{print $INTERVAL -($1 % $INTERVAL)}”)
sleep
s
l
e
e
p
t
s
=
"
sleep ts="
sleepts="(date+“TS %s.%N %F %T”)"
loadavg=“
(
u
p
t
i
m
e
)
"
e
c
h
o
"
(uptime)" echo "
(uptime)"echo"ts $loadavg” >>
P
R
E
F
I
X
−
PREFIX-
PREFIX−{file}-status
mysql -e ‘SHOW GLOBAL STATUS’ >>
P
R
E
F
I
X
−
PREFIX-
PREFIX−{file}-status &
echo “$ts $loadavg” >>
P
R
E
F
I
X
−
PREFIX-
PREFIX−{file}-innodbstatus
mysql -e ‘SHOW ENGINE INNODB STATUS\G’ >>
P
R
E
F
I
X
−
PREFIX-
PREFIX−{file}-innodbstatus &
echo “$ts $loadavg” >>
P
R
E
F
I
X
−
PREFIX-
PREFIX−{file}-processlist
mysql -e ‘SHOW FULL PROCESSLIST\G’ >>
P
R
E
F
I
X
−
PREFIX-
PREFIX−{file}-processlist &
echo $ts
done
echo Exiting because $RUNFILE does not exist.