Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created October 23, 2020 16:44
Show Gist options
  • Save mdcallag/756eb6ae48a4b2b5b6503fe6aeea6c17 to your computer and use it in GitHub Desktop.
Save mdcallag/756eb6ae48a4b2b5b6503fe6aeea6c17 to your computer and use it in GitHub Desktop.
--- Postgres 12.3, 20m rows loaded in l.i0
l.i0
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
101523 0 0 0 43776 0.000 0.000 0.431 12578 46.7 0.124 18 1.9 5.2 0.0 0.009 101888 81114 pg123.cx4a
104167 0 0 0 44958 0.000 0.000 0.432 12559 42.8 0.121 16 1.9 5.2 0.0 0.002 104587 83469 pg123.cx4a
l.x
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
157031 0 0 0 40427 0.000 0.000 0.257 1091 24.5 0.007 6 3.7 7.9 0.0 0.002 NA NA pg123.cx4a
168908 0 0 0 48456 0.000 0.000 0.287 960 24.6 0.006 6 3.7 7.9 0.0 0.002 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
27624 0 0 0 44185 0.000 0.000 1.599 6924 32.1 0.251 46 8.2 15.5 0.0 0.380 35461 1448 pg123.cx4a
28011 0 0 1 44538 0.000 0.000 1.590 7011 33.6 0.250 48 8.2 15.7 0.0 0.746 35961 1498 pg123.cx4a
q100.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
100 7758 0 0 3139 0.000 0.000 31.453 29879 27.0 3.851 139 8.2 12.5 0.0 0.013 7767 7671 pg123.cx4a
100 7642 0 0 3138 0.000 0.000 31.447 29417 29.2 3.850 153 8.2 12.6 0.0 0.004 7642 7512 pg123.cx4a
q200.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
200 7745 0 0 5545 0.000 0.000 27.782 29856 28.5 3.855 147 8.4 9.9 0.0 0.012 7751 7640 pg123.cx4a
200 7613 0 0 5556 0.000 0.000 27.835 29329 30.5 3.853 160 8.4 9.9 0.0 0.007 7624 7496 pg123.cx4a
q400.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
399 7723 0 0 9173 0.000 0.000 22.974 29842 30.8 3.864 160 8.8 10.4 0.0 0.019 7726 7608 pg123.cx4a
400 7610 0 0 9196 0.000 0.000 23.019 29373 32.1 3.860 169 8.8 10.4 0.0 0.007 7608 7480 pg123.cx4a
q600.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
599 7697 0 0 12239 0.000 0.000 20.432 29798 31.8 3.871 165 10.0 11.9 0.0 0.013 7704 7544 pg123.cx4a
599 7579 0 0 12242 0.000 0.000 20.438 29313 33.0 3.868 174 10.0 11.9 0.0 0.010 7592 7434 pg123.cx4a
q800.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
799 7705 7 59 14293 0.001 0.008 17.898 29878 32.0 3.878 166 11.3 13.4 0.0 0.013 7719 7560 pg123.cx4a
799 7601 8 66 14319 0.001 0.009 17.930 29456 33.0 3.875 174 11.3 13.4 0.0 0.005 7608 7435 pg123.cx4a
q1000.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
998 7715 0 1 15947 0.000 0.000 15.974 29947 32.8 3.882 170 12.0 14.3 0.0 0.013 7722 7544 pg123.cx4a
998 7607 0 1 15964 0.000 0.000 15.991 29510 33.8 3.879 178 12.0 14.3 0.0 0.008 7610 7416 pg123.cx4a
--- MySQL 8.0.21, 20m rows loaded in l.i0
l.i0
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
82645 0 0 0 24991 0.000 0.000 0.302 19385 42.6 0.235 21 1.3 10.9 2.5 0.109 83148 37350 my8021.cx1
84034 0 0 0 25270 0.000 0.000 0.301 18792 40.6 0.224 19 1.3 10.9 2.5 0.117 84607 57122 my8021.cx1
l.x
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
145652 0 0 0 124663 0.000 0.000 0.856 8812 24.9 0.061 7 3.0 12.5 3.0 0.009 NA NA my8021.cx1
157031 0 0 0 137841 0.000 0.000 0.878 9570 24.4 0.061 6 3.0 12.5 3.0 0.010 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
26738 0 99 1589 41510 0.004 0.059 1.552 16031 32.3 0.600 48 7.9 17.4 8.3 0.134 28319 549 my8021.cx1
27100 0 105 1685 41251 0.004 0.062 1.522 16086 33.1 0.594 49 7.9 17.4 8.3 0.438 29076 400 my8021.cx1
q100.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
100 6019 0 0 1227 0.000 0.000 12.299 23965 25.9 3.982 172 8.1 17.6 8.5 0.018 6026 5929 my8021.cx1
100 6205 0 0 1240 0.000 0.000 12.420 24692 29.3 3.980 189 8.1 17.6 8.5 0.019 6217 6009 my8021.cx1
q200.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
200 6087 0 0 1756 0.000 0.000 8.795 24316 26.0 3.995 171 8.4 17.9 8.8 0.012 6089 6009 my8021.cx1
200 6321 0 0 1762 0.000 0.000 8.825 25213 29.3 3.989 185 8.4 17.9 8.8 0.020 6329 6140 my8021.cx1
q400.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
399 6046 0 0 2047 0.000 0.000 5.128 24259 26.3 4.012 174 8.8 18.3 9.1 0.018 6057 5945 my8021.cx1
399 6236 0 0 2044 0.000 0.000 5.119 24995 29.5 4.008 189 8.8 18.3 9.2 0.023 6249 6089 my8021.cx1
q600.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
599 6033 0 0 2064 0.000 0.000 3.446 24304 26.6 4.028 176 9.0 18.6 9.4 0.007 6041 5961 my8021.cx1
599 6257 0 0 2074 0.000 0.000 3.462 25151 29.5 4.019 189 9.0 18.6 9.4 0.017 6265 6105 my8021.cx1
q800.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
799 5994 0 0 2935 0.000 0.000 3.675 24318 26.8 4.057 179 9.4 18.9 9.7 0.017 6009 5898 my8021.cx1
799 6149 0 0 2927 0.000 0.000 3.663 24892 29.7 4.048 193 9.4 18.9 9.7 0.022 6153 5978 my8021.cx1
q1000.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
998 5957 0 0 3911 0.000 0.000 3.917 24349 26.9 4.088 181 10.0 19.6 10.3 0.021 5962 5836 my8021.cx1
999 6161 0 0 3911 0.000 0.000 3.915 25096 30.0 4.073 195 10.0 19.6 10.3 0.021 6169 5993 my8021.cx1
@mdcallag
Copy link
Author

mdcallag commented Oct 23, 2020

This test is an in-memory 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