Skip to content

statistics: build global statistics for table partition#18717

Closed
lysu wants to merge 4 commits intopingcap:masterfrom
lysu:dev-analyze-ptable
Closed

statistics: build global statistics for table partition#18717
lysu wants to merge 4 commits intopingcap:masterfrom
lysu:dev-analyze-ptable

Conversation

@lysu
Copy link
Contributor

@lysu lysu commented Jul 21, 2020 •
edited
Loading

What problem does this PR solve?

Issue Number: ref #18551

Problem Summary:

to support planner select index before pruning

What is changed and how it works?

What's Changed:

  • full analyze build ranges for all partition in a table and collect stats as one table(make columns or unique index stats works)
  • make planner query stats by tableID instead of partitionID when it's new version partition table
  • handle non-unique index stats in the partition table
  • handle incremental analyze
  • handle fast analyze
  • handle feedback
  • make show/export/import works well
  • fix cut-over problem

How it Works:

Related changes

  • n/a

Check List

Tests

  • Unit test
  • Integration test
  • Manual test

Side effects

  • n/a

Release note

  • No release note.

This change is Reviewable

@github-actions github-actions bot added sig/sql-infra SIG: SQL Infra sig/execution SIG execution labels Jul 21, 2020
@codecov
Copy link

codecov bot commented Aug 5, 2020 •
edited
Loading

Codecov Report

Merging #18717 into master will increase coverage by 0.1866%.
The diff coverage is 85.2842%.

@@               Coverage Diff                @@
##             master     #18717        +/-   ##
================================================
+ Coverage   79.0545%   79.2412%   +0.1866%     
================================================
  Files           546        546                
  Lines        148433     148313       -120     
================================================
+ Hits         117343     117525       +182     
+ Misses        21614      21289       -325     
- Partials       9476       9499        +23

@lysu
Copy link
Contributor Author

lysu commented Aug 7, 2020

/run-all-tests

@lysu lysu marked this pull request as ready for review August 7, 2020 06:21
@lysu lysu requested review from a team as code owners August 7, 2020 06:21
@lysu lysu requested review from hanfei1991 and qw4990 and removed request for a team August 7, 2020 06:21
@lysu lysu removed the status/WIP label Aug 7, 2020
@lysu lysu requested review from tiancaiamao and winoros and removed request for hanfei1991 August 7, 2020 07:31
tiancaiamao
tiancaiamao reviewed Aug 11, 2020
View reviewed changes
ddl/ddl_api.go Outdated
Copy link
Contributor

@tiancaiamao tiancaiamao Aug 11, 2020

Choose a reason for hiding this comment

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

Why store this info?

Copy link
Contributor Author

@lysu lysu Aug 12, 2020 •
edited
Loading

Choose a reason for hiding this comment

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

emmm..we need one method to cut off old stats to new stats...

current code chooses new partition tables use new stats and old partition tables use old stats, and add IsNewPartition flag to mark it...maybe we need more discuss about how to "switch old stats to new stats" or "switch old partition to new partition"

tryOldPartitionImplementation at here, just make test can run test in both new/old stats format.

Copy link
Contributor

@tiancaiamao tiancaiamao Aug 17, 2020

Choose a reason for hiding this comment

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

tryOldPartitionImplementation is a runtime flag.
I mean, do we have to persistent the flag in the model.TableInfo? That flag is stored in the storage, and may bring compatible issue.

@lysu lysu mentioned this pull request Aug 12, 2020
Merged
@lysu
Copy link
Contributor Author

lysu commented Aug 13, 2020 •
edited
Loading

@tiancaiamao this pr became too large, I will split it tody - -~

@lysu lysu mentioned this pull request Aug 13, 2020
Closed
lysu
lysu commented Aug 13, 2020
View reviewed changes
cmd/explaintest/r/select.result Outdated
Copy link
Contributor Author

@lysu lysu Aug 13, 2020 •
edited
Loading

Choose a reason for hiding this comment

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

we cannot get a stable est count after change to global status that range query using sample based column histogram.
(before this pr it's full tablescan and can use table count directly)

so need improve explain test firstly - -

@lysu
Copy link
Contributor Author

lysu commented Aug 17, 2020

/run-all-tests tikv=pr/8443

@lysu
Copy link
Contributor Author

lysu commented Aug 17, 2020

/run-integration-ddl-test tikv=pr/8443

@lysu lysu mentioned this pull request Aug 17, 2020
Closed
@lysu lysu marked this pull request as draft September 1, 2020 11:28
@lysu
Copy link
Contributor Author

lysu commented Sep 2, 2020

/rebuild

@lysu
Copy link
Contributor Author

lysu commented Sep 3, 2020

/run-unit-test

@lysu
Copy link
Contributor Author

lysu commented Sep 3, 2020

/run-all-tests

@lysu
Copy link
Contributor Author

lysu commented Sep 3, 2020

/run-integration-compatibility-test

@lysu
Copy link
Contributor Author

lysu commented Sep 3, 2020

/run-all-tests

@lysu
Copy link
Contributor Author

lysu commented Sep 3, 2020

/run-check_dev_2

This was referenced Sep 7, 2020
Merged
Merged
@lysu
Copy link
Contributor Author

lysu commented Sep 10, 2020

/run-all-tests tidb-test=pr/1086

@qw4990 qw4990 removed their request for review September 11, 2020 06:24
@lysu lysu mentioned this pull request Sep 25, 2020
Closed
@lysu
Copy link
Contributor Author

lysu commented Sep 25, 2020

/run-all-tests

1 similar comment
@lysu
Copy link
Contributor Author

lysu commented Sep 25, 2020

/run-all-tests

@lysu
Copy link
Contributor Author

lysu commented Sep 25, 2020

/run-check_dev_2

@lysu
Copy link
Contributor Author

lysu commented Sep 27, 2020

/test-check_dev_2

@lysu
Copy link
Contributor Author

lysu commented Sep 27, 2020

/run-all-tests

This was referenced Sep 27, 2020
Merged
Merged
@lysu
Copy link
Contributor Author

lysu commented Sep 28, 2020

/run-all-tests

@marsishandsome marsishandsome mentioned this pull request Oct 19, 2020
Open
@lysu lysu closed this Nov 2, 2020
@lysu lysu mentioned this pull request Dec 23, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@tiancaiamao tiancaiamao tiancaiamao left review comments

@winoros winoros Awaiting requested review from winoros

Assignees

No one assigned

Labels

component/executor component/statistics sig/execution SIG execution sig/sql-infra SIG: SQL Infra

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

3 participants

@lysu @tiancaiamao @AndreMouche