YCSB numbers

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

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: 391080, OPS: 1955.5, Avg(us): 9524, Min(us): 1098, Max(us): 67839, 99th(us): 40191, 99.9th(us): 60223, 99.99th(us): 65727
UPDATE - Takes(s): 200.0, Count: 390119, OPS: 1950.8, Avg(us): 23190, Min(us): 1081, Max(us): 108799, 99th(us): 76671, 99.9th(us): 89791, 99.99th(us): 102527

# workloadb, 64 threads
READ   - Takes(s): 200.0, Count: 1643469, OPS: 8217.7, Avg(us): 6925, Min(us): 875, Max(us): 26959, 99th(us): 14271, 99.9th(us): 19967, 99.99th(us): 23887
UPDATE - Takes(s): 200.0, Count: 86448, OPS: 432.3, Avg(us): 16067, Min(us): 1127, Max(us): 62879, 99th(us): 31311, 99.9th(us): 41279, 99.99th(us): 57503

# 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