TiDB Cloud Performance Reference

This document provides Sysbench performance test results of different TiDB cluster scales, which can be used as a reference when you determine the cluster size.

Here is an example of a Sysbench configuration file:

mysql-host={TIDB_HOST} mysql-port=4000 mysql-user=root mysql-password=password mysql-db=sbtest time=1200 threads={100} report-interval=10 db-driver=mysql mysql-ignore-errors=1062,2013,8028,9002,9007 auto-inc=false

In this document, the transaction models Read Only, Read Write, and Write Only represent read workloads, mixed workloads, and write workloads.

4 vCPU performance

Test scales:

  • TiDB (4 vCPU, 16 GiB) * 1; TiKV (4 vCPU, 16 GiB) * 3
  • TiDB (4 vCPU, 16 GiB) * 2; TiKV (4 vCPU, 16 GiB) * 3

Test results:

TiDB (4 vCPU, 16 GiB) * 1; TiKV (4 vCPU, 16 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only358,064.89504.0669.43104.84
Read Write256,747.60337.3874.10102.97
Write Only908,805.211,467.5361.3299.33

TiDB (4 vCPU, 16 GiB) * 2; TiKV (4 vCPU, 16 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only6516,805.761,050.3661.8895.81
Read Write4512,940.36647.0269.5599.33
Write Only20019,265.933,210.9962.28102.97

8 vCPU performance

Test scales:

  • TiDB (8 vCPU, 16 GiB) * 2; TiKV (8 vCPU, 32 GiB) * 3
  • TiDB (8 vCPU, 16 GiB) * 4; TiKV (8 vCPU, 32 GiB) * 3
  • TiDB (8 vCPU, 16 GiB) * 4; TiKV (8 vCPU, 32 GiB) * 6
  • TiDB (8 vCPU, 16 GiB) * 6; TiKV (8 vCPU, 32 GiB) * 9
  • TiDB (8 vCPU, 16 GiB) * 9; TiKV (8 vCPU, 32 GiB) * 6
  • TiDB (8 vCPU, 16 GiB) * 12; TiKV (8 vCPU, 32 GiB) * 9

Test results:

TiDB (8 vCPU, 16 GiB) * 2; TiKV (8 vCPU, 32 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only15037,863.642,366.4863.3899.33
Read Write10030,218.421,510.9266.1894.10
Write Only35030,763.725,127.2968.26104.84

TiDB (8 vCPU, 16 GiB) * 4; TiKV (8 vCPU, 32 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only30074,190.404,636.9064.69104.84
Read Write20053,351.842,667.5974.9797.55
Write Only40036,036.405,926.6667.4995.81

TiDB (8 vCPU, 16 GiB) * 4; TiKV (8 vCPU, 32 GiB) * 6

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only30075,713.044,732.0663.39102.97
Read Write20062,640.623,132.0363.8595.81
Write Only75073,840.2212,306.7060.93104.84

TiDB (8 vCPU, 16 GiB) * 6; TiKV (8 vCPU, 32 GiB) * 9

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only450113,407.947,088.0063.48104.84
Read Write30092,387.314,619.3764.9399.33
Write Only1100112,631.7218,771.9558.5999.33

TiDB (8 vCPU, 16 GiB) * 9; TiKV (8 vCPU, 32 GiB) * 6

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only650168,486.6510,530.4261.72101.13
Read Write400106,853.635,342.6874.86101.13
Write Only95088,461.2014,743.5364.42102.97

TiDB (8 vCPU, 16 GiB) * 12; TiKV (8 vCPU, 32 GiB) * 9

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only800211,882.7713,242.6760.40101.13
Read Write550139,393.466,969.6778.90104.84
Write Only1500139,330.1423,221.6964.5899.33

16 vCPU performance

Test scales:

  • TiDB (16 vCPU, 32 GiB) * 1; TiKV (16 vCPU, 64 GiB) * 3
  • TiDB (16 vCPU, 32 GiB) * 2; TiKV (16 vCPU, 64 GiB) * 3

Test results:

TiDB (16 vCPU, 32 GiB) * 1; TiKV (16 vCPU, 64 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only12537448.412340.5353.4089.16
Read Write10028903.991445.2069.19104.84
Write Only40040878.686813.1158.71101.13

TiDB (16 vCPU, 32 GiB) * 2; TiKV (16 vCPU, 64 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only30077238.304827.3962.14102.97
Read Write20058241.152912.0668.6797.55
Write Only70068829.8911471.6561.01101.13

32 vCPU performance

Test scales:

  • TiDB (32 vCPU, 64 GiB) * 1; TiKV (32 vCPU, 128 GiB) * 3
  • TiDB (32 vCPU, 64 GiB) * 2; TiKV (32 vCPU, 128 GiB) * 3

Test results:

TiDB (32 vCPU, 64 GiB) * 1; TiKV (32 vCPU, 128 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only30083941.16524657.2087.6
Read Write25071290.31356570.10105.0
Write Only70072199.561203358.20101.0

TiDB (32 vCPU, 64 GiB) * 2; TiKV (32 vCPU, 128 GiB) * 3

Transaction modelThreadsQPSTPSAverage transaction latency (ms)P95 transaction latency (ms)
Read Only650163101.681019463.899.3
Read Write450123152.74615873.1101
Write Only1200112333.161872264.1101

Was this page helpful?