Doc Menu

TiDB TPC-C Performance Test Report -- v3.0 vs. v2.1

Test purpose

This test aims to compare the TPC-C performance of TiDB 3.0 and TiDB 2.1.

Test version, time, and place

TiDB version: v3.0.0 vs. v2.1.13

Time: June, 2019

Place: Beijing

Test environment

IDC machine:

TypeName
OSLinux (CentOS 7.3.1611)
CPU40 vCPUs, Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
RAM128GB
DISK1.5TB SSD * 2

This test uses the open-source BenchmarkSQL 5.0 as the TPC-C testing tool and adds the support for the MySQL protocol. You can download the testing program by using the following command:

git clone -b 5.0-mysql-support-opt https://github.com/pingcap/benchmarksql.git

Test plan

Use BenchmarkSQL to load the data of 1000 warehouses into the TiDB cluster. By using HAProxy, send concurrent requests to the cluster at an incremental number. A single concurrent test lasts 10 minutes.

TiDB version information

v3.0.0

ComponentGitHash
TiDB46c38e15eba43346fb3001280c5034385171ee20
TiKVa467f410d235fa9c5b3c355e3b620f81d3ac0e0c
PD70aaa5eee830e21068f1ba2d4c9bae59153e5ca3

v2.1.13

ComponentGitHash
TiDB6b5b1a6802f9b8f5a22d8aab24ac80729331e1bc
TiKVb3cf3c8d642534ea6fa93d475a46da285cc6acbf
PD886362ebfb26ef0834935afc57bcee8a39c88e54

TiDB parameter configuration

[log]
level = "error"
[performance]
max-procs = 20
[prepared_plan_cache]
enabled = true

TiKV parameter configuration

The default TiKV configuration is used in both v2.1 and v3.0.

Cluster topology

Machine IPDeployment instance
172.16.4.752*TiDB 2*TiKV 1*pd
172.16.4.762*TiDB 2*TiKV 1*pd
172.16.4.772*TiDB 2*TiKV 1*pd

Test result

VersionThreadstpmC
v3.012844068.55
v3.025647094.06
v3.051248808.65
v2.112810641.71
v2.125610861.62
v2.151210965.39

point select

According to the testing statistics, the performance of TiDB 3.0 has increased by 450% than that of TiDB 2.1.