修改sysbench输出格式为csv或json, 添加自定义指标

修改sysbench输出格式为csv或json, 添加自定义指标

在oltp_common.lua添加(二选一)

-- 输出csv

-- function sysbench.hooks.report_intermediate(stat)

--     sysbench.report_csv(stat)

-- end



-- 输出json

-- function sysbench.hooks.report_intermediate(stat)

--     sysbench.report_json(stat)

-- end

自己去掉 -- 注释

加hook

sysbench.hooks.report_intermediate =

   function (stat)

      if con == nil then

         con = assert(sysbench.sql.driver():connect())

      end

      sysbench.report_default(stat)

      create_time, node_219, node_220 = con:query_row([[

select create_time,(select delay from test.test_mgr_delay_detail where ip='192.168.2.219' order by create_time desc limit 1) as 'node_219',(select delay from test.test_mgr_delay_detail where ip='192.168.2.220' order by create_time desc limit 1) as 'node_220' from test.test_mgr_delay_detail order by create_time desc limit 1;]])

      print("create_time: "..create_time.." node_219: "..node_219.." node_220: "..node_220)

end

这样的效果就是

[ 5s ] thds: 30 tps: 73.76 qps: 1538.67 (r/w/o: 1084.35/300.82/153.51) lat (ms,95%): 733.00 err/s: 0.00 reconn/s: 0.00
create_time: 2018-01-01 10:10:00 node_219: 10 node_220: 20
[ 10s ] thds: 30 tps: 75.80 qps: 1519.27 (r/w/o: 1062.85/304.81/151.61) lat (ms,95%): 590.56 err/s: 0.00 reconn/s: 0.00
create_time: 2018-01-01 10:15:00 node_219: 10 node_220: 20
[ 15s ] thds: 30 tps: 58.39 qps: 1183.57 (r/w/o: 831.24/235.55/116.78) lat (ms,95%): 926.33 err/s: 0.00 reconn/s: 0.00
create_time: 2018-01-01 10:20:00 node_219: 10 node_220: 20

总之就是你可以自定以一些sql查询或者系统命令去增加一些指标. 我这里就是想看不同XX下对从库复制延迟的影响