Compared with v7.5.1, v8.1.0 has a 7.3% performance regression in oltp_point_select on Kylin Linux
- 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

v7.5.1

v8.1.0

### 4. What is your TiDB version? (Required)
8.1.0 commit d80e436e3c06004fc03ae79f896e89a2f7e2e2f6
Contributor guide
Assessment
This issue has not been assessed yet.