pingcap / pingcap/tiflash

Allow `ALTER TABLE ... COMPACT` to run concurrently under multiple tenants

Open
#8,822 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

component/storage type/feature-request
Dominant language
C++
Stars
1k
Forks
423
Avg merge
1d 15h
Merged PRs (30d)
24

Description

Feature Request

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

Describe the feature you'd like:

Now when deployed with multiple tenants, the ALTER TABLE ... COMPACT is restrict to 1 for all tenants

Related docs: https://docs.pingcap.com/tidb/stable/sql-statement-alter-table-compact

Describe alternatives you've considered:

Let ALTER TABLE ... COMPACT run concurrently under multiple tenants. While with limited impact to the online business. This may depend on the "remote compaction" feature.

Teachability, Documentation, Adoption, Migration Strategy:

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the linked ALTER TABLE ... COMPACT documentation and investigate how the current single-tenant restriction is implemented. The issue names no source files, tests, or entry points; done means compaction can run concurrently for multiple tenants while keeping online-business impact limited, potentially using remote compaction.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, sql
Domain
backend, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.