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.

Sign up for GitHub

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

Jump to bottom

Support record query replan replayer info if it matches digest. #38779

Closed
Yisaer opened this issue Nov 1, 2022 · 0 comments · Fixed by #38957 or #39019
Closed

Support record query replan replayer info if it matches digest. #38779

Yisaer opened this issue Nov 1, 2022 · 0 comments · Fixed by #38957 or #39019
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@Yisaer
Copy link
Contributor

Yisaer commented Nov 1, 2022

Enhancement

Currently we use plan replayer to dump query info manually, which is no convenient if the target plan can't be reproduced stablely.

A proper way to capture the wanted plan replayer info is to register the sql and plan digest in tidb-server, then dump the plan replayer info in any query matches the digest.
@Yisaer Yisaer added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner labels Nov 1, 2022
@Yisaer Yisaer mentioned this issue Nov 1, 2022
Merged
1 task
ti-chi-bot pushed a commit that referenced this issue Nov 2, 2022
@Yisaer
executor: refactor plan replayer exec (#38786)
07a0ef2 
ref #38779
This was referenced Nov 3, 2022
Merged
Merged
ti-chi-bot pushed a commit that referenced this issue Nov 8, 2022
@Yisaer
planner: support record table runtime stats during optimize (#38876)
ad4d432 
ref #38779
ti-chi-bot pushed a commit that referenced this issue Nov 10, 2022
@Yisaer
domain: support plan_replayer_status system table (#38957)
066e9c8 
close #38779
@Yisaer Yisaer mentioned this issue Nov 10, 2022
Merged
1 task
ti-chi-bot pushed a commit that referenced this issue Nov 11, 2022
@Yisaer
domain: support plan_replayer_task system table (#39019)
ddb4355 
close #38779
@Yisaer Yisaer mentioned this issue Nov 11, 2022
Merged
4 tasks
@Yisaer Yisaer reopened this Nov 14, 2022
This was referenced Nov 14, 2022
Merged
Closed
ti-chi-bot pushed a commit that referenced this issue Nov 16, 2022
@Yisaer
domain: support dump plan replayer capture task during query (#39125)
5aa66cb 
ref #38779
@Yisaer Yisaer mentioned this issue Nov 16, 2022
Merged
1 task
ti-chi-bot pushed a commit that referenced this issue Nov 17, 2022
@Yisaer
parser, executor: implement plan replayer capture statement (#39181)
9c48480 
ref #38779
@Yisaer Yisaer mentioned this issue Nov 23, 2022
Merged
2 tasks
ti-chi-bot pushed a commit that referenced this issue Dec 7, 2022
@Yisaer
domain: support plan replayer dump workers running in concurrency (#3…
a0a16d7 
…9347)

ref #38779
@Yisaer Yisaer closed this as completed Feb 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
1 participant
@Yisaer