Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created October 23, 2020 16:47
Show Gist options
  • Save mdcallag/5621a3f72b3cae8c62aa7b8ad0df90d5 to your computer and use it in GitHub Desktop.
Save mdcallag/5621a3f72b3cae8c62aa7b8ad0df90d5 to your computer and use it in GitHub Desktop.
--- Postgres 12.3, l.i0 loads 100m rows
l.i0
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
100908 0 0 0 43960 0.000 0.000 0.436 12282 46.6 0.122 18 9.6 17.2 0.0 0.009 101089 96965 pg123.cx4a
104384 0 0 1 45243 0.000 0.000 0.433 12388 42.8 0.119 16 9.6 17.4 1.1 0.031 104686 99063 pg123.cx4a
l.x
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
127842 0 40 4954 40339 0.000 0.039 0.316 311 24.5 0.002 8 18.4 26.0 0.0 0.002 NA NA pg123.cx4a
136376 0 47 5815 43857 0.000 0.043 0.322 351 24.8 0.003 7 18.4 26.3 0.0 0.003 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
11641 0 1001 9470 44368 0.086 0.813 3.811 5060 26.5 0.435 91 21.4 30.5 0.0 0.114 5146 1299 pg123.cx4a
10870 0 928 8644 45569 0.085 0.795 4.192 4688 27.6 0.431 102 21.4 30.3 0.0 0.175 4545 1398 pg123.cx4a
q100.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
100 7766 0 0 3696 0.000 0.000 37.030 29914 27.0 3.852 139 21.8 27.2 0.0 0.013 7768 7662 pg123.cx4a
100 7558 0 0 3694 0.000 0.000 37.016 29102 29.2 3.851 155 21.8 26.7 0.0 0.004 7566 7402 pg123.cx4a
q200.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
200 7724 0 3 6796 0.000 0.000 34.049 29788 28.6 3.857 148 22.6 24.3 0.0 0.012 7723 7608 pg123.cx4a
200 7587 0 3 6801 0.000 0.000 34.075 29240 30.4 3.854 160 22.6 24.3 0.0 0.005 7592 7448 pg123.cx4a
q400.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
399 7721 56 500 11911 0.007 0.065 29.830 29942 30.7 3.878 159 24.1 25.9 0.0 0.011 7724 7592 pg123.cx4a
399 7599 56 496 11862 0.007 0.065 29.706 29454 32.2 3.876 170 24.1 25.9 0.0 0.006 7608 7400 pg123.cx4a
q600.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
599 7744 168 1489 15222 0.022 0.192 25.413 30293 31.5 3.912 163 25.9 28.0 0.0 0.011 7752 7623 pg123.cx4a
599 7606 168 1492 15215 0.022 0.196 25.400 29737 32.8 3.910 172 25.9 28.0 0.0 0.007 7608 7464 pg123.cx4a
q800.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
799 7729 209 1866 17244 0.027 0.241 21.593 30379 32.6 3.931 169 26.6 28.9 0.0 0.011 7736 7560 pg123.cx4a
799 7579 209 1869 17229 0.028 0.247 21.573 29760 33.5 3.927 177 26.6 28.8 0.0 0.012 7592 7432 pg123.cx4a
q1000.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
999 7698 247 2205 20275 0.032 0.286 20.299 30366 34.2 3.945 178 27.0 29.7 0.0 0.011 7704 7544 pg123.cx4a
999 7566 231 2079 20271 0.031 0.275 20.296 29797 34.9 3.938 185 27.0 29.7 0.0 0.007 7576 7400 pg123.cx4a
--- MySQL 8.0.21, l.i0 loads 100m rows
l.i0
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
84674 0 0 0 30705 0.000 0.000 0.363 19974 43.1 0.236 20 6.6 16.1 7.7 0.117 85135 75573 my8021.cx1
84246 0 0 0 30562 0.000 0.000 0.363 19272 41.0 0.229 19 6.6 16.1 7.7 0.205 84806 72979 my8021.cx1
l.x
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
130000 0 120 86822 127176 0.001 0.668 0.978 7781 24.4 0.060 8 14.7 24.2 11.1 0.007 NA NA my8021.cx1
130679 0 154 88676 129876 0.001 0.679 0.994 8265 22.8 0.063 7 14.7 24.2 11.1 0.023 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
11211 0 635 10158 63253 0.057 0.906 5.642 18031 25.8 1.608 92 22.2 31.9 11.2 0.712 16436 100 my8021.cx1
13387 0 813 13004 76111 0.061 0.971 5.686 18059 30.6 1.349 91 22.2 31.9 11.2 0.473 18896 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 5951 12 192 1571 0.002 0.032 15.738 23834 26.0 4.005 175 22.3 31.9 11.2 0.006 5961 5866 my8021.cx1
100 6052 12 192 1553 0.002 0.032 15.558 24236 29.5 4.004 195 22.3 31.9 11.2 0.006 6057 5902 my8021.cx1
q200.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
200 5963 13 212 2633 0.002 0.036 13.192 24022 26.1 4.029 175 22.3 31.9 11.2 0.007 5964 5866 my8021.cx1
200 5936 13 211 2672 0.002 0.035 13.388 23921 29.5 4.030 199 22.3 31.9 11.2 0.016 5945 5786 my8021.cx1
q400.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
399 5935 15 240 2974 0.003 0.040 7.448 24056 26.5 4.053 179 22.4 32.0 11.2 0.017 5945 5834 my8021.cx1
400 6009 15 240 2989 0.002 0.040 7.482 24314 29.7 4.047 198 22.4 32.0 11.2 0.006 6010 5853 my8021.cx1
q600.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
599 5936 16 253 4072 0.003 0.043 6.797 24262 26.8 4.087 181 22.6 32.2 11.2 0.025 5945 5849 my8021.cx1
599 6061 16 254 4069 0.003 0.042 6.792 24724 30.0 4.079 198 22.6 32.2 11.2 0.010 6073 5898 my8021.cx1
q800.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
799 5904 17 273 5605 0.003 0.046 7.019 24377 27.1 4.129 184 22.7 32.6 11.2 0.016 5913 5802 my8021.cx1
799 6020 17 271 5574 0.003 0.045 6.979 24806 30.2 4.120 201 22.7 32.6 11.2 0.008 6025 5867 my8021.cx1
q1000.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
998 5823 19 310 6880 0.003 0.053 6.892 24344 27.7 4.181 190 23.0 33.2 11.2 0.015 5834 5738 my8021.cx1
998 5975 20 312 6881 0.003 0.052 6.893 24910 30.8 4.169 206 23.0 33.2 11.2 0.016 5978 5818 my8021.cx1
@mdcallag
Copy link
Author

mdcallag commented Oct 23, 2020

This test is a somewhat 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