To source a 1MB sql file, TiDB v7.4/v7.5 is slower than MySQL v8.1/v8.2
Open
compatibility-mysql80
severity/moderate
sig/transaction
type/bug
type/compatibility
- 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)
Import TiDB with a 1MB sql file. (<24s)
Import MySQL 8.1 with the same 1MB sql file. (<1s)
Compare the time cosuming.
### 2. What did you expect to see? (Required)
Shouldn't be slower that much?
### 3. What did you see instead (Required)
Slightly slower than MySQL?
### 4. What is your TiDB version? (Required)
| Release Version: v7.4.0
Edition: Community
Git Commit Hash: 38cb4f3312be9199a983c0ef282d2ea2e28a7824
Git Branch: heads/refs/tags/v7.4.0
UTC Build Time: 2023-10-10 14:10:02
GoVersion: go1.21.0
Race Enabled: false
Check Table Before Drop: false
Store: tikv |
Contributor guide
Assessment
This issue has not been assessed yet.