Skip to content

Accelerate Meta KV Restore During PITR #61318

@3pointer

Description

@3pointer

Enhancement

As metadata scales up, listing all entries can require a large number of requests and connections—especially on HTTP/1.1 storage backends (such as some MinIO setups), where each request opens a new TCP connection. This leads to heavy connection churn, increased load on clients and servers, and a higher risk of hitting connection limits, slowdowns, or throttling.
While listing can become slow under these conditions, the primary performance bottleneck often shifts to downloading all metadata files locally after listing.

Current Challenges:

  1. Listing Speed
    - When the metadata volume is very large, listing all metadata (e.g., with S3 or MinIO) becomes increasingly slow, especially due to connection overhead and limits with HTTP/1.1.
    - However, listing is only part of the entire process.

  2. Download Bottleneck
    - After listing, all metadata files must be downloaded locally before further processing.
    - As metadata accumulates over time, the amount of data to be downloaded grows, and the download phase becomes the main bottleneck in terms of both time and resource consumption.
    - Large numbers of small metadata files can result in significant network and disk overhead.

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-8.5This bug affects the 8.5.x(LTS) versions.component/brThis issue is related to BR of TiDB.report/customerCustomers have encountered this bug.type/enhancementThe issue or PR belongs to an enhancement.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions