Created
October 20, 2020 22:46
-
-
Save mdcallag/d4cb869e132d8ceba1806d7d6437e082 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
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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
rx.500m