help wantedsig/executiontype/enhancement
Repository metrics
- Stars
- (40,090 stars)
- PR merge metrics
- (平均マージ 14d 4h) (30d で 346 merged PRs)
説明
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.