Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created March 9, 2022 17:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/7bb644d773ef724e899c5859f22ed108 to your computer and use it in GitHub Desktop.
Save mdcallag/7bb644d773ef724e899c5859f22ed108 to your computer and use it in GitHub Desktop.
Results from seek-only and get-only mixgraph
--- RocksDB block cache hit rate
- Get-only
Block cache hit rate by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
8.9 11.4 14.8 19.4 25.6 33.9 43.9 48.9 hwperf
0.2 0.3 0.6 1.3 2.5 4.6 8.2 11.6 all_random
8.9 11.4 14.8 19.4 25.6 33.9 43.9 48.9 all_dist
0.2 0.3 0.6 1.3 2.5 4.6 8.2 11.6 prefix_random
8.2 12.7 20.7 34.2 55.5 76.2 80.8 81.3 prefix_dist
- Seek-only
Block cache hit rate by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
86.8 87.2 87.7 88.3 89.2 90.3 91.5 91.8 hwperf
21.8 23.1 25.5 30.2 38.9 53.1 71.0 81.6 all_random
30.1 33.3 37.7 43.6 51.6 62.3 75.0 84.3 all_dist
21.8 23.1 25.5 30.2 38.9 53.1 71.0 81.6 prefix_random
21.3 24.3 30.0 41.0 60.8 82.3 86.2 88.0 prefix_dist
--- operations/second
- Get-only
o/s by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
18941 19372 19878 20864 22026 24104 28114 29475 hwperf
9867 9846 9890 9918 10007 10183 10558 10835 all_random
19084 19409 19964 20806 22127 24092 27978 29560 all_dist
9850 9851 9873 9914 10011 10185 10504 10775 prefix_random
10158 10593 11502 13382 18166 28047 33251 33421 prefix_dist
- Seek-only
o/s by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
15713 15832 16225 16818 17608 18767 21739 22137 hwperf
1576 1579 1544 1590 1605 1717 2003 2320 all_random
3181 3205 3171 3307 3451 3692 4343 5064 all_dist
1583 1576 1557 1562 1610 1707 1986 2326 prefix_random
1596 1625 1655 1784 2167 3091 3712 3782 prefix_dist
--- Storage reads/second
- Get-only
r/s by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
8624 8576 8468 8408 8189 7964 7866 7516 hwperf
9857 9818 9830 9795 9761 9708 9686 9548 all_random
8688 8591 8504 8385 8225 7960 7835 7530 all_dist
9841 9823 9815 9792 9764 9710 9638 9503 prefix_random
9331 9247 9129 8805 8092 6667 6375 6253 prefix_dist
- Seek-only
r/s by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
7172 7033 6941 6822 6615 6330 6367 6244 hwperf
5776 5754 5567 5609 5407 5265 5153 4850 all_random
5528 5452 5230 5210 5070 4854 4735 4240 all_dist
5802 5743 5615 5510 5421 5236 5110 4861 prefix_random
5672 5592 5334 4977 4219 2626 2386 2129 prefix_dist
--- Storage read MB /second
- Get-only
rMB/s by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
67.2 66.8 66.0 65.5 63.9 62.1 61.4 58.7 hwperf
76.7 76.4 76.5 76.2 76.0 75.6 75.4 74.3 all_random
67.7 66.9 66.3 65.4 64.1 62.1 61.1 58.8 all_dist
76.6 76.4 76.4 76.2 76.0 75.6 75.0 74.0 prefix_random
72.6 72.0 71.1 68.6 63.1 52.1 49.9 48.9 prefix_dist
- Seek-only
rMB/s by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
56.0 54.9 54.2 53.3 51.7 49.5 49.8 48.9 hwperf
178.3 176.4 168.5 165.1 150.1 129.2 99.7 76.5 all_random
162.9 157.5 146.8 140.3 128.3 111.2 91.9 70.2 all_dist
179.1 176.1 169.9 162.2 150.5 128.5 99.0 76.6 prefix_random
177.1 175.3 168.3 158.7 135.5 82.0 75.3 67.2 prefix_dist
--- Storage reads /operation
- Get-only
r/o by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
0.46 0.44 0.43 0.40 0.37 0.33 0.28 0.25 hwperf
1.00 1.00 0.99 0.99 0.98 0.95 0.92 0.88 all_random
0.46 0.44 0.43 0.40 0.37 0.33 0.28 0.25 all_dist
1.00 1.00 0.99 0.99 0.98 0.95 0.92 0.88 prefix_random
0.92 0.87 0.79 0.66 0.45 0.24 0.19 0.19 prefix_dist
- Seek-only
r/o by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
0.46 0.44 0.43 0.41 0.38 0.34 0.29 0.28 hwperf
3.66 3.64 3.61 3.53 3.37 3.07 2.57 2.09 all_random
1.74 1.70 1.65 1.58 1.47 1.31 1.09 0.84 all_dist
3.67 3.64 3.61 3.53 3.37 3.07 2.57 2.09 prefix_random
3.55 3.44 3.22 2.79 1.95 0.85 0.64 0.56 prefix_dist
--- Storage read KB /operation
rKB/o by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
3.63 3.53 3.40 3.21 2.97 2.64 2.24 2.04 hwperf
7.96 7.95 7.92 7.87 7.78 7.60 7.31 7.02 all_random
3.63 3.53 3.40 3.22 2.97 2.64 2.24 2.04 all_dist
7.96 7.94 7.92 7.87 7.77 7.60 7.31 7.03 prefix_random
7.32 6.96 6.33 5.25 3.56 1.90 1.54 1.50 prefix_dist
rKB/o by block cache size in GB
1 2 4 8 16 32 64 128 cache-size/mixgraph-config
3.65 3.55 3.42 3.25 3.01 2.70 2.35 2.26 hwperf
115.85 114.40 111.75 106.33 95.76 77.05 50.97 33.77 all_random
52.44 50.32 47.41 43.44 38.07 30.84 21.67 14.20 all_dist
115.85 114.42 111.74 106.33 95.72 77.08 51.05 33.72 prefix_random
113.63 110.47 104.13 91.09 64.03 27.17 20.77 18.19 prefix_dist
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment