Doc Menu
Important

You are viewing the documentation of an older version of the TiDB database (TiDB v2.1).

It is recommended that you use the latest stable version of the TiDB database.

TiDB TPC-H 50G Performance Test Report V2.1

Test purpose

This test aims to compare the performances of TiDB 2.0 and TiDB 2.1 in the OLAP scenario.

Note:

Different test environments might lead to different test results.

Test environment

Machine information

System information:

Machine IPOperation systemKernel versionFile system type
10.0.1.4CentOS 7.5.1804 64bit3.10.0-862.3.3.el7.x86_64ext4
10.0.1.5CentOS 7.5.1804 64bit3.10.0-862.3.3.el7.x86_64ext4
10.0.1.6CentOS 7.5.1804 64bit3.10.0-862.3.3.el7.x86_64ext4
10.0.1.7CentOS 7.5.1804 64bit3.10.0-862.3.3.el7.x86_64ext4
10.0.1.8CentOS 7.5.1804 64bit3.10.0-862.3.3.el7.x86_64ext4
10.0.1.9CentOS 7.5.1804 64bit3.10.0-862.3.3.el7.x86_64ext4

Hardware information:

Type10.0.1.410.0.1.5, 10.0.1.6, 10.0.1.7, 10.0.1.8, 10.0.1.9
CPU16 vCPUs, Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz8 vCPUs, Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz
Memory110G55G
Disk221G SSD111G SSD
Network card10 Gigabit Ethernet, 10000Mb/s10 Gigabit Ethernet, 10000Mb/s

TPC-H

tidb-bench/tpch

Cluster topology

Machine IPDeployment Instance
10.0.1.5TiKV * 1
10.0.1.6TiKV * 1
10.0.1.7TiKV * 1
10.0.1.8TiKV * 1
10.0.1.9TiKV * 1
10.0.1.4PD * 1
10.0.1.4TiDB * 1

TiDB version information

TiDB 2.0:

ComponentVersionCommit Hash
TiDBv2.0.729ec059cb3b7d14b6f52c2f219f94a89570162bc
TiKVv2.0.7d0b8cd7c7f62f06e7ef456837bd32a47da1ca4cd
PDv2.0.5b64716707b7279a4ae822be767085ff17b5f3fea

TiDB 2.1:

ComponentVersionCommit Hash
TiDBv2.1.0-rc.216864f95b47f859ed6104555ccff0387abdc2429
TiKVv2.1.0-rc.28458ce53ebbd434c48baac6373fe0f0a43a54005
PDv2.1.0-rc.255db505e8f35e8ab4e00efd202beb27a8ecc40fb

Test result

Query IDTiDB 2.0TiDB 2.1
1121.550595999s91.4755480289s
253.0638680458s23.1186130047s
375.7236940861s61.790802002s
430.2647120953s26.3483440876s
651.4850790501s34.6432199478s
7216.787364006s94.9856910706s
8188.717588902s181.852752209s
9546.438174009s414.462754965s
10109.978317022s37.0369961262s
1142.9398438931s37.6951580048s
1260.455039978s40.2236878872s
13230.278712988s70.2887151241s
1461.2673521042s35.8372960091s
1630.2539310455s18.5897550583s
173200.70173788s263.095014811s
181035.59847498s296.360667944s
1954.3732938766s40.4523630142s
20105.094577074s53.2429068089s
21389.883709908s361.034544945s
2264.0494630337s65.7153418064s

TPC-H Query Result

It should be noted that:

  • In the diagram above, the red bars represent the query results of Release 2.1 and the blue bars represent the query results of Release 2.0. The y-axis represents the processing time of queries in seconds, the shorter the faster.
  • The result of Query 15 is not displayed because VIEW is currently not supported in either TiDB 2.1 or 2.0.
  • The result of Query 5 is not displayed because no result is returned during a long period of time caused by the Join Order issue.