Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Last active December 7, 2017 01:12
Show Gist options
  • Save mdcallag/c04f7604e43aaa4e017ea8a8aee30d43 to your computer and use it in GitHub Desktop.
Save mdcallag/c04f7604e43aaa4e017ea8a8aee30d43 to your computer and use it in GitHub Desktop.
- load, mysql
ips.av ips.75 ips.95 ips.99 wkb/i Mcpu/i size rss wmb/s cpu engine
117123 7162 7007 6870 2.41 185 60 1.1 282.2 21.6 myrocks.feb10
117925 7251 7098 6916 1.24 160 59 20.7 146.1 18.8 myrocks.apr14
98193 6069 5908 5816 1.26 169 60 1.2 123.5 16.6 myrocks.jun16
118399 7278 7124 6952 1.22 163 58 1.2 144.5 19.2 myrocks.aug15
126135 7825 7634 7511 1.23 159 58 1.1 154.2 20.1 myrocks.oct16
185805 11482 11183 10967 5.18 184 102 113.0 963.0 34.1 fbinno5635.jun16
107043 5514 4698 4614 4.48 197 116 121.6 480.0 21.1 inno5635
192308 11909 11569 11273 5.35 205 116 119.7 1028.2 39.4 inno5717
188893 11718 11425 11230 5.41 206 115 119.4 1021.4 39.0 inno801
189036 11653 11343 11180 5.44 206 115 119.7 1028.3 39.0 inno802
192901 11874 11527 11348 5.38 203 116 119.9 1038.4 39.1 inno803
64053 3988 3630 3092 1.23 277 89 181.4 78.5 17.7 toku5717
scan
1 2 3 4 5 2+3+4 engine
205 212 232 235 179 679 myrocks.feb10
211 235 257 243 186 735 myrocks.apr14
230 250 272 263 211 785 myrocks.jun16
226 272 288 280 197 840 myrocks.aug15
224 373 314 330 204 1017 myrocks.oct16
190 179 186 196 190 561 fbinno5635.jun16
165 153 162 167 168 482 inno5635
123 121 130 127 125 378 inno5717
129 120 125 126 128 371 inno801
133 122 129 129 130 380 inno802
127 119 127 126 128 372 inno803
145 274 288 241 150 803 toku5717
q1
secs wMB/s wKB/o cs/o Mcpu/o engine
205 57.9 0.024 0.005 2.884 myrocks.feb10
211 14.9 0.007 0.003 1.856 myrocks.apr14
230 17.1 0.008 0.005 2.180 myrocks.jun16
226 21.2 0.010 0.004 2.508 myrocks.aug15
224 3.4 0.002 0.004 1.716 myrocks.oct16
190 293.6 0.114 0.009 1.544 fbinno5635.jun16
165 382.3 0.128 0.010 1.676 inno5635
123 456.2 0.114 0.009 1.048 inno5717
129 416.9 0.109 0.008 1.212 inno801
133 394.4 0.107 0.008 1.048 inno802
127 411.0 0.106 0.008 1.064 inno803
145 111.0 0.033 0.002 1.580 toku5717
q5
secs wMB/s wKB/o cs/o Mcpu/o engine
179 0 0 0.003 1.260 myrocks.feb10
186 0 0 0.003 1.212 myrocks.apr14
211 0 0 0.004 1.520 myrocks.jun16
197 0 0 0.003 1.344 myrocks.aug15
204 0 0 0.004 1.388 myrocks.oct16
190 0 0 0.004 1.300 fbinno5635.jun16
168 0 0 0.004 1.248 inno5635
125 0 0 0.003 1.192 inno5717
128 0 0 0.003 1.268 inno801
130 0 0 0.002 0.772 inno802
128 0 0 0.003 1.028 inno803
150 0 0 0.002 0.932 toku5717
q4
secs wMB/s wKB/o cs/o Mcpu/o engine
235 0 0 0.004 1.516 myrocks.feb10
243 0 0 0.005 1.892 myrocks.apr14
263 0 0 0.005 1.908 myrocks.jun16
280 0 0 0.005 1.840 myrocks.aug15
330 0 0 0.006 2.340 myrocks.oct16
196 0 0 0.004 1.560 fbinno5635.jun16
167 0 0 0.003 1.208 inno5635
127 0 0 0.002 0.876 inno5717
126 0 0 0.002 0.720 inno801
129 0 0 0.002 0.967 inno802
126 0 0 0.002 0.792 inno803
241 3.5 0 0.002 1.796 toku5717
- wps=1000, mysql
ips.av ips.99 qps.av qps.99 wkb/i Mcpu/i Mcpu/q size rss wmb/s cpu engine
15845 995 58610 3463 3.77 2370 641 64 111.4 59.7 37.6 myrocks.feb10
15845 995 55300 3279 1.80 2316 664 64 132.4 28.5 36.7 myrocks.apr14
15845 995 52653 3107 1.79 2313 696 64 105.1 28.4 36.6 myrocks.jun16
15845 996 54233 3216 1.81 2321 678 65 106.3 28.7 36.8 myrocks.aug15
15677 996 54578 3301 1.78 2339 672 65 103.9 27.9 36.7 myrocks.oct16
15845 997 69266 4168 18.27 2329 533 116 127.0 289.5 36.9 fbinno5635.jun16
15845 997 70662 4286 18.31 2394 537 132 135.6 290.1 37.9 inno5635
15842 998 65617 3982 19.89 2391 577 131 133.8 315.1 37.9 inno5717
15842 997 63664 3865 19.98 2389 594 131 134.0 316.5 37.8 inno801
15845 997 62724 3805 20.06 2394 605 131 133.8 317.8 37.9 inno802
15845 997 62756 3828 20.09 2399 606 131 134.0 318.3 38.0 inno803
15782 873 54902 1582 2.21 2429 698 100 208.6 34.9 38.3 toku5717
- wps=100, mysql
ips.av ips.99 qps.av qps.99 wkb/i Mcpu/i Mcpu/q size rss wmb/s cpu engine
1584 100 60215 3494 4.84 21672 570 66 117.8 7.7 34.3 myrocks.feb10
1584 100 56415 3303 1.45 21459 603 66 136.4 2.3 34.0 myrocks.apr14
1584 100 53604 3150 1.71 21532 636 66 109.8 2.7 34.1 myrocks.jun16
1584 100 55013 3229 1.63 21450 618 66 110.6 2.6 34.0 myrocks.aug15
1584 100 56297 3235 2.03 21567 607 66 109.6 3.2 34.2 myrocks.oct16
1584 100 69648 4159 34.13 21846 497 117 128.5 54.1 34.6 fbinno5635.jun16
1584 100 71762 4268 34.82 22011 486 133 137.1 55.3 34.9 inno5635
1584 100 66376 3964 32.02 22121 528 133 135.3 50.7 35.0 inno5717
1584 100 64250 3855 32.60 22114 545 133 135.5 51.6 35.0 inno801
1584 100 63265 3807 32.52 22068 552 132 135.3 51.5 35.0 inno802
1584 100 63390 3801 32.73 22092 552 133 135.5 51.8 35.0 inno803
1584 100 60625 3580 6.24 21818 570 98 212.6 9.8 34.6 toku5717
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment