help wantedsig/executiontype/enhancement
Metriche repository
- Star
- (40.090 star)
- Metriche merge PR
- (Merge medio 14g 4h) (346 PR mergiate in 30 g)
Descrizione
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.