V7 Large Cluster (Fast Client)

Machines:

  • FoundationDB: 6 x i4i.large, double replication, ssd-redwood-1-experimental storage engine, 2 processes per machine
  • mvstore: 2 x c5.2xlarge, 5 processes
  • ycsb: 1 x c6i.4xlarge

Database page size: 16KiB

ycsb config:

"dotransactions"="true"
"readallfields"="true"
"sqlite.db"="ycsb"
"threadcount"="64"
"sqlite.journalmode"="delete"
"sqlite.cache"="private"
"operationcount"="10000000"
"sqlite.maxopenconns"="1000"
"sqlite.maxidleconns"="1000"
"sqlite.optimistic"="true"
"workload"="core"
"scanproportion"="0"
"command"="run"
"requestdistribution"="uniform"
"recordcount"="1000000"
"readproportion"="0.95"
"updateproportion"="0.05"
"insertproportion"="0"

Raw result:

# workloada, 64 threads, 2 processes
READ   - Takes(s): 200.0, Count: 254665, OPS: 1273.4, Avg(us): 18652, Min(us): 1454, Max(us): 135423, 99th(us): 75327, 99.9th(us): 102527, 99.99th(us): 123071
UPDATE - Takes(s): 200.0, Count: 256257, OPS: 1281.5, Avg(us): 31357, Min(us): 1594, Max(us): 173311, 99th(us): 95167, 99.9th(us): 128063, 99.99th(us): 155903
READ   - Takes(s): 200.0, Count: 254816, OPS: 1274.3, Avg(us): 18738, Min(us): 1032, Max(us): 133759, 99th(us): 75263, 99.9th(us): 101503, 99.99th(us): 124415
UPDATE - Takes(s): 199.9, Count: 254623, OPS: 1273.5, Avg(us): 31465, Min(us): 1533, Max(us): 166399, 99th(us): 94591, 99.9th(us): 127487, 99.99th(us): 157183

# workloadb, 64 threads, 2 processes
READ   - Takes(s): 200.0, Count: 1618987, OPS: 8095.9, Avg(us): 7106, Min(us): 791, Max(us): 32767, 99th(us): 15927, 99.9th(us): 26943, 99.99th(us): 31263
UPDATE - Takes(s): 200.0, Count: 85461, OPS: 427.4, Avg(us): 14834, Min(us): 861, Max(us): 63071, 99th(us): 26559, 99.9th(us): 38623, 99.99th(us): 52511
READ   - Takes(s): 200.0, Count: 1620770, OPS: 8104.5, Avg(us): 7102, Min(us): 720, Max(us): 40415, 99th(us): 15999, 99.9th(us): 27359, 99.99th(us): 34207
UPDATE - Takes(s): 199.9, Count: 84993, OPS: 425.1, Avg(us): 14856, Min(us): 1131, Max(us): 95487, 99th(us): 27231, 99.9th(us): 40063, 99.99th(us): 59103

# workloadc, 64 threads, 2 processes
READ   - Takes(s): 200.0, Count: 1649653, OPS: 8248.1, Avg(us): 7737, Min(us): 705, Max(us): 54847, 99th(us): 23279, 99.9th(us): 50495, 99.99th(us): 54079
READ   - Takes(s): 200.0, Count: 1627989, OPS: 8141.3, Avg(us): 7840, Min(us): 719, Max(us): 55231, 99th(us): 23711, 99.9th(us): 51071, 99.99th(us): 54495

# workloadd, 64 threads, 2 processes
INSERT - Takes(s): 200.0, Count: 49836, OPS: 249.2, Avg(us): 110788, Min(us): 582, Max(us): 6971391, 99th(us): 2136063, 99.9th(us): 3932159, 99.99th(us): 5599231
READ   - Takes(s): 200.0, Count: 940445, OPS: 4702.5, Avg(us): 7715, Min(us): 548, Max(us): 58527, 99th(us): 46751, 99.9th(us): 53535, 99.99th(us): 57535
INSERT - Takes(s): 199.9, Count: 50045, OPS: 250.3, Avg(us): 106777, Min(us): 563, Max(us): 6500351, 99th(us): 2123775, 99.9th(us): 3919871, 99.99th(us): 5402623
READ   - Takes(s): 200.0, Count: 954853, OPS: 4774.8, Avg(us): 7709, Min(us): 581, Max(us): 59295, 99th(us): 46623, 99.9th(us): 53535, 99.99th(us): 57855

# workloade, 64 threads, 2 processes
INSERT - Takes(s): 200.0, Count: 58282, OPS: 291.5, Avg(us): 67157, Min(us): 689, Max(us): 5255167, 99th(us): 1708031, 99.9th(us): 3391487, 99.99th(us): 4468735
SCAN   - Takes(s): 200.0, Count: 1107791, OPS: 5539.4, Avg(us): 7951, Min(us): 723, Max(us): 54623, 99th(us): 22511, 99.9th(us): 49855, 99.99th(us): 53663
INSERT - Takes(s): 200.0, Count: 58387, OPS: 292.0, Avg(us): 66214, Min(us): 665, Max(us): 4780031, 99th(us): 1673215, 99.9th(us): 3414015, 99.99th(us): 4411391
SCAN   - Takes(s): 200.0, Count: 1107805, OPS: 5539.8, Avg(us): 7988, Min(us): 732, Max(us): 55903, 99th(us): 22687, 99.9th(us): 50783, 99.99th(us): 54879

# workloadf, 64 threads, 2 processes
READ   - Takes(s): 200.0, Count: 518386, OPS: 2592.1, Avg(us): 15681, Min(us): 1088, Max(us): 147711, 99th(us): 76031, 99.9th(us): 112703, 99.99th(us): 138367
READ_MODIFY_WRITE - Takes(s): 200.0, Count: 258431, OPS: 1292.4, Avg(us): 33653, Min(us): 3382, Max(us): 238719, 99th(us): 121599, 99.9th(us): 189183, 99.99th(us): 227455
UPDATE - Takes(s): 200.0, Count: 258460, OPS: 1292.5, Avg(us): 17978, Min(us): 735, Max(us): 181375, 99th(us): 81855, 99.9th(us): 131967, 99.99th(us): 171519
READ   - Takes(s): 200.0, Count: 513678, OPS: 2568.7, Avg(us): 15843, Min(us): 1050, Max(us): 145919, 99th(us): 76351, 99.9th(us): 112639, 99.99th(us): 137599
READ_MODIFY_WRITE - Takes(s): 199.9, Count: 256351, OPS: 1282.1, Avg(us): 33917, Min(us): 3640, Max(us): 234367, 99th(us): 122559, 99.9th(us): 188031, 99.99th(us): 225663
UPDATE - Takes(s): 199.9, Count: 256376, OPS: 1282.2, Avg(us): 18088, Min(us): 773, Max(us): 173439, 99th(us): 82431, 99.9th(us): 129471, 99.99th(us): 165759

.