07 2019 档案

摘要: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 友哥 阅读(144) 评论(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 友哥 阅读(212) 评论(0) 推荐(0)
摘要:相同QPS下,看响应时间。 阅读全文
posted @ 2019-07-05 10:50 友哥 阅读(210) 评论(0) 推荐(0)
摘要:io、线程调度? 阅读全文
posted @ 2019-07-03 16:21 友哥 阅读(265) 评论(0) 推荐(0)