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

Table level data imbalance between "BE" nodes #45354

Open
dasenlin007520 opened this issue May 9, 2024 · 0 comments
Open

Table level data imbalance between "BE" nodes #45354

dasenlin007520 opened this issue May 9, 2024 · 0 comments
Labels
type/enhancement Make an enhancement to StarRocks

Comments

@dasenlin007520
Copy link

Due to the expansion of BE nodes, there was inconsistency in storage space size between nodes during the expansion period. After the expansion, the space size of each node was finally consistent. Although the space utilization was balanced at the "BE" level, the table level was skewed. Can the system automatically detect and perform table level data balancing.

mysql:[sjzx_db] 16:43:54> ADMIN SHOW REPLICA DISTRIBUTION FROM xxx.xxx_log;
+-----------+------------+-------+---------+
| BackendId | ReplicaNum | Graph | Percent |
+-----------+------------+-------+---------+
| 67298876 | 8 | > | .53 % |
| 69126805 | 7 | > | .46 % |
| 71445958 | 5 | > | .33 % |
| 73254707 | 7 | > | .46 % |
| 74637623 | 9 | > | .59 % |
| 76239860 | 97 | > | 6.40 % |
| 77346649 | 272 | >>> | 17.95 % |
| 79645200 | 301 | >>> | 19.87 % |
| 80830112 | 106 | > | 7.00 % |
| 82190724 | 288 | >>> | 19.01 % |
| 83539009 | 182 | >> | 12.01 % |
| 85046874 | 233 | >> | 15.38 % |
+-----------+------------+-------+---------+
12 rows in set (0.00 sec)

@dasenlin007520 dasenlin007520 added the type/enhancement Make an enhancement to StarRocks label May 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement Make an enhancement to StarRocks
Projects
None yet
Development

No branches or pull requests

1 participant