Skip to content

*: hide the system variables tidb_track_aggregate_memory_usage#23184

Merged
wshwsh12 merged 14 commits intopingcap:masterfrom
wshwsh12:test-tpch
Mar 12, 2021
Merged

*: hide the system variables tidb_track_aggregate_memory_usage#23184
wshwsh12 merged 14 commits intopingcap:masterfrom
wshwsh12:test-tpch

Conversation

@wshwsh12
Copy link
Contributor

@wshwsh12 wshwsh12 commented Mar 9, 2021 •
edited
Loading

What problem does this PR solve?

Issue Number: close #xxx

Problem Summary:

What is changed and how it works?

Proposal: xxx

What's Changed:

How it Works:

  1. Remove the system variable tidb_track_aggregate_memory_usage.
  2. Track memory usage of aggregate executor by default.

Related changes

  • PR to update pingcap/docs/pingcap/docs-cn:

Check List

Tests

  • Unit test
  • Integration test

Side effects

  • Performance regression
    • Consumes more CPU
    • Consumes more MEM
  • Breaking backward compatibility

Release note

  • Tracking memory usage of Aggregate function GA.

@ti-chi-bot ti-chi-bot added do-not-merge/work-in-progress Indicates that a PR should not merge because it is a work in progress. size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. needs-rebase Indicates a PR cannot be merged because it has merge conflicts with HEAD. size/M Denotes a PR that changes 30-99 lines, ignoring generated files. and removed size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. labels Mar 9, 2021
@github-actions github-actions bot added sig/execution SIG execution sig/sql-infra SIG: SQL Infra labels Mar 10, 2021
@ti-chi-bot ti-chi-bot removed the needs-rebase Indicates a PR cannot be merged because it has merge conflicts with HEAD. label Mar 10, 2021
@wshwsh12 wshwsh12 changed the title *: open option to test tpch *: remove the system variables tidb_track_aggregate_memory_usage Mar 10, 2021
@wshwsh12 wshwsh12 marked this pull request as ready for review March 10, 2021 08:54
@wshwsh12 wshwsh12 requested a review from a team as a code owner March 10, 2021 08:54
@wshwsh12 wshwsh12 requested review from XuHuaiyu and removed request for a team March 10, 2021 08:54
@ti-chi-bot ti-chi-bot removed the do-not-merge/work-in-progress Indicates that a PR should not merge because it is a work in progress. label Mar 10, 2021
@wshwsh12 wshwsh12 mentioned this pull request Mar 10, 2021
Merged
11 tasks
@ti-chi-bot ti-chi-bot added size/S Denotes a PR that changes 10-29 lines, ignoring generated files. and removed size/M Denotes a PR that changes 30-99 lines, ignoring generated files. labels Mar 11, 2021
@wshwsh12 wshwsh12 changed the title *: remove the system variables tidb_track_aggregate_memory_usage *: hide the system variables tidb_track_aggregate_memory_usage Mar 11, 2021
XuHuaiyu
XuHuaiyu reviewed Mar 11, 2021
View reviewed changes
session/bootstrap.go
if ver >= version66 {
return
}
mustExecute(s, "set @@global.tidb_track_aggregate_memory_usage = 1")
Copy link
Contributor

@XuHuaiyu XuHuaiyu Mar 11, 2021

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Add a test case for this.
Check the value in version65 and version66

@ti-chi-bot ti-chi-bot added size/M Denotes a PR that changes 30-99 lines, ignoring generated files. and removed size/S Denotes a PR that changes 10-29 lines, ignoring generated files. labels Mar 11, 2021
@wshwsh12 wshwsh12 requested a review from XuHuaiyu March 11, 2021 09:11
ichn-hu
ichn-hu requested changes Mar 11, 2021
View reviewed changes
Copy link
Contributor

@ichn-hu ichn-hu left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Rest LGTM

@wshwsh12 wshwsh12 requested a review from ichn-hu March 11, 2021 15:39
XuHuaiyu
XuHuaiyu reviewed Mar 12, 2021
View reviewed changes
Copy link
Contributor

@XuHuaiyu XuHuaiyu left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@ti-chi-bot
Copy link
Member

ti-chi-bot commented Mar 12, 2021

@XuHuaiyu: Please use /LGTM instead of LGTM when you want to approve the pull request by comment.
If you use the GitHub review feature, please approve the PR directly, the comment will not take effect in the GitHub review feature.
If you have any qustions please refer to lgtm command help or lgtm plugin design.

If you have approved this PR, please ignore this reply. This reply is being used as a temporary reply during the migration of the new bot and will be removed on April 1.

Details

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

@XuHuaiyu XuHuaiyu added the priority/release-blocker This issue blocks a release. Please solve it ASAP. label Mar 12, 2021
@ti-chi-bot ti-chi-bot added the status/LGT1 Indicates that a PR has LGTM 1. label Mar 12, 2021
@XuHuaiyu
Copy link
Contributor

XuHuaiyu commented Mar 12, 2021

/LGTM

@ti-chi-bot
Copy link
Member

ti-chi-bot commented Mar 12, 2021

[REVIEW NOTIFICATION]

This pull request has been approved by:

  • XuHuaiyu
  • ichn-hu

To complete the pull request process, please ask the reviewers in the list to review by filling /cc @reviewer in the comment.
After your PR has acquired the required number of LGTMs, you can assign this pull request to the committer in the list by filling /assign @committer in the comment to help you merge this pull request.

The full list of commands accepted by this bot can be found here.

Details

Reviewer can indicate their review by writing /lgtm in a comment.
Reviewer can cancel approval by writing /lgtm cancel in a comment.

@ti-chi-bot ti-chi-bot added status/LGT2 Indicates that a PR has LGTM 2. and removed status/LGT1 Indicates that a PR has LGTM 1. labels Mar 12, 2021
@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/merge

@ti-chi-bot
Copy link
Member

ti-chi-bot commented Mar 12, 2021

This pull request has been accepted and is ready to merge.

DetailsCommit hash: b7d04cc

@ti-chi-bot ti-chi-bot added the status/can-merge Indicates a PR has been approved by a committer. label Mar 12, 2021
@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/run-all-tests

@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/run-unit-test

@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/run-all-tests

@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/run-all-tests

@ti-chi-bot
Copy link
Member

ti-chi-bot commented Mar 12, 2021

@wshwsh12: Your PR was out of date, I have automatically updated it for you.

At the same time I will also trigger all tests for you:

/run-all-tests

If the CI test fails, you just re-trigger the test that failed and the bot will merge the PR for you after the CI passes.

Details

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/rebuild

@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/run-unit-test

@wshwsh12
Copy link
Contributor Author

wshwsh12 commented Mar 12, 2021

/run-all-tests

@wshwsh12 wshwsh12 merged commit 1d99292 into pingcap:master Mar 12, 2021
@ti-srebot ti-srebot mentioned this pull request Mar 19, 2021
Merged
11 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@XuHuaiyu XuHuaiyu XuHuaiyu left review comments

@ichn-hu ichn-hu ichn-hu approved these changes

Assignees

No one assigned

Labels

priority/release-blocker This issue blocks a release. Please solve it ASAP. sig/execution SIG execution sig/sql-infra SIG: SQL Infra size/M Denotes a PR that changes 30-99 lines, ignoring generated files. status/can-merge Indicates a PR has been approved by a committer. status/LGT2 Indicates that a PR has LGTM 2.

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

4 participants

@wshwsh12 @ti-chi-bot @XuHuaiyu @ichn-hu