Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:299a7a65b9eb31589336886249aa4a60

Created October 20, 2020 22:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/299a7a65b9eb31589336886249aa4a60 to your computer and use it in GitHub Desktop.
Save mdcallag/299a7a65b9eb31589336886249aa4a60 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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
.79 .99 .87 .89 .89 .89 .88 .88 .88
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 15713 0.000 0.000 0.155 10571 45.2 0.104 18 1.0 2.0 1.1 0.115 101488 75517 rx56.cx6a
80645 0 0 0 12488 0.000 0.000 0.155 8598 41.7 0.107 21 1.0 2.2 1.5 0.275 81010 58236 rx80.cx6a
l.x
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
109239 0 0 43 19425 0.000 0.000 0.178 996 24.8 0.009 9 2.3 3.3 2.2 0.003 NA NA rx56.cx6a
108064 0 0 34 20586 0.000 0.000 0.190 1107 25.0 0.010 9 2.3 3.5 2.6 0.006 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
41580 0 9 1165 42507 0.000 0.028 1.022 9347 45.2 0.225 43 4.9 8.5 3.0 0.071 41704 32416 rx56.cx6a
36232 0 8 1023 37292 0.000 0.028 1.029 8472 44.5 0.234 49 5.0 8.8 3.4 0.130 36325 30717 rx80.cx6a
q100.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
100 5518 0 0 25 0.000 0.000 0.247 21153 25.7 3.833 186 4.7 8.3 4.3 0.008 5514 5434 rx56.cx6a
100 4928 0 0 25 0.000 0.000 0.250 19260 27.7 3.909 225 4.6 8.4 4.7 0.003 4927 4843 rx80.cx6a
q200.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
200 5528 0 0 743 0.000 0.000 3.723 21243 26.1 3.843 189 4.8 8.5 4.7 0.002 5530 5354 rx56.cx6a
200 4920 0 0 742 0.000 0.000 3.717 19267 27.9 3.916 227 4.8 8.7 5.1 0.002 4923 4811 rx80.cx6a
q400.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
399 5509 0 0 958 0.000 0.000 2.400 21221 26.2 3.852 190 4.9 8.8 5.3 0.008 5514 5306 rx56.cx6a
399 4907 0 0 958 0.000 0.000 2.400 19258 28.2 3.925 230 4.9 9.0 5.7 0.008 4908 4731 rx80.cx6a
q600.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
599 5533 0 0 781 0.000 0.000 1.304 21332 26.4 3.856 191 5.2 9.3 6.3 0.010 5546 5370 rx56.cx6a
599 4883 0 0 781 0.000 0.000 1.304 19194 28.3 3.930 232 5.2 9.5 6.7 0.004 4891 4763 rx80.cx6a
q800.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
799 5507 1 115 1713 0.000 0.021 2.145 21324 26.9 3.872 195 5.5 10.1 7.5 0.008 5514 5258 rx56.cx6a
799 4869 1 115 1712 0.000 0.024 2.144 19221 28.8 3.947 237 5.5 10.2 7.9 0.011 4875 4667 rx80.cx6a
q1000.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
998 5499 1 43 1914 0.000 0.008 1.917 21331 27.1 3.879 197 5.9 10.9 9.5 0.006 5514 5210 rx56.cx6a
998 4856 1 43 1912 0.000 0.009 1.916 19203 29.1 3.955 240 5.9 11.1 9.9 0.012 4861 4651 rx80.cx6a
@mdcallag
Copy link
Author

rx.20m

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