What does the value 1 represent in TiDB?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb 这个些数值1代表了啥

| username: ffeenn

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.4.1
[Encountered Problem] Health status is unhealthy
[Reproduction Path]
[Problem Phenomenon and Impact]
How to troubleshoot this type of problem
[Attachment]

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

image
image1145×552 20.1 KB

2
| username: Kongdom | Original post link

1 unit of region

3
| username: ffeenn | Original post link

Does its appearance indicate normalcy or some kind of issue fluctuation?

4
| username: Kongdom | Original post link

The above Region information panel is explained as follows:

  • miss-peer-region-count: The number of Regions missing replicas, which will not always be greater than 0.
  • extra-peer-region-count: The number of Regions with extra replicas, which can occur during scheduling.
  • empty-region-count: The number of empty Regions, generally caused by TRUNCATE TABLE/DROP TABLE statements. If the number is large, consider enabling cross-table Region merge.
  • pending-peer-region-count: The number of Regions with Raft logs lagging behind. A small number of pending peers due to scheduling is normal, but if it remains high, there may be an issue.
  • down-peer-region-count: The number of Regions reported by the Raft leader as having unresponsive peers.
  • offline-peer-region-count: The number of Regions with peers in the process of going offline.

In principle, it is expected that this monitoring panel occasionally has data. However, if there is data for a long time, it is necessary to investigate whether there are any issues.

5
| username: ffeenn | Original post link

Sure, thank you. If it occurs for a long time, what troubleshooting ideas are there?

6
| username: Kongdom | Original post link

miss-peer-region-count

  • Check if any TiKV instances are down or being decommissioned, and try to identify the cause of the issue.
  • Observe the region health panel to see if miss_peer_region_count is continuously decreasing.

pending-peer-region-count

  • Observe the region health panel to check if pending_peer_region_count is continuously decreasing.
  • Check the network conditions between TiKV instances, especially if the bandwidth is sufficient.

down-peer-region-count

  • Check if any TiKV instances are down, have recently restarted, or are busy.
  • Observe the region health panel to check if down_peer_region_count is continuously decreasing.
  • Check if there are any network connectivity issues between TiKV instances.
7
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.