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

br: mysql privilege tables restore acceleration #58757

Open
BornChanger opened this issue Jan 7, 2025 · 0 comments
Open

br: mysql privilege tables restore acceleration #58757

BornChanger opened this issue Jan 7, 2025 · 0 comments
Labels
component/br This issue is related to BR of TiDB. severity/major type/enhancement The issue or PR belongs to an enhancement.

Comments

@BornChanger
Copy link
Contributor

BornChanger commented Jan 7, 2025 •
edited
Loading

Enhancement

Currently, br full restore by default restores mysql tables including mysql.bind_info, mysql.user, mysql.global_priv, mysql.global_grants, mysql.default_roles, and mysql.role_edges. And the restoration is via sql statement of replace into.

If the tidb cluster has tens of thousands or even millions of users, restoring those system tables can cost hours. BR needs to optimize the system table restoration. One possible optimization is to rework the process when those system tables' schemas are not changed.
@BornChanger BornChanger added component/br This issue is related to BR of TiDB. severity/major type/enhancement The issue or PR belongs to an enhancement. labels Jan 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component/br This issue is related to BR of TiDB. severity/major type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@BornChanger