Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
- 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
You can’t perform that action at this time.