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

Reorg with empty table too slow #100

Closed
Tracked by #1 ...
Defined2014 opened this issue May 27, 2022 · 0 comments · May be fixed by #104
Closed
Tracked by #1 ...

Reorg with empty table too slow #100

Defined2014 opened this issue May 27, 2022 · 0 comments · May be fixed by #104

Comments

@Defined2014
Copy link
Collaborator

Defined2014 commented May 27, 2022

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(a int);
alter table t add index i1(a), add index i2(a), add index i3(a);

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

Finish in 3s.

3. What did you see instead (Required)

Cost more than 8s.

4. What is your TiDB version? (Required)

Because of async commit, reorg will wait 2.5s to guarantee all txn started before ddl are committed. For multi-schema change, wait 2.5s is enough.

@Defined2014 Defined2014 changed the title Add Index too slow Reorg empty table too slow May 27, 2022
@Defined2014 Defined2014 changed the title Reorg empty table too slow Reorg with empty table too slow May 27, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant