Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:ac2455ebd5b24a058f60360f80855108

Created December 6, 2017 19:36
Show Gist options
  • Save mdcallag/ac2455ebd5b24a058f60360f80855108 to your computer and use it in GitHub Desktop.
Save mdcallag/ac2455ebd5b24a058f60360f80855108 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
- load, mysql
ips.av ips.75 ips.95 ips.99 wkb/i Mcpu/i size rss wmb/s cpu engine
127584 7931 7655 6602 3.82 206 66 1.7 487.2 26.3 myrocks.feb10
132767 8187 7981 7800 1.54 161 61 21.8 203.6 21.3 myrocks.apr14
109409 6770 6612 6498 1.57 170 62 1.7 171.3 18.6 myrocks.jun16
132450 8153 7953 7783 1.51 164 61 1.7 200.0 21.7 myrocks.aug15
140647 8755 8514 8327 1.51 160 61 1.8 212.5 22.4 myrocks.oct16
179147 9902 8759 8297 5.48 195 90 100.1 982.2 35.0 fbinno5635.jun16
93179 4439 3752 3525 5.10 198 97 108.5 475.3 18.5 inno5635
230309 12149 10225 9868 5.31 178 98 106.8 1223.1 41.1 inno5717
226449 11795 9796 9261 5.40 178 97 107.0 1223.2 40.2 inno801
224921 11735 9808 9143 5.49 180 97 106.9 1234.8 40.5 inno802
226142 11756 9703 9329 5.49 178 97 106.9 1241.0 40.3 inno803
208681 12588 11956 11191 0.86 212 110 188.6 179.0 44.2 toku5717
- scan
1 2 3 4 5 2+3+4 engine
13 17 16 19 13 52 myrocks.feb10
13 18 17 17 14 52 myrocks.apr14
17 21 20 28 17 69 myrocks.jun16
18 89 89 88 19 266 myrocks.aug15
23 24 24 25 17 73 myrocks.oct16
13 79 80 80 12 239 fbinno5635.jun16
11 10 10 11 11 31 inno5635
9 9 9 8 8 26 inno5717
9 7 8 9 8 24 inno801
9 8 8 9 8 25 inno802
8 8 9 10 8 27 inno803
9 26 23 23 9 72 toku5717
q1
secs wMB/s wKB/o Mcpu/o engine
13 218.3 0.007 0.924 myrocks.feb10
13 33.4 0.001 0.904 myrocks.apr14
17 33.2 0.001 1.132 myrocks.jun16
19 30.8 0.001 1.140 myrocks.aug15
23 38.7 0.002 1.360 myrocks.oct16
13 625.0 0.015 0.940 fbinno5635.jun16
11 599.8 0.012 0.820 inno5635
9 626.3 0.010 0.596 inno5717
9 627.3 0.010 0.612 inno801
9 626.9 0.010 0.632 inno802
8 626.8 0.010 0.612 inno803
9 388.1 0.006 0.648 toku5717
q5
secs wMB/s wKB/o Mcpu/o engine
13 99.9 0.003 0.884 myrocks.feb10
14 46.5 0.002 0.940 myrocks.apr14
17 0 0 0.992 myrocks.jun16
19 0 0 0.984 myrocks.aug15
17 0 0 1.092 myrocks.oct16
12 0 0 0.860 fbinno5635.jun16
11 596.2 0.012 0.760 inno5635
8 626.8 0.010 0.620 inno5717
8 626.5 0.010 0.604 inno801
8 624.6 0.010 0.644 inno802
8 628.2 0.010 0.616 inno803
9 0 0 0.672 toku5717
q4
secs wMB/s wKB/o Mcpu/o engine
19 101.0 0.004 1.216 myrocks.feb10
17 61.4 0.002 1.152 myrocks.apr14
28 21.7 0.001 1.684 myrocks.jun16
88 1.1 0 6.364 myrocks.aug15
25 13.4 0.001 1.716 myrocks.oct16
80 0 0 5.484 fbinno5635.jun16
11 604.0 0.012 0.760 inno5635
8 626.3 0.010 0.600 inno5717
9 626.3 0.010 0.596 inno801
9 626.3 0.010 0.640 inno802
10 626.3 0.010 0.612 inno803
23 409.5 0.018 1.832 toku5717
- wps=1000, mysql
ips.av ips.99 qps.av qps.99 wkb/i Mcpu/i Mcpu/q size rss wmb/s cpu engine
15842 995 57421 3387 5.54 2386 658 68 197.0 87.7 37.8 myrocks.feb10
15845 996 55376 3283 2.29 2316 663 68 178.3 36.3 36.7 myrocks.apr14
15845 994 52976 3143 2.28 2318 693 68 148.4 36.1 36.7 myrocks.jun16
15845 996 54590 3252 2.26 2320 673 68 146.9 35.7 36.8 myrocks.aug15
15842 996 55921 3313 2.31 2326 659 68 149.9 36.5 36.8 myrocks.oct16
15845 998 71237 4326 22.49 2304 512 103 114.0 356.4 36.5 fbinno5635.jun16
15845 997 72240 4355 22.78 2421 531 111 122.2 361.0 38.4 inno5635
15838 998 67111 4085 23.67 2365 558 111 120.5 374.8 37.4 inno5717
15842 998 65375 3975 23.94 2361 572 111 120.7 379.3 37.4 inno801
15842 998 64215 3915 24.15 2379 587 111 120.7 382.6 37.7 inno802
15842 998 64382 3919 24.15 2373 584 111 120.6 382.6 37.6 inno803
15823 988 57937 2972 2.80 2362 645 109 204.3 44.3 37.4 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 59494 3537 7.52 21621 576 70 197.0 11.9 34.2 myrocks.feb10
1584 100 56553 3294 2.35 21449 601 70 188.5 3.7 34.0 myrocks.apr14
1584 100 54324 3195 2.23 21479 626 70 156.9 3.6 34.0 myrocks.jun16
1584 100 55711 3277 2.29 21501 611 70 156.3 3.6 34.1 myrocks.aug15
1584 100 56966 3368 2.10 21528 599 70 158.5 3.3 34.1 myrocks.oct16
1584 100 71489 4253 47.09 21773 482 104 115.4 74.6 34.5 fbinno5635.jun16
1584 100 73003 4322 96.94 22335 485 113 123.6 153.6 35.4 inno5635
1584 100 67772 4020 42.50 22143 518 113 121.9 67.3 35.1 inno5717
1584 100 66105 3965 43.33 22084 529 113 122.1 68.6 35.0 inno801
1584 100 64706 3908 43.64 22131 542 113 122.1 69.1 35.1 inno802
1584 100 64914 3892 43.67 22102 539 112 121.9 69.2 35.0 inno803
1584 100 62113 3721 6.21 21939 559 106 207.1 9.8 34.7 toku5717
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment