Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

region distribution not balance in create table with enable tidb_scatter_region in cluster level #55184

Closed
River2000i opened this issue Aug 5, 2024 · 3 comments · Fixed by #56157
Assignees
Labels
component/ddl This issue is related to DDL of TiDB. severity/major type/enhancement The issue or PR belongs to an enhancement.

Comments

@River2000i
Copy link
Contributor

River2000i commented Aug 5, 2024

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. enable tidb_scatter_region
  2. create table to split region

2. What did you expect to see? (Required)

region distribution should balance in cluster level

3. What did you see instead (Required)

image

  1. create table t1 (a int, b int,index idx1(a)) shard_row_id_bits = 10 pre_split_regions=8;
  2. create table t1 (a int, b int,index idx1(a));
  3. create table t1 (a int, b int,index idx1(a)) PARTITION BY RANGE(b) PARTITION p0 VALUES LESS THAN (10),PARTITION p1 VALUES LESS THAN (20));

4. What is your TiDB version? (Required)

mysql> select version();
+--------------------+
| version()          |
+--------------------+
| 8.0.11-TiDB-v8.2.0 |
+--------------------+
1 row in set (0.04 sec)
@River2000i River2000i added the type/bug The issue is confirmed as a bug. label Aug 5, 2024
@River2000i River2000i changed the title region create table with enable tidb_scatter_region region distribution not balance in create table with enable tidb_scatter_region in cluster level Aug 5, 2024
@River2000i
Copy link
Contributor Author

/assign @River2000i

@River2000i
Copy link
Contributor Author

/label affects-8.1

@River2000i
Copy link
Contributor Author

/label affects-7.5
/label affects-7.1
/label affects-6.5
/label affects-6.1
/label affects-5.4

@Benjamin2037 Benjamin2037 added type/enhancement The issue or PR belongs to an enhancement. and removed type/bug The issue is confirmed as a bug. affects-5.4 This bug affects 5.4.x versions. affects-6.1 affects-6.5 affects-7.1 affects-7.5 affects-8.1 labels Sep 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/ddl This issue is related to DDL of TiDB. severity/major type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
3 participants