MyRocks and InnoDB Scalability with Use Case from Bug #68079
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Average Time to run 1000 queries at given concurrency, seconds
2
Threads124810163264
3
MyRocks/inner68.7437.94420.65819.92219.71619.55919.63719.092
4
MyRocks/straight62.03331.14815.73115.75115.72615.59815.69615.242
5
InnoDB 5.7/inner33.5223.39812.33712.312.3412.21812.2411.879
6
InnoDB 5.7/straight34.41122.52111.7411.71111.76111.59311.85511.223
7
8
Facebook MySQL version:
commit 6b4ba98698182868800f31e0d303f1e16026efdf
Sat Jan 28 13:51:47 2017 -0800
20.601
9
Oracle MySQL 5.7 version:
commit 23032807537d8dd8ee4ec1c4d40f0633cd4e12f9
Mon Nov 28 16:48:20 2016 +0530
E3 with perf
10
0.03
11
Queries per seconds
12
Threads124810163264
13
MyRocks/inner14.5526.3548.4150.250.7251.1350.9252.38
14
MyRocks/straight16.1232.163.5763.4963.5964.1163.7165.61
15
InnoDB 5.7/inner29.8342.7481.0681.381.0481.8581.784.18
16
InnoDB 5.7/straight29.0644.485.1885.3985.0386.2684.3589.1
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
Sheet3
With Log scale