TiDBTiDB Docs Dash 2024

Jan 9 - Jan 12 (UTC)
Join us to improve docs and win a prize!
Sign InTry Free

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.

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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 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 latency (ms)P95 latency (ms)
Read Only30077238.304827.3962.14102.97
Read Write20058241.152912.0668.6797.55
Write Only70068829.8911471.6561.01101.13

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.