pingcap / pingcap/tidb

add index ingest mode should support queuing

Open
#42,211 0 comments 0 reactions 0 assignees View on GitHub
type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

**Is your feature request related to a problem? Please describe:**

when running sysbench prepare to populate 50 tables, when creating 50 secondary indexes, most of the add index is fall back to `txn merge`, which slowdown the whole add indexes process. We need to provide ingest queue to speed up the whole process when they are large number concurrent add index ssl sql request

**Describe the feature you'd like:**

add index ingest mode queuing, to improve the performance and resource manager.

**Describe alternatives you've considered:**

**Teachability, Documentation, Adoption, Migration Strategy:**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.