ITPub博客

mysql -p'' -Bse'show global status like "com_%";' > qps.new
while true
do
    sleep 0.5
    mv qps.new qps.old
    mysql -p'' -Bse'show global status like "com_%";' > qps.new
    date
    paste qps.old qps.new | awk '{print $1, " ", ($4-$2)}' | awk '{if ($2) print $2 ," ", $1 ;}' | paste -sd' '
done