[input] SQL statistics: queries performed: total: 298163456 transactions: 14908172 (25024.26 per sec.) [output] transactions: 25024.26 Signed-off-by: Zhang Yu <2134782174@qq.com> --- stats/sysbench-mysql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100755 stats/sysbench-mysql diff --git a/stats/sysbench-mysql b/stats/sysbench-mysql new file mode 100755 index 00000000..836ab6c9 --- /dev/null +++ b/stats/sysbench-mysql @@ -0,0 +1,19 @@ +#!/usr/bin/env ruby + +# SQL statistics: +# queries performed: +# read: 210212086 +# write: 60060591 +# other: 30030296 +# total: 300302973 +# transactions: 15015147 (25024.26 per sec.) +# queries: 300302973 (500485.16 per sec.) +# ignored errors: 2 (0.00 per sec.) +# reconnects:0 (0.00 per sec.) + +while (line = STDIN.gets) + case line.chomp! + when /transactions:.*\(\s*(\S+)/ + puts "transactions: #{$1}" + end +end -- 2.23.0