Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created October 20, 2020 22:46
Show Gist options
  • Save mdcallag/d4cb869e132d8ceba1806d7d6437e082 to your computer and use it in GitHub Desktop.
Save mdcallag/d4cb869e132d8ceba1806d7d6437e082 to your computer and use it in GitHub Desktop.
Ratio of ips or qps for rx80.cx6a / rx56.cx6a. A value less than zero means that rx80 is slower.
* rx56 is MyRocks from MySQL 5.6.35
* rx80 is MyRocks from MySQL 8.0.17
* cx6a names the my.cnf I used
l.i0 l.x l.i1 q100.2 q200.2 q400.2 q600.2 q800.2 q1000.2
.80 1.03 .87 .92 .90 .89 .90 .91 .92
l.i0
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
105887 0 0 0 16337 0.000 0.000 0.154 11061 45.8 0.104 17 24.9 37.6 2.5 0.153 107685 82211 rx56.cx6a
84991 0 0 0 13234 0.000 0.000 0.156 9191 42.0 0.108 20 24.9 37.7 2.8 0.416 85835 65055 rx80.cx6a
l.x
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
99404 0 71 27042 17688 0.001 0.272 0.178 958 24.8 0.010 10 54.5 67.2 13.0 0.007 NA NA rx56.cx6a
102165 0 90 28269 18181 0.001 0.277 0.178 1197 24.6 0.012 10 54.5 67.3 12.6 0.008 NA NA rx80.cx6a
l.i1
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
42017 0 0 0 30965 0.000 0.000 0.737 9058 40.9 0.216 39 55.7 56.3 12.0 0.068 41905 34163 rx56.cx6a
36630 0 0 0 26748 0.000 0.000 0.730 8363 41.1 0.228 45 55.7 56.4 12.4 0.183 36709 32115 rx80.cx6a
q100.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
100 5286 0 0 519 0.000 0.000 5.201 20300 25.3 3.841 191 55.9 56.4 12.1 0.014 5482 4827 rx56.cx6a
100 4858 0 0 519 0.000 0.000 5.198 19017 27.8 3.914 229 55.8 56.6 12.2 0.015 4861 4715 rx80.cx6a
q200.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
200 5370 0 0 43 0.000 0.000 0.215 20604 25.8 3.837 192 55.9 56.5 12.2 0.003 5386 5243 rx56.cx6a
200 4815 0 0 44 0.000 0.000 0.218 18837 27.9 3.912 232 55.8 56.7 12.4 0.003 4813 4731 rx80.cx6a
q400.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
399 5341 0 0 617 0.000 0.000 1.546 20562 26.1 3.850 195 56.1 57.0 12.2 0.002 5354 5178 rx56.cx6a
399 4774 0 0 618 0.000 0.000 1.547 18740 28.4 3.925 238 56.1 57.1 12.2 0.004 4779 4667 rx80.cx6a
q600.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
599 5302 0 0 115 0.000 0.000 0.193 20410 26.0 3.850 196 56.3 57.4 12.6 0.004 5306 5162 rx56.cx6a
599 4767 0 0 117 0.000 0.000 0.195 18722 28.3 3.927 237 56.2 57.5 12.5 0.004 4764 4683 rx80.cx6a
q800.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
799 5160 0 0 738 0.000 0.000 0.924 19946 25.9 3.866 201 56.7 58.2 12.8 0.003 5162 4875 rx56.cx6a
799 4679 0 0 739 0.000 0.000 0.925 18450 28.4 3.943 243 56.6 58.3 12.4 0.005 4683 4555 rx80.cx6a
q1000.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
998 5083 0 0 740 0.000 0.000 0.741 19682 25.8 3.872 203 57.1 59.0 12.9 0.008 5098 4843 rx56.cx6a
998 4672 0 0 665 0.000 0.000 0.666 18447 28.5 3.948 244 57.0 59.2 12.4 0.008 4683 4571 rx80.cx6a
@mdcallag
Copy link
Author

rx.500m

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