pingcap / pingcap/tidb

Compared with v7.5.1, v8.1.0 has a 7.3% performance regression in oltp_point_select on Kylin Linux

Open
#53,404 3 comments 0 reactions 1 assignee Claimed by @hawkingrei View on GitHub
affects-8.1 affects-8.2 affects-8.5 component/DXF severity/major type/bug type/performance type/regression
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

1. deploy a tidb cluster on Kylin Linux Advanced Server V10 (Sword) with aarch64
2. run sysbench oltp_point_select with v7.5.1 and v8.1.0

OS & CPU info
```
[root@172 ~]# uname -a
Linux 172.16.6.70 4.19.90-25.22.v2101.ky10.aarch64 #1 SMP Thu Nov 24 18:18:43 CST 2022 aarch64 aarch64 aarch64 GNU/Linux
[root@172 ~]# lscpu
架构: aarch64
CPU 运行模式: 64-bit
字节序: Little Endian
CPU: 64
在线 CPU 列表: 0-63
每个核的线程数: 1
每个座的核数: 32
座: 2
NUMA 节点: 2
厂商 ID: HiSilicon
型号: 0
型号名称: Kunpeng-920
步进: 0x1
CPU 最大 MHz: 2600.0000
CPU 最小 MHz: 200.0000
BogoMIPS: 200.00
L1d 缓存: 4 MiB
L1i 缓存: 4 MiB
L2 缓存: 32 MiB
L3 缓存: 64 MiB
NUMA 节点0 CPU: 0-31
NUMA 节点1 CPU: 32-63
Vulnerability Itlb multihit: Not affected
Vulnerability L1tf: Not affected
Vulnerability Mds: Not affected
Vulnerability Meltdown: Not affected
Vulnerability Mmio stale data: Not affected
Vulnerability Spec store bypass: Not affected
Vulnerability Spectre v1: Mitigation; __user pointer sanitization
Vulnerability Spectre v2: Not affected
Vulnerability Srbds: Not affected
Vulnerability Tsx async abort: Not affected
标记: fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fp
hp asimdhp cpuid asimdrdm jscvt fcma dcpop asimddp as
imdfhm
```
### 2. What did you expect to see? (Required)
No performance regression
### 3. What did you see instead (Required)
No performance regression on CentOS Linux 7 (Core) with Intel(R) Xeon(R) Silver 4214R CPU @ 2.40GHz,
but 7.3% performance regression in oltp_point_select on Kylin Linux with aarch64
v7.5.1 QPS 175680
v8.1.0 QPS 162811

![image](https://github.com/pingcap/tidb/assets/84501897/e44b0031-bec8-41d5-ab73-975c462beba8)

v7.5.1
![image](https://github.com/pingcap/tidb/assets/84501897/106c4a13-eacf-4437-aae4-0959acf1947b)

v8.1.0
![image](https://github.com/pingcap/tidb/assets/84501897/3b92b532-00bc-4c92-a597-c1976fca0f8b)

### 4. What is your TiDB version? (Required)

8.1.0 commit d80e436e3c06004fc03ae79f896e89a2f7e2e2f6

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.