qps.sh
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
MySQL限时解答,24小时内友哥专业解答
http://www.yougemysqldba.com
如有进一步需要请联系微信onesoft007
微博账号@友哥一指
http://www.yougemysqldba.com
如有进一步需要请联系微信onesoft007
微博账号@友哥一指