Created
December 7, 2017 23:59
-
-
Save mdcallag/34c36c82496da63937d781b75695d997 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
- load, mysql | |
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 | |
114168 6970 6833 6736 0.02 1.00 3.35 220 223 2.3 2140 114.3 382.0 25.2 myrocks.feb10.none | |
116083 7113 6919 6843 0 0.28 1.60 177 218 12.8 255 31.9 185.4 20.5 myrocks.apr14.none | |
96539 5947 5754 5647 0 0.18 1.61 189 218 2.9 142 17.7 155.0 18.2 myrocks.jun16.none | |
116381 7159 6978 6860 0 0.19 1.59 180 217 3.0 175 21.8 184.9 21.0 myrocks.aug15.none | |
123923 7615 7445 7359 0 0.18 1.59 176 217 3.1 184 22.8 196.6 21.9 myrocks.oct16.none | |
80900 4738 2224 1495 0.02 0.34 2.27 325 112 2.5 1599 27.4 183.8 26.3 myrocks.feb10.zstd | |
116043 7111 6947 6795 0 0.10 1.36 195 98 13.4 94 11.8 157.6 22.6 myrocks.apr14.zstd | |
96446 5932 5785 5688 0 0.07 1.38 206 99 2.2 51 6.4 132.6 19.9 myrocks.jun16.zstd | |
116340 7142 6994 6865 0 0.07 1.35 199 95 2.2 61 7.7 156.9 23.2 myrocks.aug15.zstd | |
124046 7657 7513 7417 0 0.07 1.35 194 96 2.5 67 8.3 166.8 24.1 myrocks.oct16.zstd | |
75384 3428 3299 3257 0.05 0.84 11.67 379 412 38.2 3965 63.4 879.6 28.6 fbinno5635.jun16 | |
59173 3036 2889 2610 0.06 0.93 8.85 388 469 43.2 3447 55.2 523.5 22.9 inno5635 | |
88476 4128 3846 3747 0.05 0.83 11.42 416 475 40.0 4567 73.1 1009.9 36.8 inno5717 | |
87512 4074 3801 3692 0.05 0.83 11.46 402 472 40.0 4519 72.3 1002.5 35.2 inno801 | |
86423 4063 3756 3582 0.05 0.82 11.55 412 472 40.1 4406 70.5 998.0 35.6 inno802 | |
84638 3922 3651 3538 0.05 0.82 11.61 416 472 40.1 4326 69.2 982.7 35.2 inno803 | |
66443 4019 3870 3614 0.01 1.13 2.15 312 339 10.7 838 72.9 138.3 20.1 toku5717.none | |
58843 3632 3451 3237 0 0.23 1.00 447 131 10.6 213 13.8 58.6 26.3 toku5717.zstd | |
scan | |
1 2 3 4 5 2+3+4 engine | |
937 1108 970 1031 895 3109 myrocks.feb10.none | |
990 1241 1187 1167 956 3595 myrocks.apr14.none | |
1038 1314 1250 1224 1048 3788 myrocks.jun16.none | |
905 1113 1068 1032 902 3213 myrocks.jun16.none.ra | |
1001 1337 1277 1250 1004 3864 myrocks.aug15.none | |
1027 1515 1371 1407 1003 4293 myrocks.oct16.none | |
1108 1200 1056 1126 1121 3382 myrocks.feb10.zstd | |
1190 1281 1171 1190 1202 3642 myrocks.apr14.zstd | |
1267 1349 1241 1256 1258 3846 myrocks.jun16.zstd | |
1140 1234 1134 1151 1161 3519 myrocks.jun16.zstd.ra | |
1240 1379 1291 1291 1238 3961 myrocks.aug15.zstd | |
1260 1561 1436 1511 1246 4508 myrocks.oct16.zstd | |
2841 1369 1460 1424 2699 4253 fbinno5635.jun16 | |
3228 1387 1486 1426 3101 4299 inno5635 | |
2727 1134 1194 1182 2584 3510 inno5717 | |
2723 1114 1176 1148 2585 3438 inno801 | |
2728 1127 1190 1176 2580 3493 inno802 | |
2712 1118 1192 1160 2571 3470 inno803 | |
760 1033 1036 902 744 2971 toku5717.none | |
543 993 984 795 535 2772 toku5717.none.prefetch | |
1372 1187 1256 1118 1364 3561 toku5717.zstd | |
q1 | |
secs rMB/s wMB/s r/o rKB/o wKB/o rGB cs/o Mcpu/o wa.sec engine | |
937 115.2 11.6 0.003 0.055 0.006 105 0.011 1.902 2.3 myrocks.feb10.none | |
990 103.0 4.0 0.003 0.052 0.002 100 0.011 1.832 0.7 myrocks.apr14.none | |
1038 98.1 1.1 0.003 0.052 0.002 99 0.011 1.991 1.1 myrocks.jun16.none | |
905 111.8 2.6 0 0.052 0.001 99 0.004 1.793 0.4 myrocks.jun16.none.ra | |
1001 100.3 2.0 0.003 0.051 0.001 98 0.011 1.803 0.8 myrocks.aug15.none | |
1027 99.1 4.7 0.003 0.052 0.003 99 0.011 1.992 1.3 myrocks.oct16.none | |
1108 62.9 22.6 0.003 0.036 0.013 68 0.012 3.537 0.7 myrocks.feb10.zstd | |
1190 38.7 3.7 0.003 0.024 0.002 45 0.012 2.300 0.4 myrocks.apr14.zstd | |
1267 36.0 4.1 0.003 0.023 0.003 44 0.012 2.406 0.3 myrocks.jun16.zstd | |
1140 40.6 4.2 0 0.024 0.003 45 0.005 2.172 0.4 myrocks.jun16.zstd.ra | |
1240 36.9 3.5 0.003 0.023 0.002 45 0.012 2.374 0.3 myrocks.aug15.zstd | |
1260 36.3 2.9 0.003 0.023 0.002 45 0.012 2.428 0.5 myrocks.oct16.zstd | |
2841 105.0 104.1 0.010 0.153 0.151 291 0.181 10.387 28.4 fbinno5635.jun16 | |
3228 93.7 92.1 0.010 0.155 0.152 295 0.151 10.629 32.3 inno5635 | |
2727 111.5 107.7 0.010 0.156 0.150 297 0.207 9.013 31.4 inno5717 | |
2723 110.9 107.4 0.010 0.155 0.150 295 0.267 8.945 32.2 inno801 | |
2728 110.7 105.7 0.010 0.155 0.148 295 0.230 8.267 32.1 inno802 | |
2712 111.9 107.2 0.010 0.155 0.149 296 0.237 8.217 31.6 inno803 | |
760 149.3 23.0 0.001 0.058 0.009 111 0.003 1.346 0.4 toku5717.none | |
543 209.0 26.5 0.001 0.058 0.007 111 0.002 1.235 0.3 toku5717.none.prefetch | |
1372 37.7 14.5 0 0.026 0.010 50 0.005 2.968 0.2 toku5717.zstd | |
q5 | |
secs rMB/s wMB/s r/o rKB/o wKB/o rGB cs/o Mcpu/o wa.sec engine | |
895 111.1 0 0.003 0.051 0 97 0.010 1.570 0.7 myrocks.feb10.none | |
956 103.9 0 0.003 0.051 0 97 0.011 1.691 0.8 myrocks.apr14.none | |
1048 94.8 0 0.003 0.051 0 97 0.011 1.807 0.8 myrocks.jun16.none | |
902 110.3 0 0 0.051 0 97 0.004 1.577 0.1 myrocks.jun16.none.ra | |
1004 99.0 0 0.003 0.051 0 97 0.011 1.831 0.9 myrocks.aug15.none | |
1003 99.1 0 0.003 0.051 0 97 0.011 1.760 0.3 myrocks.oct16.none | |
1121 43.3 0 0.003 0.025 0 47 0.011 1.929 0.5 myrocks.feb10.zstd | |
1202 37.3 0 0.003 0.023 0 44 0.012 2.050 0.3 myrocks.apr14.zstd | |
1258 35.6 0 0.003 0.023 0 44 0.012 2.114 0.3 myrocks.jun16.zstd | |
1161 38.6 0 0 0.023 0 44 0.005 1.942 0.2 myrocks.jun16.zstd.ra | |
1238 36.1 0 0.003 0.023 0 44 0.012 2.027 0.3 myrocks.aug15.zstd | |
1246 35.9 0 0.003 0.023 0 44 0.012 2.167 0.4 myrocks.oct16.zstd | |
2699 75.5 0 0.007 0.104 0 199 0.026 3.027 27.1 fbinno5635.jun16 | |
3101 67.4 0 0.007 0.107 0 204 0.028 3.547 31.1 inno5635 | |
2584 82.0 0 0.007 0.108 0 207 0.026 2.773 25.9 inno5717 | |
2585 81.4 0 0.007 0.108 0 205 0.025 2.837 26.0 inno801 | |
2580 81.6 0 0.007 0.108 0 205 0.025 2.794 25.9 inno802 | |
2571 82.2 0 0.007 0.108 0 206 0.026 2.863 25.8 inno803 | |
744 157.1 6.6 0.001 0.060 0.002 114 0.003 1.241 0.2 toku5717.none | |
535 216.3 6.2 0.001 0.059 0.002 113 0.002 1.188 0.3 toku5717.none.prefetch | |
1364 39.7 2.8 0 0.028 0.002 53 0.005 2.539 0.4 toku5717.zstd | |
q4 | |
secs rMB/s wMB/s r/o rKB/o wKB/o rGB cs/o Mcpu/o wa.sec engine | |
1031 44.1 0 0.001 0.023 0 44 0.008 1.781 0.7 myrocks.feb10.none | |
1167 38.9 0 0.001 0.023 0 44 0.008 1.880 1.1 myrocks.apr14.none | |
1224 37.4 0 0.001 0.023 0 45 0.009 1.994 1.1 myrocks.jun16.none | |
1032 44.6 0 0 0.024 0 45 0.005 1.747 0.2 myrocks.jun16.none.ra | |
1258 36.1 0 0.001 0.023 0 44 0.009 2.033 1.2 myrocks.aug15.none | |
1407 32.2 0 0.001 0.023 0 44 0.009 2.328 0.9 myrocks.oct16.none | |
1126 16.7 0 0.001 0.010 0 18 0.008 1.850 0.3 myrocks.feb10.zstd | |
1190 17.0 0 0.001 0.010 0 20 0.008 1.946 0.2 myrocks.apr14.zstd | |
1256 16.1 0 0.001 0.010 0 20 0.008 2.105 0.1 myrocks.jun16.zstd | |
1151 17.7 0 0 0.010 0 20 0.005 1.897 0.2 myrocks.jun16.zstd.ra | |
1291 15.6 0 0.001 0.010 0 20 0.009 2.117 0.2 myrocks.aug15.zstd | |
1511 13.4 0 0.001 0.010 0 20 0.010 2.526 0.1 myrocks.oct16.zstd | |
1424 42.1 0 0.002 0.031 0 58 0.011 1.978 14.3 fbinno5635.jun16 | |
1426 41.1 0 0.002 0.030 0 57 0.010 1.926 14.3 inno5635 | |
1182 51.5 0 0.002 0.031 0 59 0.009 1.294 11.8 inno5717 | |
1148 53.0 0 0.002 0.031 0 59 0.009 1.395 11.5 inno801 | |
1176 51.6 0 0.002 0.031 0 59 0.009 1.435 11.7 inno802 | |
1160 52.3 0 0.002 0.031 0 59 0.009 1.329 11.6 inno803 | |
902 85.7 4.2 0 0.040 0.002 76 0.003 1.509 0.2 toku5717.none | |
795 96.6 4.2 0 0.039 0.002 75 0.002 1.468 0.3 toku5717.none.prefetch | |
1118 23.1 1.3 0 0.013 0.001 25 0.003 1.926 0.2 toku5717.zstd | |
- wps=1000, mysql | |
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 996 54830 3237 0.02 1.59 4.66 2410 0.01 0.46 696 224 11.8 266 25.2 73.9 38.2 myrocks.feb10.none | |
15845 995 52587 3123 0.01 0.58 2.20 2323 0 0.17 700 224 11.8 152 9.2 34.8 36.8 myrocks.apr14.none | |
15845 995 49217 2883 0.01 0.58 2.17 2336 0 0.19 752 224 11.4 153 9.2 34.4 37.0 myrocks.jun16.none | |
15845 996 51600 3061 0.01 0.59 2.17 2332 0 0.18 716 225 11.4 154 9.3 34.3 36.9 myrocks.aug15.none | |
15845 996 52547 3119 0.01 0.57 2.14 2330 0 0.17 702 225 11.5 150 9.0 33.8 36.9 myrocks.oct16.none | |
15845 996 55322 3114 0.01 0.96 2.82 2502 0 0.27 717 99 11.7 221 15.1 44.7 39.6 myrocks.feb10.zstd | |
15845 996 54103 3199 0.01 0.28 1.93 2346 0 0.08 687 99 11.8 117 4.4 30.5 37.2 myrocks.apr14.zstd | |
15845 995 51339 3020 0.01 0.27 1.91 2356 0 0.08 727 98 11.3 117 4.3 30.3 37.3 myrocks.jun16.zstd | |
15845 996 53058 3119 0.01 0.28 1.90 2352 0 0.08 702 100 11.3 116 4.4 30.0 37.3 myrocks.aug15.zstd | |
15845 996 54326 3194 0.01 0.28 1.92 2366 0 0.08 690 100 11.5 117 4.4 30.4 37.5 myrocks.oct16.zstd | |
15845 991 64494 2561 0.18 2.88 17.47 2444 0.04 0.71 600 426 38.6 2855 45.7 276.8 38.7 fbinno5635.jun16 | |
15845 989 64878 1794 0.18 2.93 17.79 2486 0.05 0.71 607 485 43.2 2897 46.3 281.9 39.4 inno5635 | |
15845 991 62661 2615 0.18 2.83 17.94 2536 0.05 0.72 641 491 40.0 2799 44.8 284.3 40.2 inno5717 | |
15848 993 61062 2625 0.18 2.81 17.91 2538 0.05 0.73 659 487 40.1 2780 44.5 283.7 40.2 inno801 | |
15845 993 60176 2594 0.18 2.82 18.01 2563 0.05 0.74 675 487 40.1 2796 44.7 285.4 40.6 inno802 | |
15845 992 60151 2608 0.18 2.81 17.98 2570 0.05 0.74 677 487 40.1 2786 44.6 284.9 40.7 inno803 | |
15453 395 12479 166 0.02 1.94 3.99 2450 0.03 2.40 3034 351 11.3 323 30.0 61.6 37.9 toku5717.none | |
15462 373 10210 151 0.01 0.68 1.62 2708 0.02 1.03 4101 126 11.7 162 10.5 25.0 41.9 toku5717.zstd | |
- wps=100, mysql | |
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 57052 3328 0.02 1.37 4.52 21478 0 0.04 596 226 11.9 24 2.2 7.2 34.0 myrocks.feb10.none | |
1584 100 54165 3170 0 0.51 2.13 21441 0 0.02 627 226 11.8 7 0.8 3.4 34.0 myrocks.apr14.none | |
1584 100 51074 2987 0 0.44 2.01 21598 0 0.01 670 226 11.4 6 0.7 3.2 34.2 myrocks.jun16.none | |
1584 100 53181 3133 0 0.50 2.19 21423 0 0.02 638 227 11.4 7 0.8 3.5 33.9 myrocks.aug15.none | |
1584 100 53717 1044 0 0.47 2.03 21499 0 0.01 634 227 11.5 7 0.7 3.2 34.1 myrocks.oct16.none | |
1584 100 59242 3398 0.03 1.96 5.24 21933 0 0.05 586 100 11.7 53 3.1 8.3 34.7 myrocks.feb10.zstd | |
1584 100 55633 3229 0 0.16 1.93 21501 0 0 612 101 11.7 3 0.2 3.1 34.1 myrocks.apr14.zstd | |
1584 100 53190 3133 0 0.14 2.01 21590 0 0 643 100 11.3 2 0.2 3.2 34.2 myrocks.jun16.zstd | |
1584 100 54553 3223 0 0.12 1.95 21502 0 0 624 102 11.4 2 0.2 3.1 34.1 myrocks.aug15.zstd | |
1584 100 55779 3245 0 0.18 1.89 21560 0 0.01 612 102 11.4 3 0.3 3.0 34.1 myrocks.oct16.zstd | |
1584 100 68128 4123 0.73 11.73 47.39 22283 0.02 0.27 518 427 38.6 1162 18.6 75.1 35.3 fbinno5635.jun16 | |
1584 100 70003 4233 0.73 11.74 48.17 22556 0.02 0.27 510 487 43.2 1162 18.6 76.3 35.7 inno5635 | |
1584 100 64547 3906 0.74 11.79 45.72 22552 0.02 0.29 553 492 40.0 1167 18.7 72.4 35.7 inno5717 | |
1584 100 63137 3849 0.72 11.56 45.55 22521 0.02 0.29 565 489 40.1 1145 18.3 72.1 35.7 inno801 | |
1584 100 62018 3769 0.72 11.58 45.94 22529 0.02 0.30 575 489 40.1 1146 18.3 72.8 35.7 inno802 | |
1584 100 62320 3763 0.73 11.65 45.99 22525 0.02 0.30 573 489 40.1 1154 18.5 72.8 35.7 inno803 | |
1584 100 26971 959 0.11 10.71 18.36 22098 0.01 0.63 1298 343 10.9 170 17.0 29.1 35.0 toku5717.none | |
1584 100 23907 764 0.05 3.67 6.12 22958 0 0.24 1521 125 11.4 79 5.8 9.7 36.4 toku5717.zstd |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment