Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 生产环境tidb 测试集群tikv leade数量和region异常增长
【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】v7.5.1
【Reproduction Path】What operations were performed that caused the issue
【Encountered Issue: Issue Phenomenon and Impact】
【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots/Logs/Monitoring】
Suddenly, the empty-region-count and undersized-region-count increased.
Check the DDL, it should be that an empty table was manually created, pre-split into many regions, or manually split.
The default value of tidb_dml_batch_size is 2000.
Additionally, there are partition tables based on time, such as those created monthly up to the year 2025, with pre-split parameters added. The empty-region-count and undersized-region-count will both increase and decrease relatively slowly, which is normal.
The image is not available for translation. Please provide the text content directly.
Please share the DDL of this table.
Need to confirm the table structure, is it a partitioned table?
Isn’t there a problem with having 8192 partitions for the partition key?
Since the partition keys are already time fields, why not use range partitioning…
Just go to SELECT * FROM INFORMATION_SCHEMA.TIKV_REGION_STATUS; and check which table has the most empty regions.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: 田帅萌7
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: