File: mysql_plot.py

package info (click to toggle)
golang-github-rootless-containers-bypass4netns 0.4.2-1
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 596 kB
  • sloc: sh: 1,936; python: 542; makefile: 33
file content (55 lines) | stat: -rw-r--r-- 1,681 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
import matplotlib.pyplot as plt
import numpy as np 
import csv
import sys
import re


def load_data(filename):
    data = {}
    with open(filename) as f:
        line = f.readline()
        while line:
            line = re.sub('\s+', ' ', line.strip()).split(" ")
            if "transactions:" in line:
                data["transactions"] = float(line[2].replace("(", ""))
            if "queries:" in line:
                data["queries"] = float(line[2].replace("(", ""))
            if "avg:" in line:
                data["latency(ms)"] = float(line[1])
            line = f.readline()
    return data

BAR_WIDTH=0.25

labels=['transactions', 'queries', 'latency(ms)']

data_num = len(sys.argv)-2 
factor = (data_num+1) * BAR_WIDTH

datas = []
for i in range(0, data_num):
    filename = sys.argv[1+i]
    data = load_data(filename)
    datas.append(data)

fig = plt.figure()
ax1 = fig.add_subplot()
ax1.set_ylabel("Operations / second")
ax2 = ax1.twinx()
ax2.set_ylabel("Average latency (ms)")

for i in range(0, data_num):
    filename = sys.argv[1+i]
    ax1.bar([BAR_WIDTH*i, factor+BAR_WIDTH*i], [datas[i][labels[0]], datas[i][labels[1]]], align="edge",  edgecolor="black", linewidth=1, width=BAR_WIDTH, label=filename)

for i in range(0, data_num):
    filename = sys.argv[1+i]
    ax2.bar([factor*2+BAR_WIDTH*i], datas[i][labels[2]], align="edge",  edgecolor="black", linewidth=1, width=BAR_WIDTH, label=filename)

h1, l1 = ax1.get_legend_handles_labels()
ax1.legend(h1, l1, loc="upper left")
plt.xlim(0, (len(labels)-1)*factor+BAR_WIDTH*data_num)
plt.xticks([x*factor+BAR_WIDTH*data_num/2 for x in range(0, len(labels))], labels)

plt.savefig(sys.argv[1+data_num])