Created
October 23, 2020 16:51
-
-
Save mdcallag/15fefd8b508f79accd9383c693fc4894 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
--- Postgres 12.3, l.i0 loads 500m rows | |
l.i0 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
101854 0 43 352 39935 0.000 0.003 0.392 12144 46.9 0.119 18 47.8 55.5 0.0 0.232 101988 98292 pg123.cx4a | |
104998 0 46 373 41078 0.000 0.004 0.391 12481 42.7 0.119 16 47.8 55.7 0.0 0.143 105188 99635 pg123.cx4a | |
l.x | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
111879 0 288 35824 41466 0.003 0.320 0.371 351 24.1 0.003 9 91.9 97.7 0.0 0.003 NA NA pg123.cx4a | |
119584 0 310 38262 44447 0.003 0.320 0.372 407 24.2 0.003 8 91.9 97.5 0.0 0.007 NA NA pg123.cx4a | |
l.i1 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
1940 0 2594 21341 51140 1.337 11.002 26.363 6729 17.8 3.469 367 93.6 103.8 0.0 0.215 1949 1049 pg123.cx4a | |
1886 0 2520 20681 50037 1.336 10.967 26.535 5837 18.4 3.096 390 93.6 103.6 0.0 0.262 1948 949 pg123.cx4a | |
q100.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
100 7696 128 1061 3637 0.017 0.138 36.448 29893 26.7 3.884 139 93.7 96.3 0.0 0.003 7703 7595 pg123.cx4a | |
100 7545 128 1058 3634 0.017 0.140 36.414 29297 29.1 3.883 154 93.7 96.3 0.0 0.003 7560 7416 pg123.cx4a | |
q200.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
200 7702 256 2101 6911 0.033 0.273 34.622 30205 28.2 3.922 146 93.7 95.4 0.0 0.008 7704 7592 pg123.cx4a | |
200 7472 256 2094 6911 0.034 0.280 34.622 29299 30.4 3.921 163 93.7 95.4 0.0 0.005 7480 7336 pg123.cx4a | |
q400.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
399 7638 522 4262 12985 0.068 0.558 32.518 30554 31.1 4.001 163 94.0 96.3 0.0 0.012 7640 7528 pg123.cx4a | |
399 7473 522 4260 12987 0.070 0.570 32.525 29893 32.6 4.000 174 94.0 96.3 0.0 0.005 7480 7320 pg123.cx4a | |
q600.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
599 7611 808 6593 18355 0.106 0.866 30.643 31103 33.6 4.087 177 94.7 98.0 0.0 0.012 7624 7496 pg123.cx4a | |
599 7424 807 6586 18390 0.109 0.887 30.701 30331 34.6 4.085 186 94.7 97.9 0.0 0.010 7432 7272 pg123.cx4a | |
q800.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
799 7538 1030 8442 22451 0.137 1.120 28.113 31389 36.0 4.164 191 95.1 99.0 0.0 0.011 7544 7271 pg123.cx4a | |
799 7367 1030 8434 22506 0.140 1.145 28.164 30591 36.5 4.152 198 95.1 99.0 0.0 0.010 7368 7208 pg123.cx4a | |
q1000.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
998 7506 1279 10512 27122 0.170 1.400 27.168 31861 38.9 4.244 207 95.5 100.2 0.0 0.012 7512 7355 pg123.cx4a | |
999 7315 1280 10501 27127 0.175 1.436 27.160 30937 38.8 4.229 212 95.5 100.2 0.0 0.018 7320 7144 pg123.cx4a | |
--- MySQL 8.0.21, l.i0 loads 500m rows | |
l.i0 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
81064 0 0 2 30832 0.000 0.000 0.380 20196 43.0 0.249 21 32.8 42.3 11.1 0.139 81455 72530 my8021.cx1 | |
83612 0 0 2 31783 0.000 0.000 0.380 19350 40.7 0.231 19 32.8 42.3 11.1 0.253 84118 72734 my8021.cx1 | |
l.x | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
104997 0 477 92456 116776 0.005 0.881 1.112 6570 23.1 0.063 9 73.3 82.8 11.2 0.020 NA NA my8021.cx1 | |
111356 0 621 98222 124076 0.006 0.882 1.114 7068 22.8 0.063 8 73.3 82.8 11.2 0.009 NA NA my8021.cx1 | |
l.i1 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
3147 0 1575 25204 82147 0.501 8.010 26.107 20844 24.8 6.624 315 101.4 112.9 11.2 0.714 899 100 my8021.cx1 | |
3620 0 1812 28985 94225 0.500 8.006 26.025 20478 29.1 5.656 322 101.4 112.9 11.2 0.420 1000 350 my8021.cx1 | |
q100.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
100 649 2480 39687 7108 3.820 61.113 71.223 10688 21.0 16.458 1294 101.4 112.9 11.2 0.047 623 527 my8021.cx1 | |
100 674 2576 41211 7353 3.819 61.099 73.673 10989 23.6 16.293 1400 101.4 112.9 11.2 0.049 656 543 my8021.cx1 | |
q200.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
200 693 2672 42760 8153 3.856 61.702 40.825 11843 21.1 17.090 1218 101.5 113.0 11.2 0.036 671 543 my8021.cx1 | |
200 688 2655 42476 8101 3.856 61.694 40.568 11779 23.6 17.108 1371 101.5 113.0 11.2 0.050 672 543 my8021.cx1 | |
q400.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
400 688 2692 43073 10913 3.912 62.588 27.316 12522 21.7 18.196 1261 101.6 113.1 11.2 0.048 671 543 my8021.cx1 | |
399 694 2716 43462 11016 3.915 62.635 27.589 12571 23.8 18.117 1372 101.6 113.1 11.2 0.055 687 543 my8021.cx1 | |
q600.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
599 689 2787 44589 14629 4.047 64.744 24.422 13290 22.1 19.298 1284 101.7 113.5 11.2 0.072 671 527 my8021.cx1 | |
599 676 2740 43845 14602 4.057 64.907 24.378 13082 24.3 19.366 1439 101.7 113.5 11.2 0.087 671 528 my8021.cx1 | |
q800.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
799 701 2931 46900 19029 4.181 66.894 23.828 14234 22.9 20.302 1306 101.9 114.1 11.2 0.071 687 544 my8021.cx1 | |
799 672 2814 45018 18625 4.186 66.981 23.323 13707 24.8 20.394 1476 101.9 114.1 11.2 0.092 656 543 my8021.cx1 | |
q1000.2 | |
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
998 678 2934 46952 22729 4.327 69.231 22.767 14550 23.3 21.454 1374 102.1 114.8 11.2 0.082 671 543 my8021.cx1 | |
999 661 2857 45707 22775 4.323 69.168 22.802 14134 25.2 21.389 1525 102.1 114.8 11.2 0.124 655 527 my8021.cx1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This test is an IO-bound insert benchmark. Top number is from Ubuntu 18.04, bottom number is from Ubuntu 20.04. Tests used the same HW & same configs, but different compiler, toolchain & kernel. Versions for Ubuntu 18 & 20: