pingcap/tidb

improve the executor runtime information collection

Open

#18.663 aperta il 17 lug 2020

Vedi su GitHub
 (2 commenti) (3 reazioni) (0 assegnatari)Go (6186 fork)batch import
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 execdetails information 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
  • 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.
  • Add more tests.

Guida contributor