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.