This repository was archived by the owner on Jul 24, 2024. It is now read-only.
This repository was archived by the owner on Jul 24, 2024. It is now read-only.
br-v4.0.4 total size is error #470
Description
测试集群 tidb 版本 v4.0.4 br 版本 v4.0.4
使用 br v4.0.4 备份发现最后输出的 total size(MB) 总大小貌似被翻倍了，用 br v4.0.2 版本测试输出是正常的~
tidb 库中： sbtest2 = 1446.57746029 mb
mysql> admin checksum table sbtest2;
+---------+------------+----------------------+-----------+-------------+
| Db_name | Table_name | Checksum_crc64_xor | Total_kvs | Total_bytes |
+---------+------------+----------------------+-----------+-------------+
| brtest | sbtest2 | 17672279701300674031 | 15322020 | 1516846407 |
+---------+------------+----------------------+-----------+-------------+
1 row in set (1.06 sec)
mysql> select 1516846407/1024/1024 ;
+----------------------+
| 1516846407/1024/1024 |
+----------------------+
| 1446.57746029 |
+----------------------+
1 row in set (0.00 sec)
br v4.0.2 -- total size(MB): 1446.58
[root@test4 bin]# ./br backup table \
> --db brtest \
> --table sbtest2 \
> -s local:///data2/bak/tool/tidb-toolkit-v4.0.2-linux-amd64/bin/br_backup/ \
> --pd localhost:4789 \
> --log-file backup_table.log
Detial BR log in backup_table.log
Table backup <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 100.00%
Checksum <-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 100.00%
[2020/08/25 01:48:34.252 +08:00] [INFO] [collector.go:58] ["Table backup Success summary: total backup ranges: 3, total success: 3, total failed: 0, total take(s): 18.08, total kv: 15322020, total size(MB): 1446.58, avg speed(MB/s): 79.99"] ["backup checksum"=1.983435083s] ["backup fast checksum"=348.139µs] ["backup total regions"=25]
br 4.0.4 -- total size(MB): 2893.15
[root@test4 bin]# ./br backup table --db brtest --table sbtest2 -s local:///data2/bak/tool/tidb-toolkit-v4.0.4-linux-amd64/bin/br_backup/ --pd localhost:4789 --compression "zstd" --log-file backup_table.log
Detial BR log in backup_table.log
Table backup <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 100.00%
Checksum <-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 100.00%
[2020/08/25 01:30:52.787 +08:00] [INFO] [collector.go:60] ["Table backup Success summary: total backup ranges: 3, total success: 3, total failed: 0, total take(s): 13.41, total kv: 30644040, total size(MB): 2893.15, avg speed(MB/s): 215.79"] ["backup checksum"=1.922208431s] ["backup fast checksum"=398.705µs] ["backup total regions"=25] [BackupTS=418982195992723458] [Size=622484828]