search

pingcap / tidb

TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://www.pingcap.com/tidb-serverless/
https://pingcap.com
Apache License 2.0
36.94k stars 5.81k forks source link

UCP: Add execution information in slow log Plan field. #15008

Open crazycs520 opened 4 years ago

crazycs520 commented 4 years ago

Description

This is the subtask of issue https://github.com/pingcap/tidb/issues/14974.

Collect execution information like explain analyze

explain analyze (see doc) will collect execution information of each operator, It is very easy to see which operator is slow.

Currently, the slow log has recorded the execution Plan (see PR), we can store the execution information of each operator in the Plan too, just like the explain analyze.

Another need todo

You need to do a benchmark test to see the performance impact.

Score

Mentor(s)

Contact the mentors: #tidb-challenge-program channel in TiDB Community Slack Workspace

Recommended Skills

Learning Materials

TennyZhuang commented 4 years ago

/pick-up-challenge

sre-bot commented 4 years ago

@TennyZhuang already had picked pingcap/tidb#15009, finish it before pick up a new one.

TennyZhuang commented 4 years ago

/pick-up-challenge

sre-bot commented 4 years ago

@TennyZhuang pick up issue success

Fullstop000 commented 4 years ago

/give-up-challenge

sre-bot commented 4 years ago

@Fullstop000 give up issue success

TennyZhuang commented 4 years ago

/pick-up-challenge

sre-bot commented 4 years ago

@TennyZhuang pick up issue success

sre-bot commented 4 years ago

This pick has been automatically canceled after more than a week.

TennyZhuang commented 4 years ago

/pick-up-challenge

sre-bot commented 4 years ago

@TennyZhuang pick up issue success

sre-bot commented 4 years ago

This pick has been automatically canceled after more than a week.