gistfile1.txt

--- linkbench id1=1b, 28 clients

- load, ldop=4
ips     r/i     rkb/i   wkb/i   Mcpu/i  size    rss     r/s     rMB/s   wMB/s   cpu     engine
171840  0       0       1.44    86      693      3.5      5      0.5    247.4   14.9    myrocks.16jun17.none
172902  0       0       1.43    85      693      5.4      3      0.2    247.5   14.7    myrocks.8may18.none
175002  0       0.31    1.36    83      693     12.1    431     53.8    238.2   14.5    myrocks.8may18.none.dio
172326  0       0       1.81    94      333      3.4      8      0.8    312.8   16.3    myrocks.16jun17.zstd
172287  0       0       1.81    92      331      3.5      8      0.8    312.0   15.8    myrocks.8may18.zstd
172520  0       0.48    1.71    89      332      3.5    663     83.0    294.9   15.4    myrocks.8may18.zstd.dio

- query @ 12h, mysql
tps     r/t     rkb/t   wkb/t   Mcpu/t  size    rss     un      gn      ul      gl      r/s     rMB/s   wMB/s   cpu     engine
40698   1.16    23.20   2.01    800     760     33.1    1       1       1       1       47065   944.2   81.8    32.6    myrocks.16jun17.none
41424   1.15    23.61   2.09    783     761     33.2    1       1       1       1       47474   978.0   86.4    32.4    myrocks.8may18.none
37842   1.16    23.79   1.94    756     757     33.1    1       1       1       1       43997   900.2   73.2    28.6    myrocks.8may18.none.dio
43514   1.12    13.65   1.94    926     367     33.2    1       0.9     1       1       48602   593.8   84.2    40.3    myrocks.16jun17.zstd
44876   1.09    13.78   1.90    890     369     33.1    1       0.9     1       1       49009   618.2   85.2    39.9    myrocks.8may18.zstd
42728   1.12    14.40   1.94    872     367     33.1    1       1       1       1       48020   615.2   83.0    37.2    myrocks.8may18.zstd.dio

legend for binaries test:
* MyRocks builds are from June 16, 2017 and May 8, 2018
* none means no compression, zstd means no compression for small levels, lz4 for mid levels, zstd for max level
* dio means O_DIRECT is used, otherwise buffered IO is used

test setup:
* 50gb of RAM available to user land, server has 56 HW threads and fast SSD
* client/mysqld share server
* MyRocks uses 30gb block cache
* load done with 4 clients, transactions done for 12 hours with 28 clients

legend for load metrics above:
* ips - average inserts/second
* r/i, rkb/i, wkb/i - iostat reads/insert, read KB/insert and write KB/insert
* Mcpu/i - vmstat us+sy normalized by the insert rate and then multiplied by large constant
* size - database size in GB at end of load
* rss - mysqld RSS in GB at end of load
* r/s, rMB/s, wMB/s - iostat r/s, read MB/s and write MB/s
* cpu - average vmstat us+sy

legend for query metrics above - metrics are from 12th hour:
* tps - average transactions/second
* r/t, rkb/t, wkb/t - iostat reads/transaction, read KB/transaction, write KB/transaction
* Mcpu/t - vmstat us+sy normalized by the transaction rate and then multiplied by large constant
* size - database size in GB at test end
* rss - mysqld RSS in GB at test end
* un, gn, ul, gl - p99 response time in millisecs for UpdateNode, GetNode, UpdateList, GetList transactions
* r/s, rMB/s, wMB/s - iostat r/s, read MB/s and write MB/s
* cpu - average vmstat us+sy