Doc Menu

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.
Edit this page
What’s on this page