The Region split by the Split Region statement will be controlled by the Region merge scheduling in PD

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

Original topic: Split Region 语句切分的 Region 会受到 PD 中 Region merge 调度的控制

| username: andone

[TiDB Usage Environment] Production Environment
[TiDB Version] v4.0.13
[Reproduction Path]
[Encountered Problem: Problem Phenomenon and Impact] Manually split regions to pre-split tables, but the empty regions are merged after one hour. How to configure this without affecting the global settings?

| username: andone | Original post link

If the value of split-merge-interval is configured as shown in the diagram, it will also affect other tables that need to merge regions. Is there a parameter to control it so that it only applies to manually pre-split tables and does not affect other tables?

| username: andone | Original post link

Does anyone know? Do you have to disable the region merge feature when using the region pre-split feature?

| username: 小龙虾爱大龙虾 | Original post link

The split-merge-interval is originally effective for manually split regions, right?

| username: andone | Original post link

You’re right, it seems that v4.0 can only use this method. I just looked it up and from v5 onwards, you can use ALTER TABLE t ATTRIBUTES ‘merge_option=deny’;

| username: andone | Original post link

Marking for everyone’s reference.

| username: dba远航 | Original post link

Learned.

| username: system | Original post link

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