pingcap / pingcap/docs

TiDB supports plan cache for the partitioned tables

Open
#19,227 4 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
617
Forks
724
Avg merge
2d 10h
Merged PRs (30d)
223

Description

File: /release-8.1/partitioned-table.md

This statement needs to be removed.:
Currently, static pruning mode does not support plan cache for both prepared and non-prepared statements.

From the DMR 8.0 release:
Remove some limitations on execution plan cache #49161 @mjonss @qw4990

TiDB supports plan cache, which can effectively reduce the latency of OLTP systems and is important for performance.

Contributor guide

Open the contributing guide

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

Open release-8.1/partitioned-table.md and locate the statement that static pruning does not support plan cache for prepared and non-prepared statements. Review the linked DMR 8.0 plan-cache change for context, then remove the outdated limitation and verify the rendered documentation no longer makes that claim.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, documentation
Issue type
Documentation
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
50/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.