Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 节点只有一个磁盘io打满
Question: Only one node’s disk IO is fully utilized.
Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 节点只有一个磁盘io打满
Question: Only one node’s disk IO is fully utilized.
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.
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.
It should be a hotspot issue. Search in the forum for how to handle hotspot issues, and there will be solutions.
What is the version of TiDB?
How do you configure it to scatter regions to avoid hotspot issues?
Check if the hotspot regions of this table are concentrated on this table.
It looks like there are quite a few keys. Are there too few TiKV nodes? Have you deleted the data from the compression layer?
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.