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.

Sign up for GitHub

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

Jump to bottom

Load infoschema operation in domain takes a long time #45385

Open
zimulala opened this issue Jul 17, 2023 · 0 comments
Open

Load infoschema operation in domain takes a long time #45385

zimulala opened this issue Jul 17, 2023 · 0 comments
Labels
sig/sql-infra SIG: SQL Infra type/enhancement The issue or PR belongs to an enhancement.

Comments

@zimulala
Copy link
Contributor

Enhancement

Currently, when the load schema operation is executed on a cluster with hundreds of thousands of tables, the time and memory consumption are large. In particular, taking a long time can lead to some problems: #45176

I tested the scenario myself:

Benchbot cluster, 1 TiDB, 3 TiKV, upgrade from v6.5.2 to v7.2.0
Make the first reload take 54s(create 500,000 tables ) in domain.Init for v7.2.0 branch.

At present, in addition to TiDB startup, the system information will be fully loaded, most of the other cases are incremental load table structure. But the problem still exists.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
sig/sql-infra SIG: SQL Infra type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@zimulala