写数据到tidb时Prewrite_time不稳定

🪐 TiDB 技术问题
1

【 TiDB 版本】4.0.16
【遇到的问题】写数据到tidb时Prewrite_time不稳定
【问题现象及影响】
往tidb 写批量写数据（chunk_size=10000），观察慢日志，发现Prewrite_time不稳定，时快时慢。请问是什么原因导致？
>
> # Prewrite_time: 1.151691971 Commit_time: 0.299480126 Get_commit_ts_time: 0.000312007 Write_keys: 100000 Write_size: 6001301 Prewrite_region: 1
> # Prewrite_time: 1.119349541 Commit_time: 0.027392476 Get_commit_ts_time: 0.000294896 Write_keys: 100000 Write_size: 5993643 Prewrite_region: 1
> # Prewrite_time: 0.485949683 Commit_time: 0.015939032 Get_commit_ts_time: 0.000256948 Write_keys: 100000 Write_size: 5969311 Prewrite_region: 1
> # Prewrite_time: 1.6008240009999999 Commit_time: 0.022140148 Get_commit_ts_time: 0.000254212 Write_keys: 100000 Write_size: 5986598 Prewrite_region: 1
> # Prewrite_time: 0.370689428 Commit_time: 0.027676152 Get_commit_ts_time: 0.000381435 Write_keys: 100000 Write_size: 6006616 Prewrite_region: 1
>
> ^R
> # Prewrite_time: 21.503526186 Commit_time: 0.022719921 Get_commit_ts_time: 0.000354369 Write_keys: 100000 Write_size: 6003669 Prewrite_region: 1
> # Prewrite_time: 2.346087306 Commit_time: 0.024247994 Get_commit_ts_time: 0.000427788 Write_keys: 100000 Write_size: 5989099 Prewrite_region: 1
> # Prewrite_time: 2.370157601 Commit_time: 0.024713375 Get_commit_ts_time: 0.000227581 Write_keys: 100000 Write_size: 5989875 Prewrite_region: 1
>
> # Prewrite_time: 0.332578451 Commit_time: 0.017115904 Get_commit_ts_time: 0.000244338 Write_keys: 100000 Write_size: 5998061 Prewrite_region: 1
>
>
>
> # Prewrite_time: 0.358388923 Commit_time: 0.02173293 Get_commit_ts_time: 0.00030626 Write_keys: 100000 Write_size: 5994058 Prewrite_region: 1
> # Prewrite_time: 0.33605859 Commit_time: 0.029132818 Get_commit_ts_time: 0.000434069 Write_keys: 100000 Write_size: 6004141 Prewrite_region: 1
> # Prewrite_time: 1.191673665 Commit_time: 0.015652481 Get_commit_ts_time: 0.000279001 Write_keys: 100000 Write_size: 5997539 Prewrite_region: 1

2

优先找一下是否有热点存在…

3

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。