gistfile1.txt

sysbench: 8 tables, 80M rows/table, 7th gen core i5 NUC with 16gb RAM, fast SSD

Typical command line:
bash all_small.sh 4 80000000 600 600 300 innodb 1 0 ~/b/orig802/bin/mysql none ~/b/sysbench10

binaries:
* myrocks.none - MyRocks built on August 15, 2017 with githash 0d76ae and not using compression
* inno5635 - InnoDB from upstream 5.6.35
* inno5717 - InnoDB from upstream 5.7.17
* inno802 - InnoDB from upstream 8.0.2

configuration:
* server has 16gb of RAM. MyRocks uses a 4gb block cache and buffered IO. InnoDB uses a 12gb
  buffer pool and O_DIRECT.
* binlog is enabled, sync on commit is disabled for the binlog and database log
* SSL is disabled
* sysbench and mysqld share the server

QPS ratio:
* rocks = myrocks.none / inno5635
* inno = inno5717 / inno5635
* toku = toku5717.none / inno5635

1 connection
rocks   inno
2.909   1.074   update-index
1.068   1.095   update-nonindex
1.006   0.935   update-nonindex-special
1.682   0.988   delete-only
1.053   0.961   read-write.range100
0.881   1.554   read-write.range10000
0.776   1.348   read-only.range100
0.898   1.584   read-only.range10000
0.651   1.197   point-query
1.000   1.285   random-points
0.267   0.943   hot-points
0.989   0.941   insert-only

update-index
1       2       concurrency/engine
2659    5007    myrocks.none
 914    1221    inno5635
 982    1225    inno5717
 946    1175    inno802

update-nonindex
1       2       concurrency/engine
2759    4751    myrocks.none
2581    4056    inno5635
2827    3704    inno5717
2669    3322    inno802

update-nonindex-special
1       2       concurrency/engine
4802    8119    myrocks.none
4773    6550    inno5635
4465    5797    inno5717
4015    5285    inno802

delete-only
1       2       concurrency/engine
8465    14925   myrocks.none
5032     7115   inno5635
4976     6691   inno5717
4717     6424   inno802

read-write.range100
1       2       concurrency/engine
2977    5744    myrocks.none
2826    5286    inno5635
2716    5793    inno5717
2747    5579    inno802

read-write.range10000
1       2       concurrency/engine
194     319     myrocks.none
220     351     inno5635
342     519     inno5717
338     514     inno802

read-only.range100
1       2       concurrency/engine
2863    5776    myrocks.none
3689    7311    inno5635
4976    8967    inno5717
4919    8746    inno802

read-only.range10000
1       2       concurrency/engine
160     259     myrocks.none
178     299     inno5635
282     448     inno5717
277     441     inno802

point-query
1       2       concurrency/engine
3468     7640   myrocks.none
5327     9708   inno5635
6381    11626   inno5717
6199    11195   inno802

random-points
1       2       concurrency/engine
 63     121     myrocks.none
 63     156     inno5635
 81     173     inno5717
 72     172     inno802

hot-points
1       2       concurrency/engine
1083    2140    myrocks.none
4050    7695    inno5635
3823    7649    inno5717
3699    7376    inno802

insert
1       2       concurrency/engine
7941    13253   myrocks.none
8025    11483   inno5635
7559    10258   inno5717
6816     9630   inno802