| [e9c5db2] | 1 | #!/usr/bin/python3 | 
|---|
|  | 2 | """ | 
|---|
|  | 3 | Python Script to convert output from mutilate to rmit like output | 
|---|
|  | 4 | """ | 
|---|
|  | 5 | import argparse | 
|---|
|  | 6 | import json | 
|---|
|  | 7 | import locale | 
|---|
|  | 8 | import os | 
|---|
|  | 9 | import re | 
|---|
|  | 10 | import sys | 
|---|
|  | 11 |  | 
|---|
|  | 12 | locale.setlocale( locale.LC_ALL, 'en_US.UTF-8' ) | 
|---|
|  | 13 |  | 
|---|
|  | 14 | parser = argparse.ArgumentParser(description='Python Script to convert output from mutilate to rmit like output') | 
|---|
|  | 15 | parser.add_argument('--out', nargs='?', type=argparse.FileType('w'), default=sys.stdout) | 
|---|
| [d1c47c2] | 16 | parser.add_argument('--var', nargs='?', type=str, default='Target QPS') | 
|---|
| [e9c5db2] | 17 | try: | 
|---|
|  | 18 | options =  parser.parse_args() | 
|---|
|  | 19 | except: | 
|---|
|  | 20 | print('ERROR: invalid arguments', file=sys.stderr) | 
|---|
|  | 21 | parser.print_help(sys.stderr) | 
|---|
|  | 22 | sys.exit(1) | 
|---|
|  | 23 |  | 
|---|
|  | 24 | thisdir = os.getcwd() | 
|---|
|  | 25 | dirs = os.listdir( thisdir ) | 
|---|
|  | 26 |  | 
|---|
|  | 27 | names = ['fibre', 'forall', 'vanilla'] | 
|---|
|  | 28 | names_re = '|'.join(names) | 
|---|
|  | 29 |  | 
|---|
|  | 30 | def precentile(line): | 
|---|
|  | 31 | fields = line.split() | 
|---|
|  | 32 |  | 
|---|
|  | 33 | try: | 
|---|
| [bd1d279] | 34 | latAvs = fields[1] | 
|---|
| [e9c5db2] | 35 | lat50s = fields[6] | 
|---|
|  | 36 | lat99s = fields[9] | 
|---|
|  | 37 | except: | 
|---|
|  | 38 | raise Warning("Warning: \"{}\"! insufficient fields".format(line)) | 
|---|
|  | 39 |  | 
|---|
|  | 40 | try: | 
|---|
| [3b5dcfa] | 41 | latAv = locale.atof(latAvs) | 
|---|
| [e9c5db2] | 42 | lat50 = locale.atof(lat50s) | 
|---|
|  | 43 | lat99 = locale.atof(lat99s) | 
|---|
|  | 44 | except: | 
|---|
|  | 45 | raise Warning("Warning: \"{}\" \"{}\"! can't convert to float".format(lat50s, lat99s)) | 
|---|
|  | 46 |  | 
|---|
| [bd1d279] | 47 | return latAv, lat50, lat99 | 
|---|
| [e9c5db2] | 48 |  | 
|---|
|  | 49 | def want0(line): | 
|---|
|  | 50 | line = line.strip() | 
|---|
|  | 51 | if not line.endswith("= 0 (0.0%)"): | 
|---|
|  | 52 | raise Warning("Warning: \"{}\"! should be 0".format(line)) | 
|---|
|  | 53 |  | 
|---|
|  | 54 | def extract(filename, out): | 
|---|
|  | 55 | with open(filename, "r") as file: | 
|---|
|  | 56 | lines = file.readlines() | 
|---|
|  | 57 |  | 
|---|
|  | 58 | warns = [] | 
|---|
|  | 59 |  | 
|---|
|  | 60 | for line in lines: | 
|---|
|  | 61 | try: | 
|---|
|  | 62 | if   line.startswith("read"): | 
|---|
| [3b5dcfa] | 63 | rlatAv, rlat50, rlat99 = precentile(line) | 
|---|
| [e9c5db2] | 64 |  | 
|---|
|  | 65 | elif line.startswith("update"): | 
|---|
| [3b5dcfa] | 66 | ulatAv, ulat50, ulat99 = precentile(line) | 
|---|
| [e9c5db2] | 67 |  | 
|---|
|  | 68 | elif line.startswith("Total QPS"): | 
|---|
|  | 69 | match = re.search("Total QPS = ([0-9,\.]+)", line) | 
|---|
|  | 70 | if match: | 
|---|
|  | 71 | try: | 
|---|
|  | 72 | qps = locale.atof(match[1]) | 
|---|
|  | 73 | except: | 
|---|
|  | 74 | raise Warning("Warning: \"{}\" can't convert qps to float".format(match[1])) | 
|---|
|  | 75 | else: | 
|---|
|  | 76 | raise Warning("Warning: \"{}\" line unreadable".format(line)) | 
|---|
|  | 77 |  | 
|---|
|  | 78 | if line.startswith("Misses") or line.startswith("Skipped TXs"): | 
|---|
|  | 79 | want0(line) | 
|---|
|  | 80 | except Warning as w: | 
|---|
|  | 81 | warns.append(str(w)) | 
|---|
|  | 82 |  | 
|---|
|  | 83 | try: | 
|---|
|  | 84 | out['Actual QPS'] = qps | 
|---|
|  | 85 | except: | 
|---|
|  | 86 | warns.append("Warning: No total QPS") | 
|---|
|  | 87 |  | 
|---|
|  | 88 | try: | 
|---|
| [3b5dcfa] | 89 | out['Average Read Latency'] = rlatAv | 
|---|
| [e9c5db2] | 90 | out['Median Read Latency'] = rlat50 | 
|---|
|  | 91 | out['Tail Read Latency'] = rlat99 | 
|---|
|  | 92 | except: | 
|---|
|  | 93 | warns.append("Warning: no read latencies") | 
|---|
|  | 94 |  | 
|---|
|  | 95 | try: | 
|---|
| [3b5dcfa] | 96 | out['Average Update Latency'] = ulatAv | 
|---|
| [e9c5db2] | 97 | out['Median Update Latency'] = ulat50 | 
|---|
|  | 98 | out['Tail Update Latency'] = ulat99 | 
|---|
|  | 99 | except: | 
|---|
|  | 100 | warns.append("Warning: no update latencies") | 
|---|
|  | 101 |  | 
|---|
|  | 102 | return warns | 
|---|
|  | 103 |  | 
|---|
|  | 104 |  | 
|---|
|  | 105 | data = [] | 
|---|
|  | 106 |  | 
|---|
|  | 107 | for filename in dirs: | 
|---|
|  | 108 | f = os.path.join( thisdir, filename ) | 
|---|
|  | 109 | # checking if it is a file | 
|---|
|  | 110 | if os.path.isfile(f): | 
|---|
|  | 111 | match = re.search("({})\.([0-9]+)\.([0-9]+)".format(names_re), filename) | 
|---|
|  | 112 | try: | 
|---|
|  | 113 | series = match[1] | 
|---|
|  | 114 | rate = match[2] | 
|---|
|  | 115 | rep = match[3] | 
|---|
|  | 116 | except: | 
|---|
|  | 117 | continue | 
|---|
|  | 118 |  | 
|---|
| [d1c47c2] | 119 | d = { options.var : int(rate) } | 
|---|
| [e9c5db2] | 120 |  | 
|---|
|  | 121 | w = extract( f, d ) | 
|---|
|  | 122 |  | 
|---|
|  | 123 | data.append([series, "memcached {}".format(series), d]) | 
|---|
|  | 124 | if w: | 
|---|
|  | 125 | print("{} {} {}\n{}\n".format(series, rate, rep, '\n'.join(w))) | 
|---|
|  | 126 |  | 
|---|
|  | 127 | options.out.write(json.dumps(data)) | 
|---|
|  | 128 | options.out.flush() | 
|---|
| [bd1d279] | 129 | options.out.write("\n") | 
|---|