Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:9cff65c38309a391b1b62c9cb1972b9f

Last active December 5, 2017 15: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/9cff65c38309a391b1b62c9cb1972b9f to your computer and use it in GitHub Desktop.
Save mdcallag/9cff65c38309a391b1b62c9cb1972b9f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
size after load in GB
size engine
73 MyRocks.feb10.none
48 MyRocks.feb10.zstd
87 FbInno5635.apr14
89 Inno5635
89 Inno5717
88 Inno801
88 Inno802
88 Inno803
83 Toku5717.none
47 Toku5717.zlib
legend:
* r/s, rMB/s, wMB/s - iostat reads/s, read MB/s, write MB/s
* r/t, rkb/t, wkb/t - iostat reads/tpmc, read KB/tpmc, write KB/tpmc
* tpmc - transaction throughput
* cs/s, cpus/ - vmstat context switches/second, CPU/second (us+sy columns)
* cs/t - context switches / tpmc
* Mcpu/t - relative CPU overhead / tpmc
* size - database size in GB at end
transactions, hour=1
r/s rMB/s wMB/s r/t rkb/t wkb/t tpmc cs/s cpu/s cs/t Mcpu/t size engine
17433 278.5 344.0 0.18 2.90 3.59 95909 551598 41.6 5.751 434 79 MyRocks.Feb10.none
10104 177.0 149.0 0.10 1.83 1.54 96920 540072 41.8 5.572 431 82 MyRocks.Apr14.none
9772 171.3 143.3 0.11 1.84 1.54 93326 519221 41.9 5.564 448 81 MyRocks.Jun16.none
10249 187.7 154.5 0.10 1.88 1.55 100012 561717 41.4 5.616 414 81 MyRocks.Oct16.none
-
17592 215.3 281.4 0.20 2.42 3.16 89110 514427 49.0 5.773 549 64 MyRocks.Feb10.zstd
7741 104.8 134.2 0.08 1.10 1.40 95695 526952 44.4 5.507 464 53 MyRocks.Apr14.zstd
7602 103.3 130.1 0.08 1.12 1.41 92374 508140 44.4 5.501 481 56 MyRocks.Jun16.zstd
7984 107.3 139.9 0.08 1.09 1.42 98855 551605 44.1 5.580 446 54 MyRocks.Oct16.zstd
-
9384 150.1 524.7 0.08 1.28 4.49 116960 745580 38.2 6.375 326 99 FbInno5635
8332 133.3 464.5 0.08 1.33 4.64 100073 676593 35.3 6.761 353 103 Inno5635
9449 151.2 542.0 0.08 1.28 4.58 118337 722843 41.2 6.108 348 105 Inno5717
9129 146.1 524.8 0.08 1.30 4.67 112318 670986 41.0 5.974 365 104 Inno801
8605 137.7 502.3 0.08 1.32 4.83 103958 625746 41.3 6.019 398 103 Inno802
8615 137.8 502.5 0.08 1.32 4.82 104228 625480 41.3 6.001 397 103 Inno803
-
11152 242.6 116.9 0.23 4.92 2.37 49288 303588 39.2 6.159 796 123 Toku5717.none
5785 89.5 76.0 0.14 2.12 1.80 42283 253849 45.4 6.004 1073 73 Toku5717.zlib
transactions, hour=12
r/s rMB/s wMB/s r/t rkb/t wkb/t tpmc cs/s cpu/s cs/t Mcpu/t size engine
17262 294.9 363.6 0.18 3.14 3.88 93856 548482 41.7 5.844 444 133 MyRocks.Feb10.none
9948 181.5 162.6 0.10 1.89 1.69 96196 534550 41.9 5.557 435 132 MyRocks.Apr14.none
9645 176.1 157.5 0.11 1.91 1.71 92284 511709 42.0 5.545 455 129 MyRocks.Jun16.none
10066 190.5 167.7 0.10 1.94 1.71 98414 554667 41.5 5.636 422 132 MyRocks.Oct16.none
-
16022 225.1 302.1 0.18 2.52 3.38 89381 516648 49.1 5.780 550 89 MyRocks.Feb10.zstd
7706 110.5 145.1 0.08 1.17 1.54 94168 519499 44.7 5.517 474 81 MyRocks.Apr14.zstd
7483 106.6 139.6 0.08 1.18 1.55 90493 500304 44.7 5.529 494 78 MyRocks.Jun16.zstd
8048 113.4 149.4 0.08 1.18 1.55 96517 542225 44.4 5.618 460 80 MyRocks.Oct16.zstd
-
9204 147.3 531.2 0.08 1.34 4.83 110060 731993 38.8 6.651 352 229 FbInno5635
7957 127.3 461.3 0.08 1.34 4.86 94882 668094 35.7 7.041 377 229 Inno5635
9435 151.0 554.5 0.08 1.35 4.95 112150 697981 41.1 6.224 366 254 Inno5717
8986 143.8 532.0 0.08 1.34 4.97 107063 657727 41.4 6.143 386 246 Inno801
8509 136.1 505.5 0.09 1.37 5.08 99583 613241 41.6 6.158 418 235 Inno802
8430 134.9 499.8 0.08 1.35 4.99 100178 612032 41.6 6.109 415 235 Inno803
-
10653 244.4 128.9 0.26 6.02 3.17 40623 252058 39.6 6.205 975 153 Toku5717.none
5013 85.8 70.1 0.15 2.60 2.13 32965 200507 46.7 6.082 1417 79 Toku5717.zlib
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment