pingcap / pingcap/tidb

Scheduled task too frequently triggered by plan replayer capture

Open
#56,996 0 comments 0 reactions 0 assignees 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
We found the following sql is reported as top slow queries frequently.
select `sql_digest` , `plan_digest` from `mysql` . `plan_replayer_task`;

From source code, it seems like this scheduled task executes every 10s. It maybe too frequently and every time it runs, the task consumes unnecessary resource. Please help to improve this behavior more efficiently.

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.