YCSB numbers

Performance numbers when running go-ycsb. Tested with mvSQLite v0.1.18-1.

Benchmark setup

• FoundationDB: 3 x i4i.large, instance store, double replication, ssd-redwood-1-experimental storage engine, 2 processes per machine
• mvstore: 1 x c5.2xlarge, 3 processes
• go-ycsb: 1 x c6i.2xlarge

Database page size is configured to 16 KiB.

Small table (1 million rows)

go-ycsb parameters

"sqlite.db"="ycsb"
"threadcount"="64"
"sqlite.journalmode"="delete"
"sqlite.cache"="private"
"operationcount"="10000000"
"sqlite.maxopenconns"="1000"
"sqlite.maxidleconns"="1000"
"sqlite.optimistic"="true"
"recordcount"="1000000"

Results

# workloada, 64 threads
READ   - Takes(s): 200.0, Count: 306385, OPS: 1532.1, Avg(us): 10031, Min(us): 1186, Max(us): 80383, 99th(us): 38303, 99.9th(us): 57407, 99.99th(us): 72703
UPDATE - Takes(s): 200.0, Count: 306108, OPS: 1530.8, Avg(us): 31441, Min(us): 1354, Max(us): 137983, 99th(us): 92607, 99.9th(us): 113663, 99.99th(us): 134399

# workloadb, 64 threads
READ   - Takes(s): 200.0, Count: 1683476, OPS: 8418.0, Avg(us): 6572, Min(us): 1160, Max(us): 51551, 99th(us): 14023, 99.9th(us): 42911, 99.99th(us): 50495
UPDATE - Takes(s): 200.0, Count: 88714, OPS: 443.7, Avg(us): 19218, Min(us): 1548, Max(us): 90495, 99th(us): 35551, 99.9th(us): 66687, 99.99th(us): 75775

# workloadc, 64 threads
READ   - Takes(s): 200.0, Count: 2248368, OPS: 11242.6, Avg(us): 5680, Min(us): 1005, Max(us): 14839, 99th(us): 10039, 99.9th(us): 12495, 99.99th(us): 14263

# workloadd, 64 threads
INSERT - Takes(s): 200.0, Count: 89837, OPS: 449.3, Avg(us): 40776, Min(us): 787, Max(us): 9003007, 99th(us): 1404927, 99.9th(us): 5206015, 99.99th(us): 7938047
READ   - Takes(s): 200.0, Count: 1710128, OPS: 8551.2, Avg(us): 5208, Min(us): 759, Max(us): 50207, 99th(us): 13007, 99.9th(us): 46207, 99.99th(us): 49631

# workloade, 64 threads
INSERT - Takes(s): 200.0, Count: 109378, OPS: 547.0, Avg(us): 3540, Min(us): 886, Max(us): 1548287, 99th(us): 7335, 99.9th(us): 16375, 99.99th(us): 1212415
SCAN   - Takes(s): 200.0, Count: 2078175, OPS: 10391.5, Avg(us): 5952, Min(us): 989, Max(us): 21199, 99th(us): 10351, 99.9th(us): 13207, 99.99th(us): 16959

# workloadf, 64 threads
READ   - Takes(s): 200.0, Count: 601983, OPS: 3010.1, Avg(us): 9273, Min(us): 1060, Max(us): 67967, 99th(us): 32015, 99.9th(us): 52991, 99.99th(us): 64703
READ_MODIFY_WRITE - Takes(s): 200.0, Count: 301113, OPS: 1505.8, Avg(us): 33129, Min(us): 2674, Max(us): 125631, 99th(us): 91455, 99.9th(us): 116735, 99.99th(us): 124031
UPDATE - Takes(s): 200.0, Count: 301235, OPS: 1506.4, Avg(us): 23870, Min(us): 1263, Max(us): 118527, 99th(us): 81343, 99.9th(us): 107071, 99.99th(us): 116415