tikv的压测性能参考数据

想知道有没有一份tikv的ycsb压测数据可供参考 比如我部署了一个单机版,存储为intel nvme ssd,单线程 50% read 50% update为1.8KQPS左右

k8s 本地 SSD ,Go-YSBC 测试数据仅供参考,请以实际测试结果为准:

1、配置及节点数量

实例 节点数量 配置
TiDB 1 14 vCPU request, 16 vCPU limit
30 GB RAM request, 60 GB RAM limit
50 GB SSD local persistent volume
TiKV 3 14 vCPU request, 16 vCPU limit
30 GB RAM request, 60 GB RAM limit
500 GB SSD local persistent volume
PD 1 4 vCPU request, 8 vCPU limit
5 GB RAM request, 10 GB RAM limit
5 GB SSD local persistent volume

2、测试场景

50% read + 50% update

3、测试结果

1)TiDB

UPDATE - Takes(s): 138.5, Count: 494386, OPS: 3569.3, Avg(us): 14172, Min(us): 3043, Max(us): 1066219, 95th(us): 30000, 99th(us): 204000
READ - Takes(s): 138.5, Count: 499687, OPS: 3607.3, Avg(us): 4303, Min(us): 844, Max(us): 304849, 95th(us): 9000, 99th(us): 86000

2)TiKV - raw key

READ - Takes(s): 48.7, Count: 499598, OPS: 10259.0, Avg(us): 1585, Min(us): 190, Max(us): 4394265, 95th(us): 4000, 99th(us): 10000
UPDATE - Takes(s): 47.0, Count: 500401, OPS: 10648.1, Avg(us): 8150, Min(us): 1041, Max(us): 4441898, 95th(us): 19000, 99th(us): 64000

用的线程数是?

部分配置参考如下:

"operationcount"="1000000"
"recordcount"="10000000"
"threadcount"="100"
"readallfields"="true"
"fieldcount"="20"
"workload"="core"

scan 操作,有参考数据吗? 我这里跑下来,32threads,只有2K QPS,感觉特别慢了点

SCAN - Takes(s): 1660.0, Count: 3603506, OPS: 2170.8, Avg(us): 14719, Min(us): 286, Max(us): 212837, 99th(us): 39000, 99.9th(us): 53000, 99.99th(us): 71000

如下测试数据和结果仅供参考,请以实际的测试结果为准:

1、相同的配置及并发

2、测试场景

95% scan + 5% insert

3、测试数据

1) TiDB
SCAN - Takes(s): 1388.8, Count: 846727, OPS: 609.7, Avg(us): 159016, Min(us): 1650, Max(us): 823742, 95th(us): 314000, 99th(us): 399000
INSERT - Takes(s): 1388.8, Count: 44410, OPS: 32.0, Avg(us): 94828, Min(us): 809, Max(us): 513680, 95th(us): 224000, 99th(us): 300000

2) TiKV - raw
INSERT - Takes(s): 437.3, Count: 49827, OPS: 113.9, Avg(us): 22631, Min(us): 856, Max(us): 2723051, 95th(us): 130000, 99th(us): 377000
SCAN - Takes(s): 437.3, Count: 950173, OPS: 2172.9, Avg(us): 44445, Min(us): 372, Max(us): 8383474, 95th(us): 227000, 99th(us): 475000