Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Show disk usage of a query in slow query and statement summary #16883

Closed
SunRunAway opened this issue Apr 28, 2020 · 15 comments · Fixed by #17132
Closed

Show disk usage of a query in slow query and statement summary #16883

SunRunAway opened this issue Apr 28, 2020 · 15 comments · Fixed by #17132
Assignees
@hidehalo
Labels
feature/accepted This feature request is accepted by product managers good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@SunRunAway
Copy link
Contributor

SunRunAway commented Apr 28, 2020 •
edited
Loading

Description

  1. Show disk usage of a query in slow query log and SLOW_QUERY table. (https://pingcap.com/docs/stable/how-to/maintain/identify-abnormal-queries/identify-slow-queries/)
  2. Show disk usage of a query in statement summary table (https://pingcap.com/docs/stable/reference/performance/statement-summary/#statement-summary-tables)

Score

  • 50

Mentor(s)

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

Recommended Skills

  • skills 1
  • skills 1

Learning Materials
@SunRunAway SunRunAway added challenge-program-2 good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/feature-request Categorizes issue or PR as related to a new feature. labels Apr 28, 2020
@SunRunAway SunRunAway mentioned this issue Apr 28, 2020
Open
14 tasks
@mmyj
Copy link
Member

mmyj commented Apr 28, 2020

pick

@mmyj
Copy link
Member

mmyj commented Apr 28, 2020

/pick-up-challenge

@sre-bot
Copy link
Contributor

sre-bot commented Apr 28, 2020

"easy" issue is not available since you have got 200 score in this repo. Please pickup "medium" or "hard" directly. Or you can pick up "easy" Issue in other repos. Thank you.

mmyj added a commit to mmyj/tidb that referenced this issue Apr 28, 2020
@mmyj
log: Show disk usage of a query in slow query and statement summary p…
7382714 
…ingcap#16883
mmyj added a commit to mmyj/tidb that referenced this issue Apr 28, 2020
@mmyj
log: Show disk usage of a query in slow query and statement summary p…
9bb8521 
…ingcap#16883

fix: table_test
mmyj added a commit to mmyj/tidb that referenced this issue Apr 28, 2020
@mmyj
log: Show disk usage of a query in slow query and statement summary p…
cdd87b6 
…ingcap#16883

fix: TestParseSlowLogFile
@mmyj mmyj mentioned this issue Apr 28, 2020
Closed
@hidehalo
Copy link
Contributor

/pick-up-challenge

@sre-bot
Copy link
Contributor

sre-bot commented May 12, 2020

@hidehalo pick up issue success

@hidehalo hidehalo mentioned this issue May 12, 2020
Merged
@sre-bot
Copy link
Contributor

sre-bot commented May 19, 2020

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

@SunRunAway
Copy link
Contributor Author

@hidehalo You should pick this issue again.

@hidehalo
Copy link
Contributor

/pick-up-challenge

@sre-bot
Copy link
Contributor

sre-bot commented May 24, 2020

@hidehalo pick up issue success

@sre-bot
Copy link
Contributor

sre-bot commented May 31, 2020

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

@qw4990 qw4990 mentioned this issue Jun 1, 2020
Closed
10 tasks
@ti-srebot ti-srebot mentioned this issue Jun 22, 2020
Merged
@SunRunAway
Copy link
Contributor Author

@hidehalo Would you like to create a documentation PR in pingcap/docs-cn?

@hidehalo
Copy link
Contributor

hidehalo commented Jul 7, 2020

@SunRunAway Yes, I'd like to. I need some guide.

@SunRunAway
Copy link
Contributor Author

These two documents may need to be modified.
https://github.com/pingcap/docs-cn/blob/master/identify-slow-queries.md
https://github.com/pingcap/docs-cn/blob/master/statement-summary-tables.md

@hidehalo
Copy link
Contributor

hidehalo commented Jul 7, 2020

@SunRunAway Ok

@hidehalo
Copy link
Contributor

hidehalo commented Jul 8, 2020

These two documents may need to be modified.
https://github.com/pingcap/docs-cn/blob/master/identify-slow-queries.md
https://github.com/pingcap/docs-cn/blob/master/statement-summary-tables.md

@SunRunAway Take a look please

pingcap/docs-cn#3923

@zz-jason zz-jason added the feature/accepted This feature request is accepted by product managers label Jul 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hidehalo hidehalo

Labels
feature/accepted This feature request is accepted by product managers good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Milestone
No milestone
5 participants
@SunRunAway @zz-jason @hidehalo @mmyj @sre-bot