Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

planner: introduce a new fix-control variable to control whether to lift plan cache restrictions temporarily #49736

Closed
qw4990 opened this issue Dec 23, 2023 · 0 comments · Fixed by #49754

Comments

@qw4990
Copy link
Contributor

qw4990 commented Dec 23, 2023

Enhancement

The current plan cache has several restrictions (see https://docs.pingcap.com/tidb/stable/sql-prepared-plan-cache), and those restrictions can be resolved by changing the code, but this involves loads of work.
In some PoC or experiment environments, we want to know the theoretical best performance if all queries can hit our plan cache, so introduce a new fix-control variable to lift all plan cache restrictions temporarily for these scenarios.

image
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant