Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created October 4, 2017 19:53
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/90bd72fa19a4f7c2fed8f10a790f6838 to your computer and use it in GitHub Desktop.
Save mdcallag/90bd72fa19a4f7c2fed8f10a790f6838 to your computer and use it in GitHub Desktop.
legend:
* secs - number of seconds for index scan
* rMB/s - iostat MB read/second
* r/o - iostat reads per row scanned
* rGB - iostat GB read during the index scan
* cs/o - vmstat context switches per row scanned
* Mcpu/o - vmstat us+sy * 1M / rows scanned
* wa.sec - number of seconds in vmstat wa state during the test
* engine - *.ra means readahead was enabled, none/zstd/zlib means compression was used
pre
secs rMB/s rKB/o r/o rGB cs/o Mcpu/o wa.sec engine
652 227 0.189 0.012 144 0.032 2.975 3.0 myrocks.none
440 339 0.191 0.002 145 0.005 2.300 0.3 myrocks.none.ra
935 74 0.088 0.011 67 0.033 4.037 0.8 myrocks.zstd
751 92 0.089 0.001 68 0.005 2.938 0.2 myrocks.zstd.ra
602 255 0.196 0.012 149 0.013 3.088 1.0 inno5635
431 356 0.196 0.012 150 0.016 1.788 4.8 inno5717
515 291 0.190 0.002 145 0.006 2.237 0.1 toku5717
1528 51 0.099 0.001 76 0.011 6.225 0.1 toku5717.zlib
post
secs rMB/s rKB/o r/o rGB cs/o Mcpu/o wa.sec engine
1068 152 0.206 0.013 157 0.038 3.638 1.1 myrocks.none
483 336 0.206 0.002 157 0.006 2.450 0 myrocks.none.ra
1101 66 0.093 0.012 71 0.037 4.513 0.2 myrocks.zstd
784 91 0.090 0.001 69 0.005 3.050 0 myrocks.zstd.ra
635 242 0.195 0.012 149 0.013 3.075 0.2 inno5635
294 568 0.211 0.013 161 0.011 1.575 0 inno5717
724 267 0.246 0.002 187 0.029 3.987 0.1 toku5717.none
1805 64 0.148 0.002 113 0.014 11.588 0 toku5717.zlib
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment