Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: BR 备份性能
BR: 5.4.2
TiDB cluster version: 5.4.2
Node information:
Machine A: 10 Gigabit network, one PD, TiDB, TiKV
Machine B: 10 Gigabit network, one PD, TiDB, TiKV
Machine C: 10 Gigabit network, one PD, TiDB, TiKV
Machine D: 10 Gigabit network, installed with a MinIO service.
During testing, it was found that the speed printed by BR and the data volume divided by the total time have a significant discrepancy. How can this be explained?
I manually calculated and found that the difference is not significant.
Data volume: 4.072TB
Speed: 325MB/s
Time: 3h28min
Calculation time: (4.072x1024x1024)/325=13137s
Printed time: (3x60+28)x60=12480s
The printed time is 11 minutes less than the calculated time. Compared to 3.5 hours, I think the difference is not significant.
PS: Using the decimal system results in an even smaller difference (I thought of this because of the different systems when buying a USB drive).
Calculation time: (4.072x1000x1000)/325=12529s
This way, the time difference is 49s, which is almost the same. 
There is also a compression process after the backup.
Can it be understood this way?
4.072T is the data size before compression, and BR is based on this.
backup-data-size(after-compressed) is the size after compression.
What does Size=1731651606559 mean?
This confirms the use of the decimal system (base-1000) rather than the binary system (base-1024). It’s clear that this is the compressed size, backup-data-size.
Is compression necessary during BR backup? Is there a way to disable compression?
Is BR backup compressed by default? It seems like I haven’t seen any related parameters.
It should be the default, right? Physical backups are not compressed, what business scenarios is this for?
The size in the backup output log is the actual size of the backup archive on the disk after compression.
What is the range of values for this compression level?
You can learn about zstd compression.
This topic will be automatically closed 60 days after the last reply. No new replies are allowed.
|
username: Hacker_wV92qfW3
|
username: 
|
username: 
|
username: 
|
username: 
|
username: