Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created October 4, 2017 21:25
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/1b86a00ba81167fc1dfc5181778f249e to your computer and use it in GitHub Desktop.
Save mdcallag/1b86a00ba81167fc1dfc5181778f249e 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
135 215 0.716 0.046 27 0.093 134.750 81 myrocks.none
68 434 0.666 0.009 25 0.001 146.000 4 myrocks.none.ra
175 89 0.387 0.047 15 0.095 301.750 54 myrocks.zstd
138 114 0.378 0.007 14 0.001 310.000 7 myrocks.zstd.ra
107 288 0.738 0.030 28 0.034 116.750 41 inno5635
457 67 0.773 0.032 29 0.067 67.000 296 inno5717
post
secs rMB/s rKB/o r/o rGB cs/o Mcpu/o wa.sec engine
229 140 0.785 0.050 30 0.101 150.500 164 myrocks.none
137 235 0.782 0.009 30 0.002 167.250 40 myrocks.none.ra
234 70 0.413 0.050 16 0.101 319.250 107 myrocks.zstd
173 96 0.417 0.007 16 0.001 337.750 28 myrocks.zstd.ra
171 179 0.778 0.032 30 0.034 124.750 84 inno5635
177 173 0.752 0.031 29 0.066 59.000 105 inno5717
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment