When does the region of a table change?

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

Original topic: 请问表的region什么时候会发生变化?

| username: HTAP萌新

As mentioned, after a few hours, I found that the regions shown by show table regions had changed, even though there were no data insertions or modifications, only queries. Are regions dynamically changing? Is there any rule for this?

【TiDB Environment】Production / Testing / PoC
【TiDB Version】
【Reproduction Steps】What operations were performed that led to the issue
【Encountered Issue: Symptoms and Impact】
【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots / Logs / Monitoring】

| username: 大飞哥online | Original post link

Inserts, deletions, load imbalance, region heartbeat timeouts, etc., will all change the position, number, and size.

| username: HTAP萌新 | Original post link

Is it possible to modify the configuration to disable region rebalancing?

| username: 大飞哥online | Original post link

You can manually modify region distribution and other information using pd-ctl. For details, you can refer to the documentation:

It contains the command parameters for region.

| username: Kongdom | Original post link

It changes in real-time, and users do not need to worry about the specific location.

| username: HTAP萌新 | Original post link

Thank you!

| username: HTAP萌新 | Original post link

Thank you, bro.

| username: system | Original post link

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