Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 节点只有一个磁盘io打满
|
username: Hacker_6ASfgBFe
Question: Only one node’s disk IO is fully utilized.
|
username: Hacker_6ASfgBFe
At this time, I checked the slow log and found a delete operation on the partitioned table, with the slowest execution taking more than 100 seconds.
|
username: Take a look at the traffic visualization on the dashboard to see which region has hotspots during this period.
Don’t choose 1 day.
Use the box selection feature to select the time point you are interested in.
Is it possible to check through other monitoring information? This thing is a bit complicated and hard to understand.
|
username: It should be a hotspot issue. Search in the forum for how to handle hotspot issues, and there will be solutions.
|
username: - Optimization of the delete operation itself, such as indexing and deletion methods; 删除数据 | PingCAP 文档中心
- Optimization of delete time: whether it can be adjusted;
- Strategy adjustment: TTL feature
|
username: What is the version of TiDB?
How do you configure it to scatter regions to avoid hotspot issues?
|
username: 
|
username: 
|
username: 
|
username: Check if the hotspot regions of this table are concentrated on this table.
|
username: It looks like there are quite a few keys. Are there too few TiKV nodes? Have you deleted the data from the compression layer?
|
username: 
|
username: 
|
username: Is the entire cluster on a single node? Is it using a mechanical hard drive? If you are deleting a large amount of data and it is a mechanical hard drive, it should be normal.