Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created October 4, 2017 21:03
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/f2548bcfa59612d878eb05109449524b to your computer and use it in GitHub Desktop.
Save mdcallag/f2548bcfa59612d878eb05109449524b 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
199 288 0.701 0.046 53 0.093 124.875 88.0 myrocks.none
114 532 0.749 0.008 57 0.001 136.750 2.0 myrocks.none.ra
280 99 0.356 0.047 27 0.094 251.125 74.5 myrocks.zstd
215 147 0.395 0.008 30 0.001 261.875 0.5 myrocks.zstd.ra
137 449 0.748 0.047 57 0.028 109.500 32.1 inno5635
103 593 0.759 0.047 58 0.039 54.375 43.4 inno5717
post
secs rMB/s rKB/o r/o rGB cs/o Mcpu/o wa.sec engine
210 285 0.730 0.049 56 0.098 128.500 98.6 myrocks.none
121 526 0.808 0.009 62 0.001 148.875 2.1 myrocks.none.ra
292 102 0.377 0.050 29 0.100 258.250 82.6 myrocks.zstd
226 148 0.418 0.007 32 0.001 274.375 0.6 myrocks.zstd.ra
132 462 0.769 0.048 59 0.029 111.625 31.7 inno5635
100 609 0.779 0.049 59 0.041 56.000 40.6 inno5717
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment