tidb 4.0写入异常慢，超过500ms,没有开 binlog

[netdata]

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。

• 【TiDB 版本】：4.0
• 【问题描述】：tidb 4.0写入异常慢，超过500ms,没有开 binlog

tidb 4.0写入异常慢，超过500ms,没

上传中：screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-17-14_52_10.png…

有开 binlog

[yilong (yi888long)]

1. 是一直写入慢吗？麻烦先确认一个时间段
2. 麻烦上传此时间段范围的 over-view，trouble-shooting 监控图，多谢。

[netdata]

6.16日20:40-6.16.21:00

[netdata]

screencapture-10-10-28-210-3000-d-000000012-tidb-mqdw-tidb-summary-2020-06-17-14_45_56.zip (1.4 MB)

[netdata]

图片上传失败了，打了一个压缩包

[yilong (yi888long)]

您好，您上传的是 tidb-summary，麻烦上传上面帖子的监控，多谢。

[netdata]

上传中：screencapture-10-10-28-210-3000-d-Lg4wiEkZz-tidb-mqdw-tikv-trouble-shooting-2020-06-17-16_26_56.png…

[netdata]

图片太大了，有没有其他 办法 上传

[netdata]

screencapture-10-10-28-210-3000-d-Lg4wiEkZz-tidb-mqdw-tikv-trouble-shooting-2020-06-17-16_26_56.z01 (3 MB) screencapture-10-10-28-210-3000-d-Lg4wiEkZz-tidb-mqdw-tikv-trouble-shooting-2020-06-17-16_26_56.z01 (3 MB)

[netdata]

拆分成两个压缩包了

[yilong (yi888long)]

压缩文件已经损坏.

2. 可以在监控界面，先按d ，shift+e 打开所有监控，再使用类似这种工具来截长图，https://chrome.google.com/webstore/detail/full-page-screen-capture/fdpohaocaechififmbbbbbknoalclacl

[netdata]

@netdata

MB

screencapture-10-10-28-210-3000-d-Lg4wiEkZz-tidb-mqdw-tikv-trouble-shooting-2020-06-17-16_26_56.zip (2.8 MB) screencapture-10-10-28-210-3000-d-Lg4wiEkZz-tidb-mqdw-tikv-trouble-shooting-2020-06-17-16_26_56.z01 (3 MB)

[netdata]

重新上传了

[yilong (yi888long)]

1. 查看监控commit log 206服务器很慢
   

2. 请问 盘 是 ssd 吗？

3. 麻烦上传 这个时间段 detal-tikv 的监控

[netdata]

是ssd

[netdata]

screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00.z01 (2 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00.z02 (2 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00.z03 (2 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00.zip (1.5 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00-2.z01 (2 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00-2.z02 (2 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00-2.z03 (2 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00-2.z04 (2 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-18-18_00_00-2.zip (64.2 KB)

[yilong (yi888long)]

抱歉，压缩文件解压时还是报错，麻烦您看下私信，多谢。

[netdata]

screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-19-14_24_04.z01 (3 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-19-14_24_04.z02 (3 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-19-14_24_04.zip (1.8 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-19-14_24_04-2.z01 (3 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-19-14_24_04-2.z02 (3 MB) screencapture-10-10-28-210-3000-d-RDVQiEzZz-tidb-mqdw-tikv-details-2020-06-19-14_24_04-2.zip (2.4 MB)

[netdata]

已经重新上传了

[zhenjiaogao]

您好，上传的文件依然解压失败，无法查看，能否上传至您的网盘，并提供提取码，这里再看下相关的监控信息。

感谢~~~