摘要: 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.o... 阅读全文
posted @ 2019-07-09 20:10 友哥 阅读(139) 评论(0) 推荐(0) 编辑
摘要: cat latency_s.output | grep -v "mysql" | awk '{print $4, "\t", $7, "\t", $9, "\t", $11,"\t", $13}' mysql -p'' -Bse'select event_name , total_latency from sys.x$io_global_by_wait_by_latency order by... 阅读全文
posted @ 2019-07-09 17:46 友哥 阅读(210) 评论(0) 推荐(0) 编辑