Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:61da02844ebcbfba227162d929142483

Created December 7, 2017 14:32
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/61da02844ebcbfba227162d929142483 to your computer and use it in GitHub Desktop.
Save mdcallag/61da02844ebcbfba227162d929142483 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
- load
ips.av ips.75 ips.95 ips.99 r/i rkb/i wkb/i Mcpu/i size rss r/s rmb/s wmb/s cpu engine
123411 7699 7494 5879 0.03 1.47 4.84 244 230 4.7 3249 90.8 596.7 30.1 myrocks.feb10.none
129971 7992 7777 7661 0 0.40 1.99 180 225 13.0 410 25.7 258.2 23.4 myrocks.apr14.none
107596 6626 6419 6273 0 0.28 2.01 189 227 4.9 244 15.3 215.7 20.3 myrocks.jun16.none
129660 7971 7761 7602 0 0.30 1.98 184 225 4.8 307 19.1 256.3 23.8 myrocks.aug15.none
137760 8505 8282 8161 0 0.29 1.97 179 225 5.0 319 20.0 271.2 24.7 myrocks.oct16.none
67272 3293 1815 5678 0.03 0.68 3.42 365 114 4.4 1969 22.9 229.6 24.5 myrocks.feb10.zstd
128626 7940 7756 7625 0 0.16 1.64 218 103 14.3 166 10.4 210.1 28.1 myrocks.apr14.zstd
106593 6568 6394 6302 0 0.10 1.66 227 104 4.6 81 5.1 176.2 24.2 myrocks.jun16.zstd
129458 8009 7828 7668 0 0.10 1.59 215 105 4.7 101 6.3 205.3 27.8 myrocks.aug15.zstd
136537 8455 8274 8154 0 0.09 1.59 208 105 4.8 101 6.3 216.8 28.3 myrocks.oct16.zstd
62182 2782 2498 2337 0.09 1.49 14.17 572 371 38.1 5843 93.5 889.9 35.9 fbinno5635.jun16
45764 2071 1921 1769 0.11 1.69 11.18 580 402 42.2 4818 77.1 511.8 26.5 inno5635
62332 3928 3446 3298 0.09 1.45 14.55 553 402 40.0 5659 90.5 906.7 34.5 inno5717
62152 2950 2579 2503 0.10 1.55 14.89 537 402 40.1 6012 96.2 925.7 33.4 inno801
60961 2703 2328 2212 0.09 1.47 14.81 542 401 40.1 5586 89.4 902.6 33.1 inno802
59082 2706 2466 2370 0.10 1.53 15.15 562 401 40.1 5630 90.1 895.2 33.2 inno803
153046 11241 10190 4294 0.01 0.88 2.94 347 388 11.4 1366 135.1 449.6 53.1 toku5717.none
119232 7874 6196 2255 0.01 0.28 1.03 559 140 11.1 557 32.7 123.1 66.7 toku5717.zlib
- scan
1 2 3 4 5 2+3+4 engine
115 81 83 86 108 250 myrocks.feb10.none
113 84 88 94 113 261 myrocks.apr14.none
120 93 105 103 120 301 myrocks.jun16.none
66 74 83 78 70 235 myrocks.jun16.none.ra
115 345 345 345 118 1035 myrocks.aug15.none
119 108 120 115 118 343 myrocks.oct16.none
111 84 83 83 103 249 myrocks.feb10.zstd
105 78 89 94 104 261 myrocks.apr14.zstd
109 93 105 94 107 292 myrocks.jun16.zstd
81 85 89 86 79 260 myrocks.jun16.zstd.ra
121 320 320 320 112 960 myrocks.aug15.zstd
123 104 125 113 114 342 myrocks.oct16.zstd
280 316 318 315 85 949 fbinno5635.jun16
253 92 95 119 57 306 inno5635
140 76 81 101 41 258 inno5717
333 76 77 100 41 253 inno801
124 75 80 99 42 254 inno802
259 77 81 99 40 257 inno803
52 68 66 63 51 197 toku5717.none
40 66 66 60 40 192 toku5717.none.prefetch
96 79 82 76 91 237 toku5717.zlib
q1
secs rMB/s wMB/s r/o rKB/o wKB/o rGB cs/o Mcpu/o wa.sec engine
115 1056.3 256.9 0.003 0.062 0.015 118 0.008 1.522 18.7 myrocks.feb10.none
113 917.6 39.1 0.003 0.053 0.002 100 0.007 1.105 18.8 myrocks.apr14.none
120 875.7 40.8 0.003 0.053 0.003 101 0.007 1.217 18.6 myrocks.jun16.none
66 1587.3 33.5 0 0.052 0.001 99 0 1.089 0.1 myrocks.jun16.none.ra
115 905.4 34.5 0.003 0.053 0.002 101 0.007 1.207 18.3 myrocks.aug15.none
119 857.0 18.3 0.003 0.052 0.001 99 0.007 1.227 18.4 myrocks.oct16.none
111 544.4 174.8 0.003 0.031 0.010 58 0.007 2.255 11.1 myrocks.feb10.zstd
105 445.3 36.5 0.003 0.024 0.002 45 0.007 1.355 10.4 myrocks.apr14.zstd
109 425.0 29.1 0.003 0.023 0.002 45 0.007 1.429 10.7 myrocks.jun16.zstd
81 575.8 37.7 0 0.024 0.002 45 0.001 1.434 0 myrocks.jun16.zstd.ra
121 439.3 60.2 0.003 0.027 0.004 51 0.007 2.235 10.7 myrocks.aug15.zstd
123 442.3 75.0 0.003 0.028 0.005 53 0.007 2.332 10.8 myrocks.oct16.zstd
280 564.5 329.8 0.005 0.081 0.047 154 0.077 4.725 0.1 fbinno5635.jun16
253 641.0 435.9 0.005 0.083 0.056 158 0.064 5.040 0.1 inno5635
140 1063.9 465.5 0.005 0.076 0.033 145 0.051 2.607 0.1 inno5717
333 512.1 402.1 0.005 0.087 0.068 166 0.169 5.090 0.2 inno801
124 1169.2 464.1 0.005 0.073 0.029 139 0.050 2.131 0.2 inno802
259 626.0 419.3 0.005 0.083 0.055 158 0.127 4.032 .2 inno803
52 2508.0 111.6 0.001 0.067 0.003 127 0.001 1.033 0.2 toku5717.none
40 3234.9 139.6 0.001 0.066 0.003 126 0 1.024 0.3 toku5717.none.prefetch
96 540.7 71.6 0 0.027 0.004 51 0.001 1.999 0.1 toku5717.zlib
q5
secs rMB/s wMB/s r/o rKB/o wKB/o rGB cs/o Mcpu/o wa.sec engine
108 932.1 0 0.003 0.051 0 96 0.007 0.932 18.0 myrocks.feb10.none
113 886.6 0 0.003 0.051 0 97 0.007 1.103 18.1 myrocks.apr14.none
120 828.1 0 0.003 0.051 0 97 0.007 1.100 18.2 myrocks.jun16.none
70 1422.1 0 0 0.051 0 97 0 1.073 0.1 myrocks.jun16.none.ra
118 854.6 0 0.003 0.051 0 97 0.007 1.060 18.1 myrocks.aug15.none
118 854.9 0 0.003 0.051 0 97 0.007 1.077 18.3 myrocks.oct16.none
103 465.6 0 0.003 0.024 0 46 0.007 1.216 10.6 myrocks.feb10.zstd
104 440.7 2.1 0.003 0.023 0 44 0.007 1.279 10.3 myrocks.apr14.zstd
107 424.4 0 0.003 0.023 0 44 0.007 1.354 10.6 myrocks.jun16.zstd
79 578.8 0 0 0.023 0 44 0 1.309 0 myrocks.jun16.zstd.ra
112 408.6 0 0.003 0.023 0 44 0.007 1.415 10.1 myrocks.aug15.zstd
114 412.3 16.2 0.003 0.024 0.001 45 0.007 1.564 10.1 myrocks.oct16.zstd
85 1566.1 0 0.004 0.067 0 128 0.011 1.373 0.1 fbinno5635.jun16
57 2353.7 0 0.004 0.067 0 129 0.001 1.278 0 inno5635
41 3209.6 0 0.004 0.066 0 125 0.006 0.780 0 inno5717
41 3214.6 0 0.004 0.066 0 126 0.006 0.755 0 inno801
42 3205.1 0 0.004 0.066 0 125 0.006 0.781 0.1 inno802
40 3287.1 0 0.004 0.067 0 128 0.006 0.752 0.1 inno803
51 2598.3 0 0.001 0.067 0 127 0.001 0.951 0.1 toku5717.none
40 3249.4 0 0.001 0.067 0 127 0 0.932 0.2 toku5717.none.prefetch
91 575.7 0.9 0 0.027 0 51 0.001 1.588 0 toku5717.zlib
q4
secs rMB/s wMB/s r/o rKB/o wKB/o rGB cs/o Mcpu/o wa.sec engine
86 566.2 0 0.002 0.024 0 46 0.003 1.089 8.5 myrocks.feb10.none
94 519.2 0 0.002 0.024 0 47 0.003 1.124 8.0 myrocks.apr14.none
103 469.8 0 0.002 0.025 0 47 0.004 1.273 8.5 myrocks.jun16.none
78 617.5 0 0 0.025 0 47 0 1.255 0.1 myrocks.jun16.none.ra
345 138.9 0 0.002 0.024 0 47 0.005 5.667 7.1 myrocks.aug15.none
115 418.8 0 0.002 0.024 0 47 0.004 1.542 7.9 myrocks.oct16.none
83 230.4 0 0.002 0.010 0 18 0.003 1.191 4.1 myrocks.feb10.zstd
94 212.6 2.2 0.002 0.010 0 19 0.004 1.309 4.2 myrocks.apr14.zstd
94 211.9 2.7 0.002 0.010 0 19 0.003 1.326 4.5 myrocks.jun16.zstd
86 232.5 4.7 0 0.010 0 19 0 1.364 0 myrocks.jun16.zstd.ra
320 59.8 3.1 0.001 0.010 0 19 0.004 5.290 3.3 myrocks.aug15.zstd
113 184.5 13.2 0.002 0.011 0.001 20 0.004 1.807 4.4 myrocks.oct16.zstd
315 300.2 0 0.003 0.048 0 92 0.007 4.498 18.9 fbinno5635.jun16
119 766.9 0 0.003 0.046 0 88 0.006 1.066 18.5 inno5635
101 906.9 0 0.003 0.046 0 89 0.006 0.737 18.7 inno5717
100 923.4 0 0.003 0.046 0 88 0.006 0.734 18.7 inno801
99 928.7 0 0.003 0.047 0 89 0.006 0.728 18.4 inno802
99 925.4 0 0.003 0.046 0 89 0.006 0.707 19.1 inno803
63 1241.5 0.1 0 0.039 0 75 0 1.122 0.2 toku5717.none
60 1324.8 4.0 0 0.039 0 75 0 1.162 0.2 toku5717.none.prefetch
76 370.6 0.3 0 0.014 0 27 0 1.297 0 toku5717.zlib
- wps=1000
ips.av ips.99 qps.av qps.99 r/i rkb/i wkb/i Mcpu/i r/q rkb/q Mcpu/q size rss r/s rmb/s wmb/s cpu engine
15845 995 44342 2418 0.96 18.60 5.50 2105 0.34 6.65 752 235 11.6 15242 294.7 87.2 33.3 myrocks.feb10.none
15845 996 40027 2319 1.25 21.95 2.52 1953 0.50 8.69 773 236 11.7 19805 347.8 40.0 30.9 myrocks.apr14.none
15845 994 38538 2281 1.21 21.20 2.53 1971 0.50 8.72 810 236 11.4 19141 335.9 40.1 31.2 myrocks.jun16.none
15845 995 39543 2308 1.22 21.41 2.53 1972 0.49 8.58 790 236 11.4 19266 338.0 40.0 31.2 myrocks.aug15.none
15845 996 40339 2381 1.23 21.70 2.55 1962 0.49 8.53 771 236 11.6 19549 339.3 40.3 31.1 myrocks.oct16.none
15845 995 45957 2585 0.30 3.04 4.28 2447 0.11 1.05 844 107 11.6 4810 48.1 67.8 38.8 myrocks.feb10.zstd
15845 996 44175 2578 0.18 1.84 2.18 2310 0.07 0.66 829 107 11.6 2885 29.2 34.5 36.6 myrocks.apr14.zstd
15845 995 42607 2460 0.18 1.84 2.20 2324 0.07 0.69 864 107 11.4 2893 29.2 34.9 36.8 myrocks.jun16.zstd
15845 996 44091 2586 0.15 1.58 2.21 2318 0.05 0.57 833 107 11.3 2403 25.0 35.0 36.7 myrocks.aug15.zstd
15845 996 44838 2607 0.16 1.67 2.22 2313 0.06 0.59 817 107 11.5 2551 26.5 35.1 36.6 myrocks.oct16.zstd
15845 994 9890 574 3.46 55.39 41.81 901 5.55 88.75 1444 382 38.6 54857 877.7 662.5 14.3 fbinno5635.jun16
15845 973 6547 335 2.33 37.31 34.60 1160 5.64 90.29 2807 413 43.2 36943 591.1 548.3 18.4 inno5635
15845 996 9541 560 3.34 53.47 41.54 997 5.55 88.80 1656 413 40.0 52953 847.3 658.2 15.8 inno5717
15842 996 9515 553 3.33 53.28 41.57 1011 5.54 88.71 1683 413 40.0 52753 844.0 658.5 16.0 inno801
15845 995 9500 557 3.23 53.17 41.59 1018 5.54 88.67 1698 412 40.1 52650 842.4 659.0 16.1 inno802
15845 995 9549 562 3.34 53.43 41.66 1011 5.54 88.65 1677 412 40.1 52909 846.5 660.1 16.0 inno803
15845 968 9520 547 0.34 8.15 4.29 2535 0.57 13.57 4220 393 11.1 5456 129.2 68.0 40.2 toku5717.none
15842 981 6726 371 0.14 1.81 1.35 2606 0.32 4.25 6137 139 11.0 2147 28.6 21.4 41.3 toku5717.zlib
- wps=100
ips.av ips.99 qps.av qps.99 r/i rkb/i wkb/i Mcpu/i r/q rkb/q Mcpu/q size rss r/s rmb/s wmb/s cpu engine
1584 100 48336 2812 8.53 156.36 7.04 19232 0.28 5.12 630 236 11.7 13509 247.6 11.2 30.5 myrocks.feb10.none
1584 100 42017 2532 12.40 212.36 2.53 17980 0.47 8.01 678 238 11.8 19641 336.3 4.0 28.5 myrocks.apr14.none
1584 100 40554 2423 12.03 205.54 2.52 17984 0.47 8.03 702 238 11.4 19058 325.6 4.0 28.5 myrocks.jun16.none
1584 100 41431 2478 12.19 208.34 2.53 18105 0.47 7.97 692 238 11.4 19301 330.0 4.0 28.7 myrocks.aug15.none
1584 100 42139 2533 12.43 212.58 2.17 18022 0.47 7.99 677 238 11.6 19686 336.7 3.5 28.5 myrocks.oct16.none
1584 100 50726 2887 0.53 6.16 8.00 21811 0.02 0.19 681 108 11.6 834 9.8 12.7 34.6 myrocks.feb10.zstd
1584 100 45755 2727 1.03 8.53 2.32 21318 0.04 0.29 722 108 11.6 1633 13.5 3.7 33.8 myrocks.apr14.zstd
1584 100 45330 2694 0.97 8.01 2.02 21377 0.03 0.28 747 108 11.3 1537 12.7 3.2 33.9 myrocks.jun16.zstd
1584 100 46488 2709 0.71 6.25 2.25 21360 0.02 0.21 728 108 11.3 1131 9.9 3.5 33.8 myrocks.aug15.zstd
1584 100 47103 2748 0.75 6.44 2.11 21377 0.03 0.14 719 108 11.5 1183 10.2 3.4 33.9 myrocks.oct16.zstd
1584 100 12696 676 42.83 685.35 106.83 7348 5.34 85.50 917 383 38.6 67841 1085.5 169.2 11.6 fbinno5635.jun16
1584 100 10584 529 35.77 572.32 106.39 9193 5.35 85.64 1376 414 43.2 56653 906.4 168.5 14.6 inno5635
1584 100 12471 691 42.06 672.95 107.10 7702 5.34 85.47 978 415 40.0 66614 1065.8 169.6 12.2 inno5717
1584 100 12415 676 41.85 669.52 106.71 7752 5.34 85.43 989 414 40.1 66286 1060.6 169.0 12.3 inno801
1584 100 12379 646 41.78 668.52 107.60 7834 5.35 85.55 1002 413 40.1 66188 1059.0 170.4 12.4 inno802
1584 100 12405 670 41.82 669.15 106.49 7665 5.34 85.43 979 413 40.1 66238 1059.8 168.7 12.1 inno803
1584 100 11966 635 3.76 81.36 18.77 22665 0.50 10.77 3000 392 11.1 5959 128.9 29.7 35.9 toku5717.none
1584 100 10177 1803 0.90 10.36 5.57 25885 0.14 1.61 4029 139 11.5 1426 16.4 8.8 41.0 toku5717.zlib
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment