Skip to content

Multi-schema adding index should not trigger merge step #52004

@tangenta

Description

@tangenta

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Add multiple indexes for 1TB sysbench table, for example

alter table sbtest1 
  add index idx_p(pad),
  add index idx_k(k),
  add index idx_c(c);

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

TiDB should not run merge sort because the dataset is not large enough.

3. What did you see instead (Required)

TiDB run merge sort step.

img_v3_0296_5456d25a-ebc2-42e4-855b-5d3f8e82b21g

It may take more than 100% time to complete.

4. What is your TiDB version? (Required)

69c26ae

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions