Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created December 6, 2017 16:23
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/c92e41dc067a9a802444064935c35ecb to your computer and use it in GitHub Desktop.
Save mdcallag/c92e41dc067a9a802444064935c35ecb to your computer and use it in GitHub Desktop.
- load
ips.av ips.75 ips.95 ips.99 wkb/i Mcpu/i size rss wmb/s cpu engine
43103 41809 39377 37744 1.80 159 12 0.6 77.4 6.8 myrocks.feb10
41806 40633 38557 36592 1.16 152 13 4.1 48.4 6.4 myrocks.apr14
37908 36817 34879 33327 1.16 164 13 0.6 43.9 6.2 myrocks.jun16
41237 39974 38105 35856 1.17 156 13 0.6 48.2 6.4 myrocks.aug15
40519 39490 37187 35086 1.16 156 13 0.7 47.0 6.3 myrocks.oct16
39139 38045 37159 35952 3.80 132 19 27.9 148.6 5.2 fbinno5635
38388 37390 36286 35148 3.84 135 21 36.1 147.2 5.2 inno5635
35625 34707 33930 33116 4.04 142 21 34.5 144.1 5.0 inno5717
34060 32978 32083 31188 4.16 146 21 34.6 141.7 5.0 inno801
28629 28009 27302 26556 4.31 170 21 34.6 123.4 4.9 inno802
29771 29127 28555 27818 4.31 164 21 34.5 128.4 4.9 inno803
24343 23389 21688 20021 1.02 194 21 38.4 24.9 4.7 toku5717
scan
1 2 3 4 5 2+3+4 engine
41 46 46 45 35 137 myrocks.feb10
43 51 54 52 40 157 myrocks.apr14
46 52 53 52 40 157 myrocks.jun16
44 52 56 55 40 163 myrocks.aug15
48 70 67 67 42 204 myrocks.oct16
39 35 37 40 37 112 fbinno5635
33 30 31 34 34 95 inno5635
26 25 25 27 24 77 inno5717
25 25 25 26 25 76 inno801
25 26 26 27 25 79 inno802
26 24 28 26 25 78 inno803
28 54 54 33 28 141 toku5717
q1
secs wMB/s wKB/o rGB cs/o Mcpu/o wa.sec engine
41 51.0 0.021 0 0.005 2.380 0 myrocks.feb10
43 17.5 0.008 0 0.004 1.920 0 myrocks.apr14
46 14.5 0.007 0 0.003 1.980 0 myrocks.jun16
44 9.7 0.005 0 0.003 1.760 0 myrocks.aug15
48 13.8 0.007 0 0.004 2.760 0 myrocks.oct16
39 430.1 0.167 0 0.011 1.680 0 fbinno5635
33 508.9 0.167 0 0.012 2.420 0 inno5635
26 626.3 0.154 0 0.010 1.220 0 inno5717
25 615.0 0.151 0 0.011 1.300 0 inno801
25 610.6 0.150 0 0.010 1.220 0 inno802
26 614.9 0.164 0 0.012 1.700 0 inno803
28 0 0 0 0.002 1.060 0 toku5717
q5
secs wMB/s wKB/o rGB cs/o Mcpu/o wa.sec engine
35 0 0 0 0.003 1.780 0 myrocks.feb10
40 0 0 0 0 0.003 1.720 0 myrocks.apr14
40 0 0 0 0 0.004 1.360 0 myrocks.jun16
40 0 0 0 0 0.003 1.580 0 myrocks.aug15
42 0 0 0 0 0.003 2.000 0 myrocks.oct16
37 0 0 0 0 0.003 1.120 0 fbinno5635
34 0 0 0 0 0.003 1.260 0 inno5635
24 0 0 0 0 0.002 0.960 0 inno5717
25 0 0 0 0 0.002 0.860 0 inno801
25 0 0 0 0 0.002 0.900 0 inno802
25 0 0 0 0 0.003 0.960 0 inno803
28 0 0 0 0 0.002 1.100 0 toku5717
q4
secs wMB/s wKB/o rGB cs/o Mcpu/o wa.sec engine
45 19.1 0.009 0 0.004 1.640 0 myrocks.feb10
52 0 0 0 0.004 2.360 0 myrocks.apr14
52 0 0 0 0.004 2.000 0 myrocks.jun16
55 0 0 0 0.004 1.580 0 myrocks.aug15
67 0 0 0 0.005 2.620 0 myrocks.oct16
40 0 0 0 0.003 1.440 0 fbinno5635
34 0 0 0 0.003 1.260 0 inno5635
27 0 0 0 0.002 1.600 0 inno5717
26 0 0 0 0.002 0.860 0 inno801
27 0 0 0 0.002 0.880 0 inno802
26 0 0 0 0.003 1.000 0 inno803
33 25.0 0.008 0 0.003 1.340 0 toku5717
- wps=1000, mysql
ips.av ips.99 qps.av qps.99 wkb/i Mcpu/i Mcpu/q size rss wmb/s cpu engine
999 999 4879 4537 3.37 4031 825 13 18.0 3.4 4.0 myrocks.feb10
999 999 4556 4311 1.21 4023 882 14 18.7 1.2 4.0 myrocks.apr14
999 999 4400 4112 1.39 4014 911 14 14.8 1.4 4.0 myrocks.jun16
999 999 4531 4288 1.35 4004 883 14 15.4 1.4 4.0 myrocks.aug15
999 999 4580 4282 1.39 4075 889 14 15.1 1.4 4.1 myrocks.oct16
999 999 5780 5631 12.03 4044 699 20 28.7 12.0 4.0 fbinno5635
999 998 5781 5614 95.20 4210 728 21 36.9 95.1 4.2 inno5635
999 999 5363 5120 14.34 4030 750 22 35.2 14.4 4.0 inno5717
999 998 5139 4969 14.31 4031 784 21 35.3 14.3 4.0 inno801
999 999 5058 4796 14.18 4014 793 21 35.3 14.2 4.0 inno802
999 999 5026 4893 13.98 4005 796 21 35.3 14.0 4.0 inno803
998 998 4426 3827 4.57 3701 835 20 38.7 4.6 3.7 toku5717
- wps=100, mysql
ips.av ips.99 qps.av qps.99 wkb/i Mcpu/i Mcpu/q size rss wmb/s cpu engine
100 100 4759 4629 0.25 38550 809 14 18.0 0 3.8 myrocks.feb10
100 100 4450 4263 0.31 38397 862 14 18.8 0.1 3.8 myrocks.apr14
100 100 4258 4079 0.25 39123 918 14 14.9 0 3.9 myrocks.jun16
100 100 4341 4182 0.27 39505 909 14 15.4 0.1 3.9 myrocks.aug15
100 100 4429 4257 0.27 39889 899 14 15.2 0.1 4.0 myrocks.oct16
100 100 5706 5553 10.09 39333 689 20 28.7 1.0 3.9 fbinno5635
100 100 5872 5685 99.94 38627 656 22 36.9 9.9 3.9 inno5635
100 100 5315 5124 15.22 39028 734 22 35.3 1.5 3.9 inno5717
100 100 5136 4973 13.47 38951 758 22 35.4 1.3 3.9 inno801
100 100 5050 4847 12.55 38168 755 22 35.4 1.3 3.8 inno802
100 100 5006 4865 11.38 39047 779 21 35.3 1.1 3.9 inno803
100 100 4471 4146 21.35 35035 783 20 37.8 2.1 3.5 toku5717
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment