Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:ad509e74d56d2872907d8170aba52c9c

Created October 20, 2020 22:45
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/ad509e74d56d2872907d8170aba52c9c to your computer and use it in GitHub Desktop.
Save mdcallag/ad509e74d56d2872907d8170aba52c9c 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
.82 .99 .87 .99 .89 .90 .90 .90 .91
l.i0
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
105485 0 0 0 16175 0.000 0.000 0.153 10907 45.7 0.103 17 4.9 10.0 1.5 0.117 107685 82010 rx56.cx6a
85984 0 0 0 13251 0.000 0.000 0.154 9232 42.2 0.107 20 4.8 10.2 1.9 0.257 87304 70123 rx80.cx6a
l.x
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
107403 0 23 6033 19531 0.000 0.056 0.182 903 24.5 0.008 9 11.1 16.3 6.6 0.001 NA NA rx56.cx6a
106150 0 31 8332 19339 0.000 0.078 0.182 1083 24.6 0.010 9 11.1 16.4 7.1 0.005 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
41322 0 0 0 23204 0.000 0.000 0.562 8606 38.5 0.208 37 12.3 18.8 6.8 0.069 41121 34013 rx56.cx6a
36101 0 0 0 20209 0.000 0.000 0.560 7932 39.5 0.220 44 12.3 19.0 7.3 0.145 36023 30817 rx80.cx6a
q100.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
100 4824 0 0 25 0.000 0.000 0.248 18509 24.2 3.837 201 12.5 19.0 8.1 0.002 4827 4731 rx56.cx6a
100 4772 0 0 25 0.000 0.000 0.250 18664 27.8 3.911 233 12.5 19.1 8.6 0.006 4779 4684 rx80.cx6a
q200.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
200 5293 0 0 43 0.000 0.000 0.214 20309 25.6 3.837 193 12.5 19.1 8.2 0.002 5290 5178 rx56.cx6a
200 4722 0 0 43 0.000 0.000 0.218 18482 27.9 3.914 236 12.5 19.2 8.8 0.002 4731 4651 rx80.cx6a
q400.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
399 5304 0 0 624 0.000 0.000 1.562 20417 26.0 3.850 196 12.7 19.5 9.1 0.008 5306 5050 rx56.cx6a
399 4769 0 0 624 0.000 0.000 1.563 18718 28.4 3.925 238 12.7 19.7 9.6 0.002 4779 4655 rx80.cx6a
q600.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
599 5291 0 0 446 0.000 0.000 0.745 20392 26.1 3.854 197 13.0 20.1 9.9 0.011 5290 5114 rx56.cx6a
599 4737 0 0 448 0.000 0.000 0.748 18626 28.4 3.932 240 13.0 20.2 10.4 0.004 4747 4635 rx80.cx6a
q800.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
799 5240 0 0 603 0.000 0.000 0.754 20242 26.2 3.863 200 13.3 20.7 10.9 0.006 5258 4926 rx56.cx6a
799 4738 0 0 604 0.000 0.000 0.756 18661 28.5 3.939 241 13.3 20.8 11.4 0.008 4747 4589 rx80.cx6a
q1000.2
ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag
998 5211 2 73 1772 0.000 0.014 1.775 20240 26.6 3.884 204 13.8 21.7 11.3 0.010 5226 4795 rx56.cx6a
998 4718 2 178 1772 0.001 0.038 1.775 18671 29.1 3.958 247 13.8 21.8 11.8 0.006 4718 4571 rx80.cx6a
@mdcallag
Copy link
Author

rx.100m

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