Skip to content

Instantly share code, notes, and snippets.

@siddontang
Last active May 3, 2018 05:44
Show Gist options
  • Save siddontang/9dc16ece06abda4bcfc51e1598dffae9 to your computer and use it in GitHub Desktop.
Save siddontang/9dc16ece06abda4bcfc51e1598dffae9 to your computer and use it in GitHub Desktop.

One FoundationDB, One TiKV.

recordcount=1000000
operationcount=1000000
workload=core

fieldcount=1
fieldlength=16

requestdistribution=uniform
threads=10

Load

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 24828.4 4002 7000 9000
Raw TiKV 72523.8 1363 3000 4000
Transaction TiKV 26961.1 3695 7000 8000

Update

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 5430.2 708 3000 6000
Raw TiKV 21361.5 461 1000 2000
Transaction TiKV 7080.8 1265 2000 4000

99% Read, 1% Insert

For Read

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 19315.9 397 1000 2000
Raw TiKV 40788.9 213 1000 1000
Transaction TiKV 18562.4 420 1000 2000

For Insert

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 2139.0 1031 2000 3000
Raw TiKV 4522.8 235 1000 1000
Transaction TiKV 2063.8 1013 2000 4000

99% Read, 1% Insert, 100 Threads

For Read

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 36904.7 2345 4000 6000
Raw TiKV 77053.9 1152 3000 5000
Transaction TiKV 56546.2 1400 4000 5000

For Insert

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 4120.4 3081 5000 7000
Raw TiKV 8534.5 1190 3000 5000
Transaction TiKV 6293.6 3188 7000 8000

Read

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 28010.3 353 1000 2000
Raw TiKV 44989.2 218 1000 1000
Transaction TiKV 24084.1 410 1000 2000

Scan 100 keys

Type QPS Avg(us) 95th(us) 99th(us)
FoundationDB 1960.8 327 9000 10000
Raw TiKV 3639.9 2733 5000 6000
Transaction TiKV 1873.4 5327 10000 11000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment