Enhance Split Table Stability and Usability

[nolouch]

Description

In the high concurrency practice of TiDB, split table is a hotspot solution and a common operation for users. It can help users solve hotspot issues in advance and prevent sudden traffic from being unable to handle it.

Document Collection

• Proposal doc: ${proposal doc}
• Weekly report: ${weekly report link}

Talent Challenge Program information

• Mentor of this issue: @nolouch
• Recommended skills: Go
• Estimated Workloads: 2XL

Milestones and action items

Milestone 1: Enhance the split table stability

• dive to the problem Create table causes too much time when tidb_scatter_region is enabled pingcap/tidb#24295
• Let PD check regions before splitting regions Let PD check regions before splitting regions #2733
• ratelimit about scatter operator
• All downstream use new API.

Milestone 2: Enhance the split table usability
refer: https://github.com/wentaojin/tidba, we can extend the split table syntax.

• TBD
• TBD