Skip to content

集群中有大量的空子表,是否影响集群性能 #30412

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

Closed
jandison opened this issue Mar 24, 2025 · 1 comment
Closed

集群中有大量的空子表,是否影响集群性能 #30412

jandison opened this issue Mar 24, 2025 · 1 comment
Assignees
Labels
performance Performance-related questions

Comments

@jandison
Copy link

集群为3.3.2.0版本,三台物理机,replicas 3,vgroups 300,
只有一个库,一张超级表
由于业务特征,子表运行一段时间后由于数据过期策略会成为空表
目前集群中子表数7千万+,空表估计占2/5,单个vgroups中的tables数量已经达到26W+
集群节点cpu使用率在40%左右。
想问下,随着业务发展,子表会越来越多,由于数据过期策略,空表也会越来越多,vgroups中的tables量会越来越大,目前空表没有自动删除策略,如果空表越来越多且不清理,会不会对集群性能产生影响?

@jandison jandison added the performance Performance-related questions label Mar 24, 2025
@yu285
Copy link
Contributor

yu285 commented Apr 14, 2025

会有一定影响

@yu285 yu285 self-assigned this Apr 14, 2025
@yu285 yu285 closed this as completed May 8, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
performance Performance-related questions
Projects
None yet
Development

No branches or pull requests

2 participants