TiDB-Backend导入数据时restore file步骤很慢

🪐 TiDB 技术问题 备份&数据迁移
1
  • 【TiDB 版本】：v3.0.12
  • 【问题描述】： [2020/04/22 19:38:30.620 +08:00] [INFO] [restore.go:492] [progress] [files=“1/5 (20.0%)”] [tables=“0/5 (0.0%)”] [speed(MiB/s)=3.3478051623510354] [state=writing] [remaining=40m0s]
2

您好：

    1. 能否上传下日志，我看看是所有时间都是这么慢吗？ 
    2. 您的硬件是ssd和万兆网吗？ 
    3. 麻烦上传over-view监控信息
3

1、所有时间都差不多 [2020/04/22 20:45:19.977 +08:00] [INFO] [restore.go:492] [progress] [files=“0/11 (0.0%)”] [tables=“0/5 (0.0%)”] [speed(MiB/s)=3.232499152631922] [state=writing] [] [2020/04/22 20:50:19.977 +08:00] [INFO] [restore.go:492] [progress] [files=“0/11 (0.0%)”] [tables=“0/5 (0.0%)”] [speed(MiB/s)=3.6218136695673] [state=writing] [] [2020/04/22 20:55:19.977 +08:00] [INFO] [restore.go:492] [progress] [files=“0/11 (0.0%)”] [tables=“0/5 (0.0%)”] [speed(MiB/s)=3.6696877818230713] [state=writing] [] [2020/04/22 21:00:19.977 +08:00] [INFO] [restore.go:492] [progress] [files=“0/11 (0.0%)”] [tables=“0/5 (0.0%)”] [speed(MiB/s)=3.5591414904148717] [state=writing] []

1、是ssd和万兆网

2、over-view监控信息需要哪一部分的？

4

您好：

    从您的描述来看，应该是配置满足要求，但是导入慢，可能都需要看一下，麻烦取一下over-view,tidb, detail-tikv的监控，多谢

(1)、chrome 安装这个插件https://chrome.google.com/webstore/detail/full-page-screen-capture/fdpohaocaechififmbbbbbknoalclacl

(2)、鼠标焦点置于 Dashboard 上，按 ?可显示所有快捷键，先按 d 再按 E 可将所有 Rows 的 Panels 打开，需等待一段时间待页面加载完成。

(3)、使用这个 full-page-screen-capture 插件进行截屏保存