pingcap / pingcap/tidb

Record detailed diagnostic information during query optimization and dump to plan replayer

Open
#43,069 1 comment 0 reactions 1 assignee Claimed by @time-and-fate View on GitHub
component/statistics sig/planner type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
In previous oncall investigations, there have been several times where we are unable to locate the root cause.

To solve such problems more thoroughly, we want to introduce a mechanism to record everything that happened during the optimization process. The target is to make sure we are able to explain why a plan is chosen as long as it can be reproduced in the customer cluster and we can get a plan replayer file.

Since we already have plan replayer and plan replayer capture, I think it's a good choice to integrate the new information into them.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.