Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created October 23, 2020 16:51
Show Gist options
  • Save mdcallag/15fefd8b508f79accd9383c693fc4894 to your computer and use it in GitHub Desktop.
Save mdcallag/15fefd8b508f79accd9383c693fc4894 to your computer and use it in GitHub Desktop.
--- 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
@mdcallag
Copy link
Author

mdcallag commented Oct 23, 2020

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:

  • gcc - 7.5.0 vs 9.3.0
  • Linux - 4.15.0-118-generic vs 5.4.0-48-generic
  • Glibc was 2.27-3 vs 2.31-0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment