How to parse bench result file for oltp test

[blylei]

Currently, we use sysbench1.0.20 bench our mysql

[rsontam-tc]

The egrep in the link below has come in handy for me. With some minor edits one can suit the output as needed.

https://www.openlife.cc/index.php/blogs/2011/august/one-liner-condensing-sysbench-output-csv-file

Sample output

Threads,Reads,Writes,Transactions,TPS,Queries,QPS,Ignored Errors,Reconnects,Total Time,Min Lat,Avg Lat,Max La,95th Pct Lat 4,118244,0,8446,844.07,135136,13505.10,0,0.00,10.0053,3.55,4.74,9.31,5.88 8,187656,0,13404,1339.29,214464,21428.62,0,0.00,10.0074,4.32,5.97,12.04,7.56 16,241892,0,17278,1725.33,276448,27605.23,0,0.00,10.0135,6.28,9.27,18.51,11.45 32,285712,0,20408,2035.80,326528,32572.81,0,0.00,10.0236,10.41,15.70,30.22,18.61

I was moving towards writing a parser but then I realized it would become obsolete if/when sysbench output changes or perhaps depending on the parameter combinations used.