help wantedsig/executiontype/enhancement
仓库指标
- Star
- (40,090 star)
- PR 合并指标
- (平均合并 14天 4小时) (30 天内合并 346 个 PR)
描述
Current Problem
Currently, from the explain analyze result, we can see some executor is slow, but it's hard to know the reason of the slow.
Development Task
Here is something need to do:
- refactor
execdetailsinformation of runtime collect https://github.com/pingcap/tidb/pull/18530 - Add more runtime information for Cop task, include backoff_time, backoff_time resolve_lock time, and so on. #20492
- After https://github.com/tikv/tikv/pull/7563 merged, record more information too.
- add runtime stats for below executor:
- Insert #20430
- Update #20430
- Replace #20430
- Point-Get #18666
- Batch_Point_Get #18828
- IndexLookUpJoin #19721
- IndexNestedLoopHashJoin #19721
- HashJoinExec #19721
- Load data statement #20713
-
HashAggExec, #20577 -
StreamAggExec, #20861 -
IndexLookUpExecutor, #19349 -
IndexMergeReaderExecutor, #20653 -
UnionScanExec, #20865 -
NestedLoopApplyExec -
ParallelNestedLoopApplyExec -
ProjectionExec -
SplitIndexRegionExec -
SplitTableRegionExec -
ShowDDLJobQueriesExec
- Add documents.
- 中文文档 https://github.com/pingcap/docs-cn/pull/4655
- English document https://github.com/pingcap/docs/pull/4071
- Add more tests.